I got it to work...
changed pg_hba.conf from md5 to trust for all entries on both systems.
removed still got errors; removed/recreated pgpool_status file and
restarted pgpool
Thank you.
[email protected] wrote:
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
--
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
