Postgres Pro
Downloads
Home   >   mailing lists

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

From Ben Madin
Subject Re: Having two simultaneous and similar database
Date
Msg-id 9289968E-11AE-4D89-96E8-E227760D74F2@remoteinformation.com.au
Whole thread Raw
In response to Having two simultaneous and similar database  (Sairam Krishnamurthy <kmsram420@gmail.com>)
Responses Re: Having two simultaneous and similar database
Re: Having two simultaneous and similar database
List pgsql-general
Tree view
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 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 using the databases.

Can some one tell if if this can be done and if yes how ?
 
-- 
Thanks,
Sairam Krishnamurthy
+1 612 859 8161

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: [Off Topic] Software load balancing question
Next
From: Mike Christensen
Date:
Subject: Re: [Off Topic] Software load balancing question