Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e1vxz-00033n-Qv for pgsql-admin@arkaria.postgresql.org; Tue, 10 Oct 2017 14:57:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e1vxz-0004Eo-DQ for pgsql-admin@arkaria.postgresql.org; Tue, 10 Oct 2017 14:57:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e1vxz-0004Ef-3K for pgsql-admin@postgresql.org; Tue, 10 Oct 2017 14:57:07 +0000 Received: from nrccenhts1.nrc.ca ([132.246.15.88]) by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1e1vxv-0005KA-Qr for pgsql-admin@postgresql.org; Tue, 10 Oct 2017 14:57:06 +0000 Received: from [132.246.194.15] (132.246.11.2) by owa.nrc.ca (132.246.15.87) with Microsoft SMTP Server (TLS) id 8.3.485.1; Tue, 10 Oct 2017 10:56:57 -0400 Message-ID: <59DCDF0A.3040706@nrc-cnrc.gc.ca> Date: Tue, 10 Oct 2017 07:54:02 -0700 From: ghiureai User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130110 Thunderbird/17.0.2 MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: Streaming replication and PG database maintenance jobs( vacuum, dump) Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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