Postgres Pro
Downloads
Home   >   mailing lists

Re: Incremental Refresh - PostgreSQL 9.2 - Mailing list pgsql-admin

From Scott Whitney
Subject Re: Incremental Refresh - PostgreSQL 9.2
Date
Msg-id ewwmlvageqrkn3rdthfso2nq.1456277100577@email.android.com
Whole thread Raw
In response to Re: Incremental Refresh - PostgreSQL 9.2  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
Responses Re: Incremental Refresh - PostgreSQL 9.2
List pgsql-admin
Tree view
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> 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:




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/ 

pgsql-admin by date:

Previous
From: "drum.lucas@gmail.com"
Date:
Subject: Re: Incremental Refresh - PostgreSQL 9.2
Next
From: "drum.lucas@gmail.com"
Date:
Subject: Re: Incremental Refresh - PostgreSQL 9.2