Re: [ADMIN] Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup

2012-06-06 Thread Manoj Govindassamy
Manoj Govindassamy Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup Hi, On Wed, 6 Jun 2012 14:55:15 +, Manoj Govindassamy wrote: > PG Slave gets fresh backup from PG master using pg_backup utility > everyt

Re: [ADMIN] Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup

2012-06-06 Thread Gabriele Bartolini
Hi, On Wed, 6 Jun 2012 14:55:15 +, Manoj Govindassamy wrote: PG Slave gets fresh backup from PG master using pg_backup utility everytime before it starts up That's not necessary. Usually you do this only the first time you set it up, then take advantage of the wal_keep_segments on the m

[ADMIN] Postgres 9.1 Synchronous Replication and stuck queries during sync repl setup

2012-06-06 Thread Manoj Govindassamy
Hi, I have configured PG master and slave to run under synchronous replication mode and they are mostly working fine. Except during the setup phase. Please read thru my setup, procedure and let me know if I am doing something stupid. PG master : wal_level = hot_standby max_wal_senders = 5