Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aYcLU-000205-3p for pgsql-admin@arkaria.postgresql.org; Wed, 24 Feb 2016 16:31:24 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aYcLT-0006tz-N0 for pgsql-admin@arkaria.postgresql.org; Wed, 24 Feb 2016 16:31:23 +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) (envelope-from ) id 1aYcLT-0006tm-71 for pgsql-admin@postgresql.org; Wed, 24 Feb 2016 16:31:23 +0000 Received: from tamriel.snowman.net ([2001:4830:167b::11]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aYcLQ-00070N-Dz for pgsql-admin@postgresql.org; Wed, 24 Feb 2016 16:31:22 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id BC2CA5F795; Wed, 24 Feb 2016 11:31:19 -0500 (EST) Date: Wed, 24 Feb 2016 11:31:19 -0500 From: Stephen Frost To: "David G. Johnston" Cc: "drum.lucas@gmail.com" , "pgsql-admin@postgresql.org" Subject: Re: Incremental Refresh - PostgreSQL 9.2 Message-ID: <20160224163119.GG3127@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="APlYHCtpeOhspHkB" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-77-generic (x86_64) X-Uptime: 11:30:19 up 1 day, 13:23, 3 users, load average: 0.05, 0.09, 0.12 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) 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 --APlYHCtpeOhspHkB Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable David, * David G. Johnston (david.g.johnston@gmail.com) wrote: > On Tue, Feb 23, 2016 at 2:59 PM, drum.lucas@gmail.com > wrote: > > Question: > > Now that the test server has a full copy from master, how could I just = do > > a incremental refreshing once a month? > > > > Instead copying all the DB (1.7GB), just copy what has been changed? > > Is that possible? > > > > > =E2=80=8BYou cannot accomplish incremental updates if your choice of tool= is > pg_dump. =20 Agreed. > The only way to do a true incremental would be to rely upon > something like rsync on the data directory while the master server is > offline. pgBackRest actually provides incremental backups and restores and I've used it for exactly this kind of setup previously. Thanks! Stephen --APlYHCtpeOhspHkB Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJWzdrXAAoJEO1sijiDR2RVeSIP/jZdn3Kb9GpqiH4yT7aJfGcy VKDyt4yCZLq5jHG0qtVzkKeoiK5zIaYdVTn5Ku/iFdorDoMH90Jb9hZcg9MklIoR Ee7BRRAS3uqL8eFUE4oEsSwPqery2KeLIkZWmQXpgYMPsWlG7HvWDXW8l4RzfgLf vkTKOBCqkw+COFHHGizQTT/l2U/JMkpuBEbQNfSWyfaQNYLleTOhKO7xiD4nHOdw azlV4QYia3CWp5f/XbAw7j0c4mOyCsjSD02sb13QbOknqftLdoqJXLY9cp1q0foz 3x39/DUWQzuJsBeooOj+5E4zbohv+tmylzN0nfh1YXinax1R7EfhmUGK1H5KLSEJ xe3ejMNKDz64rTw61a9nGgwSvz85kJWC4S0QQBqLfBs6y5n+Q8N2Ffg9Az8w8aZn SGrjykUxwymK+P7N5JpcUks6fjmQPhGNz/7T2JoctmJEPOeBqSgt0ux+F3Bgcm6P xIdD7L/lx2w9oJD7dCIBccYG5asLSi9NnpN/hhDr08M1+fhLvvpqpP6dZCmQyAi+ ML0ROPgKzQiw8qoeJVlK5UoTG6RRfohCq0Ft23JqtIXv4WxHjlOsN4R64SlzElE9 EryjwDog0IxK6PrLIpz9sH8mNBx5HhVEsSA+YPEg84xT/do9pOYxoSNlFv87pirV R3lntu7P3xoc9bnbS9Wr =hqTt -----END PGP SIGNATURE----- --APlYHCtpeOhspHkB--