[Pgpool-general] How to setup pgpool replication

[Devrim GUNDUZ]

Hi,

On Thu, 2006-11-23 at 12:31 +0530, Pradeep Parmar wrote:

> I'm a newbe to pgpool , How can I setup replication using pgpool? What
> is procedure ? What are the changes to be done in the config files?

Assuming that you don't want master/slave replication (it is not
pgPool's job... It is Slony-I's or Mammoth Replicator's job) here are
the steps.

* Define both servers in configuration file. In pgPool-I, the host
definitions are at the top of the config file. pgPool-I can only support
2 hosts. However, pgPool-II can support uo 128 hosts (it can support
more; but you need to define this value before building source code).
The definitions of hosts in pgPool-II is at the bottom of the config
file.

* Enable replication_mode by setting its value to true
* If you want load balancing for SELECT queries, enable
load_balance_mode.


These are the initial requirements.  I also suggest you to enable
replication_stop_on_mismatch so that the failing node will degenerate in
case of a mismatch.

Please note that your databases must be in sync before running pgpool in
replication mode.

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/




-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20061129/ea755160/attachment.bin