From: | Dirk Krautschick <Dirk(dot)Krautschick(at)trivadis(dot)com> |
---|---|
To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Backup Restore from other node after switchover/failover |
Date: | 2020-10-28 09:22:47 |
Message-ID: | AM0PR05MB608219D825BAECFDDEE0A39DE9170@AM0PR05MB6082.eurprd05.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Hi,
haven't tested it yet but maybe I can get a quick answer here.
We have discussed the following scenario.
Few nodes as streaming replication cluster all in sync with taking backup
only from one dedicated node. Now that node which is responsible for the backups
goes down. For sure I have a full backup taken from that crashed node
some time ago but now this node is gone and I have to take care for a
restore for some reason.
Am I able to make a full restore with that last backup from the offline node
to any other still existing node with Recovering the archived WAL from the new
selected node if I have activated archive_mode as "always"?
Or is it strictly necessary to create a new full backup from the new node
which is responsible for the backups after the failover or maybe after a
Switchover, too?
Thanks and best regards
Dirk
From | Date | Subject | |
---|---|---|---|
Next Message | Sushant Pawar | 2020-10-28 12:22:17 | Re: Backup Restore from other node after switchover/failover |
Previous Message | Lars Aksel Opsahl | 2020-10-27 19:17:20 | Re: free(): invalid pointer , when to dumping data to a new server |
From | Date | Subject | |
---|---|---|---|
Next Message | Mahesh Bodepati | 2020-10-28 10:05:44 | Re: facing problem in outparameters in c |
Previous Message | Laurenz Albe | 2020-10-28 06:59:17 | Re: facing problem in outparameters in c |