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

[Guillaume Lelarge]

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