From: | Andrey Nikitin <neomerdien(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Taking hot backup of slave node in postgres (master-slave config with repmgr) |
Date: | 2014-01-14 12:36:53 |
Message-ID: | CAJec7P7-zX4SPQOgxNdbYWkbSfiwiTxhaAxrdQFbopU+F6EFzg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I have a #postgresql setup with master-slave configuration using repmgr. im
struggling with taking a consistent snapshot backup (pg_start_backup) of
the slave node, this is due the fact that the slave is in recovery, hence
read-only mode.
i need both the master and the slave snapshots to speedup the recovery
process (if taken only on 1 node, in case of recovery the slave needs to be
rebuild from scratch). any advice of how to take a consistent snapshot of
slave node? (master is no problem).
currently these are the approaches im checking:
1.shutting down slave node and take a cold snapshot backup.
1.
pg_start_backup on master and hopefully it will reflect consistent state
on slave (with the WAL shipping) - any confirmation on this one?
2.
stop replication, take hot backup of slave using regular methods and
then starting replication again - as far as i tested, not possible because
as the replication is stopped, each node becomes independent and has its
own timeline, thus require the nodes to resync in order to function again
in master-slave config.
3.
make a switch over before taking the backup - dont like this option,
dont think is a correct approach to make a switch-over each time i want to
take a backup.
anything i missed? have you implemented it using different methods?
thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2014-01-14 13:19:36 | Re: GSSAPI auth issue with windows 7 client, postgresql 9.2.3 linux server |
Previous Message | jaime soler | 2014-01-14 12:32:24 | GSSAPI auth issue with windows 7 client, postgresql 9.2.3 linux server |