X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 869AF9DCA5A for ; Thu, 5 Jan 2006 19:57:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39967-09 for ; Thu, 5 Jan 2006 19:57:09 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 8CF999DCA00 for ; Thu, 5 Jan 2006 19:57:04 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k05Nv24Q040518 for ; Thu, 5 Jan 2006 23:57:02 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k05NcnRu038648 for pgsql-admin@postgresql.org; Thu, 5 Jan 2006 23:38:49 GMT (envelope-from news) From: "Qingqing Zhou" X-Newsgroups: pgsql.admin Subject: Re: Hot Standby DB solution Date: Thu, 5 Jan 2006 18:40:04 -0500 Organization: Hub.Org Networking Services Lines: 20 Message-ID: References: <72558D9A7573814BB4082A28843E03D402339194@intyodc01.uk.ioko365.com> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-1.401 required=5 tests=[ALL_TRUSTED=-1.44, AWL=0.039] X-Spam-Score: -1.401 X-Spam-Level: X-Archive-Number: 200601/74 X-Sequence-Number: 20162 ""Nigel Bishop"" wrote > I'm investigating the use of a second server with a backup copy of the > live DB set up and in recovery mode. You may want to check out the Slony I project: http://gborg.postgresql.org/index.php BTW, if you want "cold" standby (means if one server crashed, the other will replay the WAL xlogs(takes seconds or hours, depends how much work needed to be redo), and startup and take the job), then there is a much easier solution of connect two machines on a shared-disk array. Regards, Qingqing