From: Scott Whitney <scott@journyx.com>
To: David G. Johnston <david.g.johnston@gmail.com>
To: drum.lucas@gmail.com <drum.lucas@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Incremental Refresh - PostgreSQL 9.2
Date: Tue, 23 Feb 2016 22:42:14 +0000
Message-ID: <e0121fj0w32l77ofwjfb14i2.1456267414369@email.android.com> (raw)
In-Reply-To: <CAKFQuwYFoEwQOXwvOuiqx40mJb+T2P3LKKXcTJNKGsX0M+LZ=w@mail.gmail.com>
References: <CAE_gQfUqvmewj91Sg81Orc7S+=aO0xG-xftMB4UycByVEdWHZw@mail.gmail.com>
<CAKFQuwYFoEwQOXwvOuiqx40mJb+T2P3LKKXcTJNKGsX0M+LZ=w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Are you using it for just select queries, or is this a full 100% test (insert/update/delete) test environment?
I have both. In my case they are geographically separate. Production server at data center. Replicated "just in case," also at data center. At HQ, I replicate that for DR purposes. INTERNALLY (gigabit backend), I have another internal test server that I refresh FROM THE REPLICATED SERVER AT HQ on a regular basis. I use the replicated server to query stuff (select) and dump databases to the interaction test server regularly for full testing.
-------- Original message --------
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: 02/23/2016 4:16 PM (GMT-06:00)
To: drum.lucas@gmail.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Incremental Refresh - PostgreSQL 9.2
On Tue, Feb 23, 2016 at 2:59 PM, drum.lucas@gmail.com<mailto:drum.lucas@gmail.com> <drum.lucas@gmail.com<mailto:drum.lucas@gmail.com>> wrote:
Hi all,
I've got a Master server and a Test Server.
Master server has a 1.7 TB
Test server has a full copy from master - 1.7 TB.
The copy was made using pg_dump
I.E: /usr/pgsql-9.2/bin/pg_dump --exclude-table-data='junk.*' --format=custom geoop_live > bigdump.sql
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?
?You cannot accomplish incremental updates if your choice of tool is pg_dump. 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.
So, assuming that is not an option, you should probably look at the various true replication solutions that are available and see which of those might serve as an alternative.
?David J.
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott@journyx.com, david.g.johnston@gmail.com, drum.lucas@gmail.com
Subject: Re: Incremental Refresh - PostgreSQL 9.2
In-Reply-To: <e0121fj0w32l77ofwjfb14i2.1456267414369@email.android.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox