[Pgpool-general] Incorrect port (9999) for pgpool?
Daniel.Crespo at l-3com.com
Daniel.Crespo at l-3com.com
Fri Feb 12 20:24:19 UTC 2010
> 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
More information about the Pgpool-general
mailing list