Re: PG how to stop streaming replication( master host)

Поиск

Список

Период

Сортировка

От	Scott Whitney
Тема	Re: PG how to stop streaming replication( master host)
Дата	15 декабря 2018 г. 01:50:30
Msg-id	SN6PR11MB2976E78D06B066CCAC7C5F7DA7A10@SN6PR11MB2976.namprd11.prod.outlook.com обсуждение исходный текст
Ответ на	PG how to stop streaming replication( master host) ("Ghiurea, Isabella" <Isabella.Ghiurea@nrc-cnrc.gc.ca>)
Ответы	Re: PG how to stop streaming replication( master host)
Список	pgsql-admin

Дерево обсуждения

I use this during my backups to have a consistent state on my multiple slaves.

https://coderwall.com/p/nirwxa/pause-and-resume-hot_standby-replication-on-postgres-database

From: Ghiurea, Isabella <Isabella.Ghiurea@nrc-cnrc.gc.ca>
Sent: Friday, December 14, 2018 4:46:55 PM
To: pgsql-admin@postgresql.org
Subject: PG how to stop streaming replication( master host)

Hi List

I am running PGSLQ 10.4 with repmgr in synchronous streaming replication 2 servers: master+slave, I would like to learn if there are any options to stop replication ( no just pause /resume the WAL's) master to slave without rebooting the master server or the only option is to take the Pg db slave host down and eventually the the /wal directory will get 100% full .

Isabella