pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
DB Synchronization.
2+ messages / 2 participants
[nested] [flat]

* DB Synchronization.
@ 2006-08-26 06:08 nilesh khode <nilesh_khode@yahoo.com>
  2006-08-26 15:15 ` Re: DB Synchronization. Shoaib Mir <shoaibmir@gmail.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 06:08 DB Synchronization. nilesh khode <nilesh_khode@yahoo.com>
@ 2006-08-26 15:15 ` Shoaib Mir <shoaibmir@gmail.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