Re: LINE 1: IDENTIFY_SYSTEM error infinitum

Поиск
Список
Период
Сортировка
От Zoid
Тема Re: LINE 1: IDENTIFY_SYSTEM error infinitum
Дата
Msg-id 4C2BB62A.3050207@the-lounge.us
обсуждение исходный текст
Ответ на Re: LINE 1: IDENTIFY_SYSTEM error infinitum  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: LINE 1: IDENTIFY_SYSTEM error infinitum  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: LINE 1: IDENTIFY_SYSTEM error infinitum
Следующее
От: mirthcyy
Дата:
Сообщение: Execute permission for functions