[ADMIN] Streaming replication and PG database maintenance jobs( vacuum,dump)

Поиск
Список
Период
Сортировка
От ghiureai
Тема [ADMIN] Streaming replication and PG database maintenance jobs( vacuum,dump)
Дата
Msg-id 59DCDF0A.3040706@nrc-cnrc.gc.ca
обсуждение исходный текст
Список pgsql-admin
Hi List,

I have cfg  streaming replication:  master -> slave servers with repmgr, 
I would like to learn from your experience  what are the solutions 
available in PG 9.6 and PG 10 for running maintenance jobs ( such as 
pg_dump. pg_dumpall, vacuum full)  on master server without affecting 
the overall day to day production performance.?

Is there a way  in PG 10 to control if Ido not want all db changes/cmd's 
to be replicated ?( how about in Pg 10  logical replication ?)
Thank you
Isabella



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

Предыдущее
От: Ramesh
Дата:
Сообщение: Re: [ADMIN] Can master and slave on different PG versions?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: [ADMIN] Can master and slave on different PG versions?