pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan't get a standby built
3+ messages / 3 participants
[nested] [flat]
* Can't get a standby built
@ 2014-07-23 17:16 John Scalia <jayknowsunix@gmail.com>
2014-07-23 20:33 ` Re: Can't get a standby built Jorge Fernandez <jorge.fernandez@openenglish.com>
2014-07-26 02:59 ` Re: Can't get a standby built Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 3+ messages in thread
From: John Scalia @ 2014-07-23 17:16 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can't get a standby built
2014-07-23 17:16 Can't get a standby built John Scalia <jayknowsunix@gmail.com>
@ 2014-07-23 20:33 ` Jorge Fernandez <jorge.fernandez@openenglish.com>
1 sibling, 0 replies; 3+ messages in thread
From: Jorge Fernandez @ 2014-07-23 20:33 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin
won't you try repmgr (repmgr.org) is great to clone and setup any Slave
2014-07-23 14:16 GMT-03:00 John Scalia <jayknowsunix@gmail.com>:
> 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
>
--
*Jorge Daniel Fernandez*
Leader - DBA Team
S: elgaita99 | t:@openenglish
w: www.openenglish.com
<http://www.openenglish.com/;
Opensoft Argentina S.R.L
552 Suipacha , Piso 3to, Capital Federal
Argentina, (C1022AAR)
(*) The content of this electronic message may be privileged and
confidential.
(*) If you are not an intended recipient of this email, please delete it
and do not use it.
(*) The Open English name and the Open English logo are registered
trademarks.
(*) Opensoft Argentina S.R.L is a vendor company of Open English LLC.
<http://www.openenglish.com/;
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Can't get a standby built
2014-07-23 17:16 Can't get a standby built John Scalia <jayknowsunix@gmail.com>
@ 2014-07-26 02:59 ` Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2014-07-26 02:59 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2014-07-26 02:59 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-07-23 17:16 Can't get a standby built John Scalia <jayknowsunix@gmail.com>
2014-07-23 20:33 ` Jorge Fernandez <jorge.fernandez@openenglish.com>
2014-07-26 02:59 ` Peter Eisentraut <peter_e@gmx.net>
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