Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 99C199FB721 for ; Thu, 1 Mar 2007 08:39:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 28552-04 for ; Thu, 1 Mar 2007 08:39:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail3.sun.ac.za (mail3.sun.ac.za [146.232.64.13]) by postgresql.org (Postfix) with ESMTP id A3D9C9FB5A4 for ; Thu, 1 Mar 2007 08:39:20 -0400 (AST) Received: from burger.sun.ac.za ([146.232.128.30]) by mail3.sun.ac.za with esmtp (Exim 4.34) id 1HMkZ2-0001mb-ST for pgsql-admin@postgresql.org; Thu, 01 Mar 2007 14:39:17 +0200 Received: from js by burger.sun.ac.za with local (Exim 4.63) (envelope-from ) id 1HMkZ2-0007Lj-QH for pgsql-admin@postgresql.org; Thu, 01 Mar 2007 14:39:16 +0200 Date: Thu, 1 Mar 2007 14:39:16 +0200 From: Johann Spies To: pgsql-admin@postgresql.org Subject: Re: Warm standby (solved) Message-ID: <20070301123916.GA28190@sun.ac.za> Mail-Followup-To: Johann Spies , pgsql-admin@postgresql.org References: <20070227083437.GA14003@sun.ac.za> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20070227083437.GA14003@sun.ac.za> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200703/2 X-Sequence-Number: 24826 On Tue, Feb 27, 2007 at 10:34:37AM +0200, Johann Spies wrote: > I want to setup a form of replication for postgresql using the warm > standby option > (http://www.postgresql.org/docs/8.2/static/warm-standby.html) > > I have had success to let server A to copy the WAL logs to server B (the > standby server). But I have had no success on the recovery side of > things. I might just be overlooking something. My problem was that I had recovery.conf in the same directory where postgresql.conf is on Debian (/etc/postgresql/8.2/main/). Moving it to /var/lib/postgresql/8.2/main/ solved the problem. Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch "The LORD is my shepherd; I shall not want. He maketh me to lie down in green pastures: he leadeth me beside the still waters, he restoreth my soul...Surely goodness and mercy shall follow me all the days of my life; and I will dwell in the house of the LORD for ever." Psalms 23:1,2,6