From: | Scott Whitney <scott(at)journyx(dot)com> |
---|---|
To: | "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com> |
Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Incremental Refresh - PostgreSQL 9.2 |
Date: | 2016-02-24 01:23:40 |
Message-ID: | ewwmlvageqrkn3rdthfso2nq.1456277100577@email.android.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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(dot)lucas(at)gmail(dot)com
Date: 02/23/2016 6:46 PM (GMT-06:00)
To: Scott Whitney <scott(at)journyx(dot)com>
Cc: "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Incremental Refresh - PostgreSQL 9.2
On 24 February 2016 at 11:42, Scott Whitney <scott(at)journyx(dot)com<mailto:scott(at)journyx(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | drum.lucas@gmail.com | 2016-02-24 01:34:41 | Re: Incremental Refresh - PostgreSQL 9.2 |
Previous Message | drum.lucas@gmail.com | 2016-02-24 00:45:59 | Re: Incremental Refresh - PostgreSQL 9.2 |