Postgres Pro
Downloads
Home   >   mailing lists

Re: Recovery - New Slave PostgreSQL 9.2 - Mailing list pgsql-admin

From drum.lucas@gmail.com
Subject Re: Recovery - New Slave PostgreSQL 9.2
Date
Msg-id CAE_gQfX3Tm0oNASqnXy3USKxtC9_+KrBC2f=oMegrgRG9j0bbw@mail.gmail.com
Whole thread Raw
In response to Re: Recovery - New Slave PostgreSQL 9.2  (Ian Barwick <ian@2ndquadrant.com>)
Responses Re: Recovery - New Slave PostgreSQL 9.2
List pgsql-admin
Tree view
Sure... Here's the total information:

recovery.conf:
restore_command = 'exec nice -n 19 ionice -c 2 -n 7 ../../bin/restore_wal_segment.bash "../wal_archive/%f" "%p"'
archive_cleanup_command = 'exec nice -n 19 ionice -c 2 -n 7 ../../bin/pg_archivecleaup_mv.bash -d "../wal_archive" "%r"'
recovery_target_timeline = 'latest'
standby_mode = on
primary_conninfo = 'host=192.168.100.XX port=5432 user=replicator application_name=replication_new_slave'



Lucas Possamai


On 9 January 2016 at 14:37, Ian Barwick <ian@2ndquadrant.com> wrote:
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

pgsql-admin by date:

Previous
From: Ian Barwick
Date:
Subject: Re: Recovery - New Slave PostgreSQL 9.2
Next
From: "drum.lucas@gmail.com"
Date:
Subject: Re: Recovery - New Slave PostgreSQL 9.2