[Pgpool-general] replication/failover feature in Master/Slave mode

[Sandeep Thakkar]

 Yes, user has valid permissions to create a file.

The file is not getting created. I do not see anything related to failover in 
pgpool log. I have started the pgpool using debug option. I guess, failover  
command is not getting executed. All I can see in the standby server log is 
this:
FATAL:  could not connect to the primary server: could not connect to server: 
Connection refused
                Is the server running on host "127.0.0.1" and accepting
                TCP/IP connections on port 5432?


When I manually create trigger file, then failover starts.



________________________________
From: Guillaume Lelarge <guillaume at lelarge.info>
To: Sandeep Thakkar <sandeeptt at yahoo.com>
Cc: pgpool-general at pgfoundry.org
Sent: Thu, January 27, 2011 5:41:33 PM
Subject: Re: [Pgpool-general] replication/failover feature in Master/Slave mode

Le 27/01/2011 13:06, Sandeep Thakkar a écrit :
> Here, both the dbservers and pgpool run on the single box. This may not be the 

> practical scenario, but I was just testing the features.
> Hence, I directly used touch. Is it fine then?
> 

If the user has the right to create such a file, yes. Is the file
created? do you see that your failover command is executed? is there
errors in your log file?


-- 
Guillaume
http://www.postgresql.fr
http://dalibo.com



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110127/2268debe/attachment.html>