All,
Is there a way to do this other than using the backup feature?
__
I am trying to create two databases in two different machines connected
over the lan. Both the databases have similar tables and fields in them.
I will be upda
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
Ben,
Thanks for the pointer. I did had a look at this b4 posting this. It
seems more of a back up rather than maintaining two databases. So i
basically have to set up a continuous archive and use the raw file to
update the other database.
I was rather looking for a direct way to maintain to synch
On Mon, Oct 4, 2010 at 8:46 PM, Rajesh Kumar Mallah
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
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.
However if you would want it that way only read about various backup
options in
the link that was provided.
regds
mallah.
On Mon, Oct 4, 2010 at 4:02 PM, Sa
I think you want something like :
http://www.postgresql.org/docs/8.4/interactive/backup.html
On 05/10/2010, at 7:02 AM, Sairam Krishnamurthy wrote:
> Hi all.
>
> I am trying to create two databases in two different machines connected over
> the lan. Both the databases have similar tables and f
Hi all.
I am trying to create two databases in two different machines connected
over the lan. Both the databases have similar tables and fields in them.
I will be updating database A always. I want the update to be backed up
to database B automatically during the night when no one will be usin
