[ADMIN] PG synchronous replication and unresponsive slave

2012-01-16 Thread Manoj Govindassamy
anyone with PG Synchronous Replication knowledge, please help me with your views on the below questions. thanks, Manoj On 01/12/2012 10:12 AM, Manoj Govindassamy wrote: any help on this is much appreciated. thanks, Manoj On 01/11/2012 01:50 PM, Manoj Govindassamy wrote: Hi, I have a

Re: [ADMIN] PG synchronous replication and unresponsive slave

2012-01-17 Thread Manoj Govindassamy
PM, Fujii Masao wrote: On Tue, Jan 17, 2012 at 3:51 AM, Manoj Govindassamy wrote: 1. Transaction which was stuck right when slave going away never went thru even after I reloaded master's config with local commit on. I do see all new transactions on master are going thru fine, except th

Re: [ADMIN] PG synchronous replication and unresponsive slave

2012-01-17 Thread Manoj Govindassamy
ways to detect Master PG's replication not working (via libpq would be more preferable). thanks, Manoj On 01/17/2012 05:04 PM, Fujii Masao wrote: On Wed, Jan 18, 2012 at 6:37 AM, Manoj Govindassamy wrote: (2) We are not comfortable moving to PGPool just for automatic failback mode on hot-s

[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

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

2012-06-06 Thread Manoj Govindassamy
? yes, all the servers are in same LAN. Thanks for your time. - manoj From: pgsql-admin-ow...@postgresql.org [pgsql-admin-ow...@postgresql.org] on behalf of Gabriele Bartolini [gabriele.bartol...@2ndquadrant.it] Sent: Wednesday, June 06, 2012 8:51 AM To: