On Sat, Feb 13, 2010 at 2:13 AM, Mary Ellen Fitzpatrick <[email protected]>wrote:
> 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. Hi where can I find the pgpool_status file. I tried using locate but could not find it > > > [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 >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
