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

From: ghiureai <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Streaming replication and PG database maintenance jobs( vacuum, dump)
Date: 2017-10-10 14:54:02
Message-ID: 59DCDF0A.3040706@nrc-cnrc.gc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2017-10-10 15:26:18 Re: Can master and slave on different PG versions?
Previous Message Ramesh 2017-10-10 08:49:19 Re: Can master and slave on different PG versions?