[Pgpool-general] Setting up PGpool with PostgreSQL 9.0

[Matthew Bennett]

Guillaume Lelarge <guillaume at ...> writes:


> 
> Can you show us your pgpool.conf file?
> 

It is a the stock pgpool.conf file except for the following changes:

socket_dir = '/var/run'
pcp_socket_dir = '/var/run'
logdir = '/mnt/pgpool'
master_slave_mode = true
master_slave_sub_mode = 'stream'

pgpool2_hostname = 'localhost'

system_db_hostname = 'PG9master'

backend_hostname0 = 'PG9master'
backend_port0 = 5432
backend_weight0 = 1

backend_hostname1 = 'PG9slave'
backend_port1 = 5432
backend_weight1 = 1

I don't have a postgresql server running on the pgpool machine and so I am
running it on the PG9master.