[GENERAL] pgpool HA not working

2011-07-24 Thread Sanjay Rao
Hi I am working on pgpool /postgresql/linux first time. All these three are new to me. I am running pgpool-HA using pacemaker-corosync. I am having following error in my setup. Does any body have any idea about the warning highlighted in logs ? Any type of help would be appreciated a lot...

[GENERAL] Standby server does not start with base backup

2011-06-18 Thread Sanjay Rao
Hi, I am running a test setup for verifying the warm standby feature in Postgres 9.0 release. Both my Master (Win 7 Professional, 64 bit) Standby (Win 7 Professional, 64 bit) machines are having Postgres 9.0 (postgresql-9.0.4-1-windows) installed both are in our LAN environment. After

Re: [GENERAL] streaming replication trigger file

2011-06-16 Thread Sanjay Rao
be appreciated. Regards, Sanjay Rao On 6/16/2011 2:01 PM, AI Rumman wrote: Hi all, I am a bit confused regarding streaming replication. I have two server: A and B. I set up replication successfully. But when the master A goes down, B are not acting as master. My recovery.conf as follows

Re: [GENERAL] streaming replication trigger file

2011-06-16 Thread Sanjay Rao
, the standby's identifier is 5618757422882348667. Does anybody have any idea ? Regards, Sanjay Rao On 6/16/2011 2:50 PM, Sanjay Rao wrote: Hi Rumman, Can you send me link to how to create postgres replication on windows. I tried few hours as per following link, but not succeeded. Which version

Re: [GENERAL] postgres server on windows with high availability and failover safe

2011-06-10 Thread Sanjay Rao
HI John, I would not mind to go for linux. Is there any guide to setup failover safe postgres servers on linux/windows ? I found few, but noe of them is complete/descriptive. Regards, Sanjay Rao On 6/9/2011 11:30 PM, John R Pierce wrote: On 06/09/11 2:45 AM, Sanjay Rao wrote: Hi

[GENERAL] postgres server on windows with high availability and failover safe

2011-06-09 Thread Sanjay Rao
Hi, If anybody have setup this thing earlier or have any idea about how to setup this, Please let me know. I am newbie in setting up database servers . Regards, Sanjay Rao -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

[GENERAL] how to add a replication connection entry in pg_hba.con file

2011-06-09 Thread Sanjay Rao
how to add a replication connection entry in pg_hba.con file ? I am getting this error at standby server 2011-06-09 20:37:16 IST FATAL: could not connect to the primary server: FATAL: no pg_hba.conf entry for replication connection from host 192.168.4.145, user postgres, SSL off -Sanjay