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

[nair rajiv]

On Sat, Feb 13, 2010 at 2:13 AM, Mary Ellen Fitzpatrick <mfitzpat at bu.edu>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

>
>
> 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
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20100213/84d71643/attachment.html>