Hi,
just out of curiosity, what's the difference between "streaming" and
"catchup" state in pg_stat_replication.
According to the documentation this field is "Current WAL sender state".
But that does not tell me anything.
Thanks,
Torsten
--
Sent via pgsql-general mailing list (pgsql-general@p
On Mon, Apr 21, 2014 at 8:03 PM, Torsten Förtsch
wrote:
> Hi,
>
> just out of curiosity, what's the difference between "streaming" and
> "catchup" state in pg_stat_replication.
>
> According to the documentation this field is "Current WAL sender state".
> But that does not tell me anything.
>
When
On 21/04/14 13:18, Michael Paquier wrote:
> When a standby connects for the first time to a primary, it is not yet
> synchronized, this is the "catchup" phase. Once the lag between the
> standby and the master is reduced to zero for the first time,
> replication state changes to "streaming".
Thank
On Mon, Apr 21, 2014 at 8:34 PM, Torsten Förtsch
wrote:
> On 21/04/14 13:18, Michael Paquier wrote:
> s there a difference in the protocol used in those phases? Maybe the
> catchup phase is optimized for bulk throughput?
>
There is no difference AFAIK, the same replication protocol is used:
http:/
Maybe the char array link is wrong ? I don't think an array of arrays is
good for my case. I'll probably go for json or separate table since it
looks it's not possible to use composite-types.
On Mon, Apr 21, 2014 at 4:02 AM, Rob Sargentg wrote:
> Sorry, I should not have top-posted (Dang iPhon
I ended up running some tests using 5 million rows of products. I used
about 5 properties that a product should always be matched to, and then
I used the following in the select;
(CASE property1 in (option1, option2, option3, etc) WHEN TRUE THEN 1
ELSE 0 END)
+ (CASE property2 in (option1, opt
hi,
I'v try to make a base backup use pg_start_backup, pg_stop_backup and
rsync, but failed.
After run select pg_start_backup('label') on db server, I run rsync on
backup server, and got some errors like 'file has vanished: ', think
this should be ok since it's documented in the manual. Then
On Tue, Apr 22, 2014 at 1:28 PM, wd wrote:
> I'v try to make a base backup use pg_start_backup, pg_stop_backup and
> rsync, but failed.
>
> After run select pg_start_backup('label') on db server, I run rsync on
> backup server, and got some errors like 'file has vanished: ', think
> this shou
