> 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.
Stop pgpool (make sure it's not running). And try running pgpool as follows: pgpool -n -d and see the output. It should help you debugging the issue. Daniel _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
