From: Shashi Kanth Boddula <sboddula@novell.com>
To: pgsql-performance@postgresql.org
Subject: Mirroring PostgreSQL database
Date: Mon, 25 Jul 2005 12:01:52 -0600
Message-ID: <s2e4888c.065@lucius.provo.novell.com> (raw)
Hi,
I have one customer who is using PostgreSQL 7.4.8 on Linux . He has some
problems with database mirroring . The details are follows.
The customer is using Linux on which PostgreSQL 7.4.8 along with Jboss
3.2.3 is running . He has 2 servers , one is acting as a live server
(primary) and another is acting as a fail-over (secondary) server .
Secondary server is placed in remote location . These servers are acting
as a Attendence server for daily activities . Nearly 50,000 employees
depend on the live server .
The customer is using DBmirror tool to mirror the database records of
primary to secondary . The customer is complaining that there is one day
(24 hours) delay between primary and secondray for database
synchronization . They have dedicated line and bandwidth , but still the
problems exists.
I just want to know , for immediate data mirroring , what is the best
way for PostgreSQL . PostgreSQL is offering many mirror tools , but
which one is the best ?. Is there any other way to accomplish the task ?
Thank you . Waiting for your reply.
Thanks & Regards,
Shashi Kanth
Consultant - Linux
RHCE , LPIC-2
Onward Novell - Bangalore
9886455567
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sboddula@novell.com
Subject: Re: Mirroring PostgreSQL database
In-Reply-To: <s2e4888c.065@lucius.provo.novell.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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