pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWhen is it safe to remove recovery.done?
5+ messages / 4 participants
[nested] [flat]
* When is it safe to remove recovery.done?
@ 2014-07-22 18:53 John Scalia <jayknowsunix@gmail.com>
2014-07-22 18:58 ` Re: When is it safe to remove recovery.done? Scott Whitney <scott@journyx.com>
2014-07-23 09:19 ` Re: When is it safe to remove recovery.done? Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 2 replies; 5+ messages in thread
From: John Scalia @ 2014-07-22 18:53 UTC (permalink / raw)
To: pgsql-admin
After successfully testing a failover between my primary and a standby server, the old recovery.conf file is renamed recovery.done. As this system is now the master, I don't see a
need to keep that file around, but is it safe to remove it now?
--
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] 5+ messages in thread
* Re: When is it safe to remove recovery.done?
2014-07-22 18:53 When is it safe to remove recovery.done? John Scalia <jayknowsunix@gmail.com>
@ 2014-07-22 18:58 ` Scott Whitney <scott@journyx.com>
2014-07-22 19:05 ` Re: When is it safe to remove recovery.done? jayknowsunix@gmail.com
1 sibling, 1 reply; 5+ messages in thread
From: Scott Whitney @ 2014-07-22 18:58 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin
Well, it depends on whether or not you need the file.
It's renamed so the system doesn't accidentally try to re-enter recovery mode.
However if you're still planning on having a standby, you _will_ need a recovery.conf file, and that's what this is, just renamed.
----- Original Message -----
> After successfully testing a failover between my primary and a standby
> server, the old recovery.conf file is renamed recovery.done. As this system
> is now the master, I don't see a
> need to keep that file around, but is it safe to remove it now?
> --
> 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] 5+ messages in thread
* Re: When is it safe to remove recovery.done?
2014-07-22 18:53 When is it safe to remove recovery.done? John Scalia <jayknowsunix@gmail.com>
2014-07-22 18:58 ` Re: When is it safe to remove recovery.done? Scott Whitney <scott@journyx.com>
@ 2014-07-22 19:05 ` jayknowsunix@gmail.com
0 siblings, 0 replies; 5+ messages in thread
From: jayknowsunix@gmail.com @ 2014-07-22 19:05 UTC (permalink / raw)
To: Scott Whitney <swhitney@journyx.com>; +Cc: pgsql-admin
Well, I do keep a recovery.conf master file in the Postgres home directory on each of the systems. My failover script takes care of copying it up into the data directory, as well as making any required changes to it. (I use two standby servers, so if the primary fails, one gets promoted and the other must be repointed.)
Sent from my iPad
> On Jul 22, 2014, at 2:58 PM, Scott Whitney <scott@journyx.com> wrote:
>
> Well, it depends on whether or not you need the file.
>
> It's renamed so the system doesn't accidentally try to re-enter recovery mode.
>
> However if you're still planning on having a standby, you _will_ need a recovery.conf file, and that's what this is, just renamed.
>
>
> After successfully testing a failover between my primary and a standby server, the old recovery.conf file is renamed recovery.done. As this system is now the master, I don't see a
> need to keep that file around, but is it safe to remove it now?
> --
> 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] 5+ messages in thread
* Re: When is it safe to remove recovery.done?
2014-07-22 18:53 When is it safe to remove recovery.done? John Scalia <jayknowsunix@gmail.com>
@ 2014-07-23 09:19 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2014-07-23 10:35 ` Re: When is it safe to remove recovery.done? jayknowsunix@gmail.com
1 sibling, 1 reply; 5+ messages in thread
From: Albe Laurenz @ 2014-07-23 09:19 UTC (permalink / raw)
To: John Scalia *EXTERN* <jayknowsunix@gmail.com>; pgsql-admin
John Scalia wrote:
> After successfully testing a failover between my primary and a standby server, the old recovery.conf
> file is renamed recovery.done. As this system is now the master, I don't see a
> need to keep that file around, but is it safe to remove it now?
It is safe to remove the file, but it doesn't hurt if you keep it (it may serve as
documentation of your latest recovery).
Yours,
Laurenz Albe
--
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] 5+ messages in thread
* Re: When is it safe to remove recovery.done?
2014-07-22 18:53 When is it safe to remove recovery.done? John Scalia <jayknowsunix@gmail.com>
2014-07-23 09:19 ` Re: When is it safe to remove recovery.done? Albe Laurenz <laurenz.albe@wien.gv.at>
@ 2014-07-23 10:35 ` jayknowsunix@gmail.com
0 siblings, 0 replies; 5+ messages in thread
From: jayknowsunix@gmail.com @ 2014-07-23 10:35 UTC (permalink / raw)
To: Albe Laurenz <laurenz.albe@wien.gv.at>; +Cc: pgsql-admin
That's what I was thinking. Thanks.
Sent from my iPad
> On Jul 23, 2014, at 5:19 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
>
> John Scalia wrote:
>> After successfully testing a failover between my primary and a standby server, the old recovery.conf
>> file is renamed recovery.done. As this system is now the master, I don't see a
>> need to keep that file around, but is it safe to remove it now?
>
> It is safe to remove the file, but it doesn't hurt if you keep it (it may serve as
> documentation of your latest recovery).
>
> Yours,
> Laurenz Albe
--
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] 5+ messages in thread
end of thread, other threads:[~2014-07-23 10:35 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-07-22 18:53 When is it safe to remove recovery.done? John Scalia <jayknowsunix@gmail.com>
2014-07-22 18:58 ` Scott Whitney <scott@journyx.com>
2014-07-22 19:05 ` jayknowsunix@gmail.com
2014-07-23 09:19 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2014-07-23 10:35 ` jayknowsunix@gmail.com
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