Re: LINE 1: IDENTIFY_SYSTEM error infinitum - Mailing list pgsql-general

From Zoid
Subject Re: LINE 1: IDENTIFY_SYSTEM error infinitum
Date
Msg-id 4C2BB62A.3050207@the-lounge.us
Whole thread Raw
In response to Re: LINE 1: IDENTIFY_SYSTEM error infinitum  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: LINE 1: IDENTIFY_SYSTEM error infinitum  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom,

Actually, I'm using postgresql beta2 and my replication process is
connectiong to my primary (or backend) at 5432 via the connect_info line
of the recovery.conf file.

I had already saw that the error is identical if I merely connect
directly to the primary and issue the command "IDENTITY_SYSTEM", so it
seems to me the primary (or backend) is not treating the IDENTITY_SYSTEM
command as "Streaming Replication Protocol", but I'm not sure why it
would anyway as I've connected to thesame port psql does.

Tom Lane wrote:
> Zoid <Zoid@the-lounge.us> writes:
>
>> Can anyone see why I keep getting the below "IDENTIFY_SYSTEM" error in
>> my logs when I start my replication database process?
>>
>
> Are you sure the primary is 9.0?  It sure looks like you're getting a
> plain backend connection instead of a walsender, which is what I'd
> expect to happen if the server were too old to recognize the replication
> parameter in the connection request.
>
>             regards, tom lane
>
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: LINE 1: IDENTIFY_SYSTEM error infinitum
Next
From: mirthcyy
Date:
Subject: Execute permission for functions