From: MirrorX <mirrorx@gmail.com>
To: pgsql-admin@postgresql.org
Subject: standby becomes primary and then?
Date: Sun, 25 Sep 2011 05:15:34 -0700 (PDT)
Message-ID: <1316952934384-4838314.post@n5.nabble.com> (raw)
dear all,
i would like your help on the following matter:
the other day i had to bring up the failover server. it was in warm standby
mode and everything went fine. my question is this-> when the secondary
becomes primary is there a way for the primary to immediately turn to
warm-standby mode? in more details what i did is this:
1)stopped primary
2)rsync last wals
3)apply wals to secondary
4)bring up secondary. the first wal archive he wrote was the next in the
sequence of the first. that is to say the last wal of the first was xxxxx01
and the first of the 2nd was xxxxx02.
5)put the former primary to standby mode and giving as %f the first wal that
that the new primary produced
but it didnt work. the error msg was sth about the timeline of the wals in a
xxxx.history file. so my question is a little more general. should this
method work in general? should have i done something differenctly? note here
that i didn't have any backup_label file. so probably to make it work i
should immediately put the new primary to backup mode? (pg_start_backup).
thx in advance for your help
--
View this message in context: http://postgresql.1045698.n5.nabble.com/standby-becomes-primary-and-then-tp4838314p4838314.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
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: mirrorx@gmail.com
Subject: Re: standby becomes primary and then?
In-Reply-To: <1316952934384-4838314.post@n5.nabble.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