From: Peter Eisentraut <peter_e@gmx.net>
To: John Scalia <jayknowsunix@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Can't get a standby built
Date: Fri, 25 Jul 2014 22:59:44 -0400
Message-ID: <1406343584.17451.0.camel@vanquo.pezone.net> (raw)
In-Reply-To: <53CFEE01.4080206@gmail.com>
References: <53CFEE01.4080206@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Wed, 2014-07-23 at 13:16 -0400, John Scalia wrote:
> Trying to rebuild my standby server (several times now). I know repeating something over and over while expecting a different result is the definition of insanity. But, I've always
> started with:
>
> /usr/pgsql-9.3/bin/pg_basebackup -h <masters_ip_address> -D /var/lib/pgsql/9.3/data -X s -c fast
>
> I then copy my recovery.conf file into the data directory, check that everything looks correct, and try to start the standby. The log consistently says something like:
>
> LOG: entering standby mode
> LOG: restored log file "00000006.history" from archive
> cp: cannot stat '/mnt/wallogs/archive/000000060000001200000059': No such file or directory
> LOG: restored log file "000000060000001200000059" from archive
> FATAL: requested timeline 6 is not a child of this server's history
> DETAIL: Latest checkpoint is at 12/5B000060 on timeline 5, but in the history of the requested timeline, the server forked off from that timeline at 12/47000000.
> LOG: startup process (PID 60870) exited with exit code 1
> LOG: Aborting startup due to startup process failure
>
> This routine has worked for me in the past and I don't understand why it won't work now. This is supposed to be a streaming replication standby server. So, do I have the wrong
> flags for pg_basebackup? Or is something else going on?
Could you show your recovery.conf file? It looks like the mistake is in
there.
--
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: peter_e@gmx.net, jayknowsunix@gmail.com
Subject: Re: Can't get a standby built
In-Reply-To: <1406343584.17451.0.camel@vanquo.pezone.net>
* 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