[pgpool-general: 1411] Re: pcp commands generating EOFError

[Lonni J Friedman]

Is 'db02' the pgpool server's hostname?

On Tue, Feb 19, 2013 at 3:14 PM, David Kerr <web at mr-paradox.net> wrote:
> hmm that's interesting, if i switch to 9898 i get
>
> pcp_attach_node -d 100 db02 9898 postgres pass 1
> DEBUG: could not connect to "db02"
> ConnectionError
>
> i can connect to db02 from command line psql.
>
>
>
> On Feb 19, 2013, at 3:03 PM, Lonni J Friedman <netllama at gmail.com> wrote:
>
>> You sure that you're specifying the right port number in that command?
>> Typically the pcp_* commands expect the port number of the pgpool
>> instance, not the postgres server(s).
>>
>> On Tue, Feb 19, 2013 at 3:01 PM, David Kerr <web at mr-paradox.net> wrote:
>>> Getting the following behavior:
>>>
>>>> pcp_attach_node -d 100 db02 5432 postgres superpassword 1
>>> EOFError
>>>
>>>
>>> (yes -d does nothing)
>>>
>>>
>>> on the postgres side i'm getting:
>>> Feb 19 22:54:09 ccdb02 postgres[10660]: [2-1] user=[unknown],db=[unknown],host=192.168.0.38 LOG:  invalid length of startup packet
>>>
>>>
>>> I get similar results from all pcp_ programs.
>>>
>>> Am i missing something from my configuration?
>>>
>>> Thanks
>>