Postgres Pro
Downloads
Home   >   mailing lists

Re: Weird error when setting up streaming replication - Mailing list pgsql-general

From Michael Paquier
Subject Re: Weird error when setting up streaming replication
Date
Msg-id CAB7nPqR7q4d10=uCGE__KzC52pSpbw-1UpycMWBxs65+Km6J_w@mail.gmail.com
Whole thread Raw
In response to Weird error when setting up streaming replication  (Quentin Hartman <qhartman@direwolfdigital.com>)
Responses Re: Weird error when setting up streaming replication
List pgsql-general
Tree view 
On Fri, Aug 9, 2013 at 8:55 AM, Quentin Hartman
<qhartman@direwolfdigital.com> wrote:
> 2013-08-08 23:47:30 GMT LOG:  WAL file is from different database system
> 2013-08-08 23:47:30 GMT DETAIL:  WAL file database system identifier is
> 5909892614333033983, pg_control database system identifier is
> 5909892824786287231.
It looks that you are not able to detect valid checkpoint records when
replaying WAL because your new system has been initialized with a
fresh initdb, symbolized by the errors above. You should build your
new node using a base backup or a snapshot of the data folder of the
node you are trying to replace.
--
Michael

pgsql-general by date:

Previous
From: Quentin Hartman
Date:
Subject: Weird error when setting up streaming replication
Next
From: Tom Lane
Date:
Subject: Re: How To Install Extension Via Script File?