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

[Mary Ellen Fitzpatrick]

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.

Daniel.Crespo at l-3com.com 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 
mfitzpat at bu.edu