| 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: | Whole Thread | Raw Message | 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
>
>
| 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 |