pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDB Synchronization.
2+ messages / 2 participants
[nested] [flat]
* DB Synchronization.
@ 2006-08-26 06:08 nilesh khode <nilesh_khode@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: nilesh khode @ 2006-08-26 06:08 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: DB Synchronization.
@ 2006-08-26 15:15 Shoaib Mir <shoaibmir@gmail.com>
parent: nilesh khode <nilesh_khode@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Shoaib Mir @ 2006-08-26 15:15 UTC (permalink / raw)
To: nilesh khode <nilesh_khode@yahoo.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-08-26 15:15 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-26 06:08 DB Synchronization. nilesh khode <nilesh_khode@yahoo.com>
2006-08-26 15:15 ` Shoaib Mir <shoaibmir@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox