LINE 1: IDENTIFY_SYSTEM error infinitum

From: Zoid <Zoid(at)the-lounge(dot)us>
To: pgsql-general(at)postgresql(dot)org
Subject: LINE 1: IDENTIFY_SYSTEM error infinitum
Date: 2010-06-30 19:08:38
Message-ID: 4C2B9636.50606@the-lounge.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can anyone see why I keep getting the below "IDENTIFY_SYSTEM" error in
my logs when I start my replication database process?
I use "postgres primary" as my prefix in the syslog and "postgres
replication" as the replication one so their outputs are distinguishable.

Jun 30 14:10:25 postgres primary[19617]: [2-1] LOG: connection
received: host=192.168.2.8 port=55138
Jun 30 14:10:25 postgres primary[19617]: [3-1] LOG: connection
authorized: user=foobar database=postgres
Jun 30 14:10:25 postgres primary[19617]: [4-1] ERROR: syntax error at
or near "IDENTIFY_SYSTEM" at character 1
Jun 30 14:10:25 postgres primary[19617]: [4-2] STATEMENT: IDENTIFY_SYSTEM
Jun 30 14:10:25 postgres replication[19616]: [1-1] FATAL: could not
receive database system identifier and timeline ID from the primary
server: ERROR: syntax error at or near "IDENTIFY_SYSTEM"
Jun 30 14:10:25 postgres replication[19616]: [1-2] LINE 1:
IDENTIFY_SYSTEM
Jun 30 14:10:25 postgres replication[19616]: [1-3] ^
Jun 30 14:10:25 postgres replication[19616]: [1-4]
Jun 30 14:10:25 postgres primary[19617]: [5-1] LOG:

On primary's postgresql.conf I have this:
port = 5432
wal_level = archive # minimal, archive, or hot_standby
archive_mode = on max_wal_senders = 1 # max number of walsender
processes
#hot_standby = off

On the replication database's postgresql.conf I have this:
port = 5433
wal_level = minimal
archive_mode = off
#max_wal_senders = 0 # max number of walsender processes
hot_standby = off

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2010-06-30 19:18:48 Re: Looking for multithreaded build of libpq for Windows
Previous Message Szymon Guz 2010-06-30 18:56:09 Re: php and connection