From: Scott Whitney <scott@journyx.com>
To: drum.lucas@gmail.com <drum.lucas@gmail.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Incremental Refresh - PostgreSQL 9.2
Date: Wed, 24 Feb 2016 01:23:40 +0000
Message-ID: <ewwmlvageqrkn3rdthfso2nq.1456277100577@email.android.com> (raw)
In-Reply-To: <CAE_gQfXJx81wGXRYEO2jUTLTLkvkWvCiE6bRUxjQAOG08zPVGQ@mail.gmail.com>
References: <CAE_gQfUqvmewj91Sg81Orc7S+=aO0xG-xftMB4UycByVEdWHZw@mail.gmail.com>
<CAKFQuwYFoEwQOXwvOuiqx40mJb+T2P3LKKXcTJNKGsX0M+LZ=w@mail.gmail.com>
<e0121fj0w32l77ofwjfb14i2.1456267414369@email.android.com>
<CAE_gQfXJx81wGXRYEO2jUTLTLkvkWvCiE6bRUxjQAOG08zPVGQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Please do not refer me (or the list) to a URL when you are asking for help. Be clear and concise. If you have a URI that helps you, please be specific in the places you do not understand.
-------- Original message --------
From: drum.lucas@gmail.com
Date: 02/23/2016 6:46 PM (GMT-06:00)
To: Scott Whitney <scott@journyx.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Incremental Refresh - PostgreSQL 9.2
On 24 February 2016 at 11:42, Scott Whitney <scott@journyx.com<mailto:scott@journyx.com>> wrote:
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.
That's what I'm looking for:
https://coderwall.com/p/jxebnw/incremental-backups-for-postgresql
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, drum.lucas@gmail.com, david.g.johnston@gmail.com
Subject: Re: Incremental Refresh - PostgreSQL 9.2
In-Reply-To: <ewwmlvageqrkn3rdthfso2nq.1456277100577@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