[Pgpool-general] problem with installation and testing

Addison Pan addisonp at yahoo.com
Fri Mar 21 21:34:18 UTC 2008


 When I start up pgpool

user: postgres
(in /home/posgres)
>pgpool -n -d >/home/postgres/pgpool.log 2>&1 &

it seems to start up fine

but when I go check the /tmp dir
(part of pgpool.conf shown below:

# Unix domain socket path.
socket_dir = '/tmp'
)

I only see:

.s.PGSQL.5432
.s.PGSQL.5432.lock
.s.PGSQL.9898
.s.PGSQL.9999

in my pgpool.conf I have the following:

#set pgpool2 hostname
# 03/20/2008 changed from '' to 'localhost'
pgpool2_hostname = 'localhost'

# system DB info
system_db_hostname = 'localhost'
system_db_port = 5432
system_db_dbname = 'pgpool'
system_db_schema = 'pgpool_catalog'
system_db_user = 'pgpool'
system_db_password = 'pgpool'

# backend_hostname, backend_port, backend_weight
# here are examples
#backend_hostname0 = '127.0.0.1'
#backend_hostname1 = '127.0.0.1'
#backend_hostnamer21 = '127.0.0.1'


# - HBA  -

# If true, use pool_hba.conf for client authentication. In pgpool-II
# 1.1, the default value is false. The default value will be true in
# 1.2.
enable_pool_hba = false
backend_hostname0 = 'localhost'
backend_port0 = 5432
backend_weight0 = 1
backend_hostname1 = 'localhost'
backend_port1 = 5433
backend_weight1 = 1
backend_hostname2 = 'localhost'
backend_port2 = 5434
backend_weight2 = 1


does anyone have any ideas as to why 5433 and 5434 are not starting up?  I also see via the pgpoolAdmin that those 2 nodes (via node status) are down

       
---------------------------------
Looking for last minute shopping deals?  Find them fast with Yahoo! Search.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20080321/8905308c/attachment.html 


More information about the Pgpool-general mailing list