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
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 |