Re: Having two simultaneous and similar database - Mailing list pgsql-general

From Sairam Krishnamurthy
Subject Re: Having two simultaneous and similar database
Date
Msg-id AANLkTinsM6C10nVWnVs2C+rGX3zs=U3RdQn7D9EB_nns@mail.gmail.com
Whole thread Raw
In response to Re: Having two simultaneous and similar database  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Scott, Thanks to answering the question. Thats exactly the reason.

Also any operation on the tables is going to be huge. LIke 10s of
thousands of rows inserted of deleted. This basically locks the table
and that y we wanted to update a database and sync it with the
production database when no one will be using the system.



On Mon, Oct 4, 2010 at 9:55 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Mon, Oct 4, 2010 at 8:46 PM, Rajesh Kumar Mallah
> <mallah.rajesh@gmail.com> wrote:
>> Dear Sai,
>>
>> Why do you want to update at nite only. You can setup streaming replication
>> with pgsql9.0 and
>> have it updated almost instantly.
>
> They could have something where they need a stable unchanging version
> for testing, or they're load testing and need to write to the salve,
> etc.
>

pgsql-general by date:

Previous
From: Sairam Krishnamurthy
Date:
Subject: Re: Having two simultaneous and similar database
Next
From: Magnus Hagander
Date:
Subject: Re: queriing the version of libpq