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

From drum.lucas@gmail.com
Subject Re: Incremental Refresh - PostgreSQL 9.2
Date
Msg-id CAE_gQfXJx81wGXRYEO2jUTLTLkvkWvCiE6bRUxjQAOG08zPVGQ@mail.gmail.com
Whole thread Raw
In response to Re: Incremental Refresh - PostgreSQL 9.2  (Scott Whitney <scott@journyx.com>)
Responses Re: Incremental Refresh - PostgreSQL 9.2  (Scott Whitney <scott@journyx.com>)
List pgsql-admin


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:


pgsql-admin by date:

Previous
From: Scott Whitney
Date:
Subject: Re: Incremental Refresh - PostgreSQL 9.2
Next
From: Scott Whitney
Date:
Subject: Re: Incremental Refresh - PostgreSQL 9.2