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 <[email protected]>
To: Sandeep Thakkar <[email protected]>
Cc: [email protected]
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
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
