[Pgpool-general] Incorrect port (9999) for pgpool?

[Mary Ellen Fitzpatrick]

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 
mfitzpat at bu.edu