Message-ID: <53CFEE01.4080206@gmail.com>
Date: Wed, 23 Jul 2014 13:16:49 -0400
From: John Scalia <jayknowsunix@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Can't get a standby built
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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?
--
Jay


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin