Re: Turn off streaming replication - leaving Master running

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Turn off streaming replication - leaving Master running
Дата
Msg-id 5590DE7B.3040402@hogranch.com
обсуждение исходный текст
Ответ на Re: Turn off streaming replication - leaving Master running  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: Turn off streaming replication - leaving Master running  (Andy Erskine <andy.erskine@jds.net.au>)
Список pgsql-general
On 6/28/2015 10:52 PM, Michael Paquier wrote:
> Well, yes. It depends on what you want to do then. If this testing
> really requires to promote the standby then you will need to take a
> new fresh base backup knowing that you are using 9.2.

if the standby is running on a file system with snapshotting (like zfs),
and the master is doing WAL archiving, you could, in theory, pause the
replication and snapshot the slave, do read/write tests on the slave,
then restore that snapshot and resume replication, pulling from the WAL
archive til it catches up.



--
john r pierce, recycling bits in santa cruz



В списке pgsql-general по дате отправления:

Предыдущее
От: Andy Erskine
Дата:
Сообщение: Re: Turn off streaming replication - leaving Master running
Следующее
От: Shujie Shang
Дата:
Сообщение: Re: create index on a field of udt