Re: LINE 1: IDENTIFY_SYSTEM error infinitum

From: Zoid <Zoid(at)the-lounge(dot)us>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: LINE 1: IDENTIFY_SYSTEM error infinitum
Date: 2010-06-30 21:24:58
Message-ID: 4C2BB62A.3050207@the-lounge.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)the-lounge(dot)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
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2010-06-30 21:45:14 Re: Execute permission for functions
Previous Message mirthcyy 2010-06-30 21:09:24 Execute permission for functions