[Pgpool-general] replication/failover feature in Master/Slave mode
Sandeep Thakkar
sandeeptt at yahoo.com
Thu Jan 27 08:49:36 UTC 2011
I was just testing the pgpool with one primary and one standby on the same box.
Hot Standby, Streaming replication, load balancing, all are working fine. But, I
see that failover is not happening when I shut down my primary server. When I
manually touch the trigger file, failover happens. I thought, pgpool will
execute the fail over command on it's own. Am I doing anything wrong?
Here is my related settings in pgpool.conf:
failover_command = 'touch <path_to_trigger_file>
My recovery.conf in the data directory of standby contains these variables:
standby_mode
primary_conninfo
restore_command
trigger_file
Please help.
________________________________
From: Sandeep Thakkar <sandeeptt at yahoo.com>
To: Guillaume Lelarge <guillaume at lelarge.info>
Cc: pgpool-general at pgfoundry.org
Sent: Fri, January 14, 2011 2:40:52 PM
Subject: Re: [Pgpool-general] replication/failover feature in Master/Slave mode
Thanks Guillaume.
________________________________
From: Guillaume Lelarge <guillaume at lelarge.info>
To: Sandeep Thakkar <sandeeptt at yahoo.com>
Cc: pgpool-general at pgfoundry.org
Sent: Wed, January 12, 2011 8:09:53 PM
Subject: Re: [Pgpool-general] replication/failover feature in Master/Slave mode
Hi,
Le 12/01/2011 15:10, Sandeep Thakkar a écrit :
> [...]
> I have a primary and a standby server on different boxes and both are running
>on
>
> different ports. I would like to use pgpool for Streaming Replication and
> Failover. Hence, I selected Master/Slave mode with stream. Now, I have a
> question, if I write anything on primary, how will the data be replicated on
> standby? Will it happen automatically like it does in replication mode Or do I
> need to look into Hot Standby feature of PG?
>
You need to look at the streaming replication feature of PostgreSQL. You
need Hot Standby for example if you want to use the load balacing
feature of pgPool.
> Also, on failover (let's say primary goes down for some reason), and the
>standby
>
> now takes over. Will the standby has write operations?
>
You need to write scripts for that.
> Also, in my application, will I use the pgpool port, so that I do not need to
> change the configuration file in case of failover?? With Slony, we had to tell
> the application to use the other port.
>
The pgpool port, always.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110127/5d025641/attachment.html>
More information about the Pgpool-general
mailing list