Postgres Pro
Downloads
Home   >   mailing lists

Re: DB Synchronization. - Mailing list pgsql-admin

From Shoaib Mir
Subject Re: DB Synchronization.
Date
Msg-id bf54be870608260815y7802b1f9o253bf40dc8aa5c03@mail.gmail.com
Whole thread Raw
In response to DB Synchronization.  (nilesh khode <nilesh_khode@yahoo.com>)
List pgsql-admin
Tree view
You can use Slony (http://gborg.postgresql.org/project/slony1/projdisplay.php) for replication (data synchronization) and it also does offer the failover (not automatic) feature as well.

You can also have a combination of Linux HA + Slony for high availablity.

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)


On 8/26/06, nilesh khode <nilesh_khode@yahoo.com> wrote:

Hello All,

I am having Postgresql 8 installed on 2 RH Linux box.
I am keeping one server in stand-by mode. If one server is failed for any reason, the DB should be serving from another server.

I am having one question about the synchronization.
How to keep another server in updated mode?
It should takes an updated db from first server and restore it on another server.

Please help me out.

Regards,
Nilesh





pgsql-admin by date:

Previous
From: "Purusothaman A"
Date:
Subject: Win2000 professional / Error message while installing PostgreSQL "Failed to create process: 2! ".
Next
From: "Aaron Bono"
Date:
Subject: Re: pg_hba changes not honored