pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Mirroring problem with PostgreSQL 2+ messages / 2 participants [nested] [flat]
* Mirroring problem with PostgreSQL @ 2005-07-19 13:32 Shashi Kanth Boddula <sboddula@novell.com> 2005-07-19 20:33 ` Re: Mirroring problem with PostgreSQL Peter Eisentraut <peter_e@gmx.net> 0 siblings, 1 reply; 2+ messages in thread From: Shashi Kanth Boddula @ 2005-07-19 13:32 UTC (permalink / raw) To: pgsql-admin Hi, One of my client is facing one issue the with PostgreSQL . The details are as follows . 1 . PostgreSQL version 7.4.8 is running on 2 Linux machine . One acting as a primary database server and another one is acting as a fail-over (secondary)server . 2. Primar & secondary servers are located at different locations 2. Using DBmirror utility to mirror the database from primary to secondary . With above setup , the problem is , there is a 1 day delay between primary and secondary in the synchronization . That menas , if a client put a record in the primary , it will sync to the secondary with delay of 24 hours . My question is , for above mentioned requirement , what is the currect way to solve the problem . I would like to know Is there any other way to solve this problem . My idea is to implement DRBD to mirror the database between primary and secondary . But , i want to know can DRBD suite this requirement or not . And , is there any limitation while using DRBD in a WAN environment . Thanks & Regards, Shashi Kanth ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Mirroring problem with PostgreSQL 2005-07-19 13:32 Mirroring problem with PostgreSQL Shashi Kanth Boddula <sboddula@novell.com> @ 2005-07-19 20:33 ` Peter Eisentraut <peter_e@gmx.net> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2005-07-19 20:33 UTC (permalink / raw) To: Shashi Kanth Boddula <sboddula@novell.com>; +Cc: pgsql-admin Shashi Kanth Boddula wrote: > My idea is to implement DRBD to mirror the database between primary > and secondary . But , i want to know can DRBD suite this requirement Sure. This is a fairly common setup. > And , is there any limitation while using DRBD in a WAN > environment . Sure. It will be slow. But you should test yourself just how slow it will be. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-07-19 20:33 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-07-19 13:32 Mirroring problem with PostgreSQL Shashi Kanth Boddula <sboddula@novell.com> 2005-07-19 20:33 ` Peter Eisentraut <peter_e@gmx.net>
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