Re: LINE 1: IDENTIFY_SYSTEM error infinitum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Zoid <Zoid(at)the-lounge(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: LINE 1: IDENTIFY_SYSTEM error infinitum
Date: 2010-06-30 22:03:52
Message-ID: 18319.1277935432@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zoid <Zoid(at)the-lounge(dot)us> writes:
> 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.

The port's not the issue --- replication connections are supposed to use
the same port. Try something like

psql -h primary-server replication=1

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2010-06-30 22:18:59 Re: Cannot open table in new database
Previous Message Adrian Klaver 2010-06-30 21:45:14 Re: Execute permission for functions