Обсуждение: When is it safe to remove recovery.done?

Поиск
Список
Период
Сортировка

When is it safe to remove recovery.done?

От
John Scalia
Дата:
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


Re: When is it safe to remove recovery.done?

От
Scott Whitney
Дата:
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

Re: When is it safe to remove recovery.done?

От
jayknowsunix@gmail.com
Дата:
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

Re: When is it safe to remove recovery.done?

От
Albe Laurenz
Дата:
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

Re: When is it safe to remove recovery.done?

От
jayknowsunix@gmail.com
Дата:
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