X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C2A5052C05 for ; Wed, 27 Jul 2005 18:21:53 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83233-02 for ; Wed, 27 Jul 2005 21:21:43 +0000 (GMT) Received: from dd01.profihoster.net (dd01.profihoster.net [84.233.130.40]) by svr1.postgresql.org (Postfix) with ESMTP id 861BF52ADA for ; Wed, 27 Jul 2005 18:21:42 -0300 (ADT) Received: from [192.168.54.33] (Iaec4.i.pppool.de [85.73.174.196]) by dd01.profihoster.net (Postfix) with ESMTP id AF0C32383C3 for ; Wed, 27 Jul 2005 23:12:26 +0200 (CEST) Message-ID: <42E7FAE3.7070604@laliluna.de> Date: Wed, 27 Jul 2005 23:21:39 +0200 From: Sebastian Hennebrueder User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Mirroring PostgreSQL database References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/420 X-Sequence-Number: 13661 Shashi Kanth Boddula schrieb: > 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 > > For java based solution you could also have a look at x-jdbc or xjdbc. But before you should find out what the reason for the delay is actually. When the backup server is to slow, it may be not important which mirroring tool you use. -- Best Regards / Viele Grüße Sebastian Hennebrueder ---- http://www.laliluna.de Tutorials for JSP, JavaServer Faces, Struts, Hibernate and EJB Get support, education and consulting for these technologies - uncomplicated and cheap.