From: Ian Barwick <ian@2ndquadrant.com>
To: drum.lucas@gmail.com <drum.lucas@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Recovery - New Slave PostgreSQL 9.2
Date: Sat, 9 Jan 2016 10:37:21 +0900
Message-ID: <56906451.4010107@2ndquadrant.com> (raw)
In-Reply-To: <CAE_gQfUUJNCN6okfC-qjxeZbaJ7g1ATK8xbWq0G5VM=Eiz3=ew@mail.gmail.com>
References: <CAE_gQfUUJNCN6okfC-qjxeZbaJ7g1ATK8xbWq0G5VM=Eiz3=ew@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 16/01/09 9:23, drum.lucas@gmail.com wrote:
> Hi all!
>
> I've done the pg_basebackup from the live to a new slave server...
>
> I've recovery the wal files, but now that I configured to replicate from the master (recovery.conf) I got this error:
>
> ../wal_archive/0000000400000C68000000C8` not found
> ../wal_archive/00000005.history` not found
>
> FATAL: timeline 2 of the primary does not match recovery target timeline 1
Can you post the contents of your recovery.conf file, suitably
anonymised if necessary?
Regards
Ian Barwick
--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ian@2ndquadrant.com, drum.lucas@gmail.com
Subject: Re: Recovery - New Slave PostgreSQL 9.2
In-Reply-To: <56906451.4010107@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox