Mary Ellen Fitzpatrick wrote:
Hi,
I am new at using pgpool and I am having some difficulty with getting
pgpool/postgres to work on port 9999. I am running CentOS5,
Postgres-8.1.18, and have installed pgpool-II-2.3.1. Even after having
read the pgpool-II manual, pgpool-II-Tutorial and Pgpool-II for
beginners, I am missing something that does not allow me connect to
pgpool via port 9999.
visantst:~$ createdb -p 9999 bench_replication
createdb: could not connect to database postgres: server closed the
connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
I can create databases if I do not use port 9999:
visantst:~$ createdb junk
Password:
CREATE DATABASE
Seems like I have incorrect ports for pgpool... and/or postgres... to
work together.
Postgres is configured/running on port 5432.
I have two servers running postgres: visantst and altman and I want to
setup replication between the two. I have installed pgpool-II on visant
and pgpool is running on port 9999:
visantst:~# netstat -antp |grep -i listen
tcp 0 0 0.0.0.0:9898
0.0.0.0:* LISTEN 28254/pgpool
tcp 0 0 0.0.0.0:139
0.0.0.0:* LISTEN 2820/smbd
tcp 0 0 0.0.0.0:5900
0.0.0.0:* LISTEN 18991/vino-server
tcp 0 0 0.0.0.0:9999
0.0.0.0:* LISTEN 28254/pgpool
pgpool running in debug mode on visantst:
pgpool -c -f /usr/local/pgpoolII/etc/pgpool.conf -a
/usr/local/pgpoolII/etc/pool_hba.conf -n -d >
/usr/local/pgpoolII/log/pgpool.log 2>&1 &
pgpool.log and the postgresql logs do not show any errors
Here are all the changes that I made to the pgpool.conf file, if not
listed, then using default value or not enabled
listen_addresses = '*'
port = 9999
pcp_port = 9898
socket_dir = '/tmp'
pcp_socket_dir = '/tmp'
backend_socket_dir = '/tmp'
logdir = '/usr/local/pgpoolII/log'
pid_file_name = '/var/run/pgpool/pgpool.pid'
replication_mode = true
health_check_period = 60
log_statement = true
log_connections = true
log_hostname = true
backend_hostname0 = 'visantst.bu.edu'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/data/pgsql/data'
backend_hostname1 = 'altman.bu.edu'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/data/pgsql/data'
enable_pool_hba = false
enable_pool_hba = true
Any help or suggestions appreciated,
--
Thanks
Mary Ellen
Mary Ellen FitzPatrick
Systems Analyst
Bioinformatics
Boston University
24 Cummington St.
Boston, MA 02215
office 617-358-2771
cell 617-797-7856
[email protected]
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
