Skip site navigation (1) Skip section navigation (2)

Re: Mirroring PostgreSQL database

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Shashi Kanth Boddula <sboddula(at)novell(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Mirroring PostgreSQL database
Date: 2005-07-25 15:20:31
Message-ID: 42E5033F.7090201@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
Try Slony: www.slony.info

Shashi Kanth Boddula wrote:
> 
> 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
> 
> 

In response to

pgsql-performance by date

Next:From: Joshua D. DrakeDate: 2005-07-25 16:03:37
Subject: Re: Mirroring PostgreSQL database
Previous:From: Richard HuxtonDate: 2005-07-25 13:04:01
Subject: Re: Mirroring PostgreSQL database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group