Re: Weird error when setting up streaming replication

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Quentin Hartman <qhartman(at)direwolfdigital(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Weird error when setting up streaming replication
Date: 2013-08-09 00:23:22
Message-ID: CAB7nPqR7q4d10=uCGE__KzC52pSpbw-1UpycMWBxs65+Km6J_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 9, 2013 at 8:55 AM, Quentin Hartman
<qhartman(at)direwolfdigital(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-08-09 00:42:04 Re: How To Install Extension Via Script File?
Previous Message Quentin Hartman 2013-08-08 23:55:48 Weird error when setting up streaming replication