Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 071B32E0030 for ; Sun, 27 Apr 2008 20:58:33 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 24626-01 for ; Sun, 27 Apr 2008 20:58:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.250]) by developer.postgresql.org (Postfix) with ESMTP id C35142E0043 for ; Sun, 27 Apr 2008 20:58:29 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so1216570ana.33 for ; Sun, 27 Apr 2008 16:58:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=ajRsyfi9jx0eSlgTWziZ+CO2lXLwzxyjXzgY0N1vo4Y=; b=AacoakSM6Ywy5k3EsyEdE98MB00hYno6Ahzfeour8acYOpFC1mQ3Xig1r8OB7ANdZ5iCq8CQuZ1DyrGeo7ZpRnUvRrR94kMsizP6NAjkIJT2RL/c2EkZ4mTv5uS/kMlSBzgyX4Q4mw7AyfVJtXhumuZhBWDq27f7w8d+x/qW/2I= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Mh7HxZt4tKmwy7QrBpNauDR7MlkJKoD4l2PAHWhsK0NmVrFWrhKbWGZnX+D2JFCsDfpwMjaE46P8Ksi4yBlI57b4JaxcXjc4p0S0FLrqQTn2Xwc9WOudXNw1IOruDY/RcouzAIhsGVwZrd4LVALWVsO84y6w7ZJbiastzPq8Qv8= Received: by 10.100.12.1 with SMTP id 1mr10941592anl.35.1209340708812; Sun, 27 Apr 2008 16:58:28 -0700 (PDT) Received: by 10.100.3.5 with HTTP; Sun, 27 Apr 2008 16:58:28 -0700 (PDT) Message-ID: Date: Mon, 28 Apr 2008 09:58:28 +1000 From: "Charles Duffy" To: "kevin kempter" Subject: Re: warm standby issues Cc: pgsql-admin@postgresql.org In-Reply-To: <932B6BCD-0917-49BD-96B7-91395A4EC397@kevinkempterllc.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <932B6BCD-0917-49BD-96B7-91395A4EC397@kevinkempterllc.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/267 X-Sequence-Number: 29031 Hi Kevin, On Mon, Apr 28, 2008 at 7:34 AM, kevin kempter wrote: > Hi List; > > I'm setting up a warm standby server on version 8.1.9 > I didn't think 8.1 supported warm-standby... > I setup a recovery.sh script to keep the standby cluster in recovery mode > waiting for the next WAL segment. everything works fine as long as the > standby server is in recovery mode. I see the recovery taking place in the > postgres log of the standby server. I've set it up to exit the recovery.sh > script if it see's a trigger file (to bring the standby online). > > when I create the trigger file I see this: > > copy /home/postgres/healthCareCoding/WAL/000000010000000000000004 > pg_xlog/RECOVERYXLOG Try with 8.2 or above, and see if that makes your problem go away. Use pg_standby instead of shell scripts. Thanks, Charles Duffy