Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TOZbm-0008Tb-76 for pgsql-admin@postgresql.org; Wed, 17 Oct 2012 19:48:50 +0000 Received: from mail.dhs-club.com ([208.69.229.2]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TOZbf-0004Ro-Pm for pgsql-admin@postgresql.org; Wed, 17 Oct 2012 19:48:49 +0000 Received: from [192.168.2.108] (c-68-56-241-190.hsd1.fl.comcast.net [68.56.241.190]) (authenticated bits=0) by mail.dhs-club.com (8.14.4/8.14.4) with ESMTP id q9HJmgKh008482 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO) for ; Wed, 17 Oct 2012 19:48:42 GMT Message-ID: <507F0B95.5010002@dhs-club.com> Date: Wed, 17 Oct 2012 15:48:37 -0400 From: Bill MacArthur User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:16.0) Gecko/20121010 Thunderbird/16.0.1 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Postgresql switch over process References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.70 on 208.69.229.2 X-Pg-Spam-Score: -2.3 (--) X-Archive-Number: 201210/60 X-Sequence-Number: 40176 On 10/17/2012 3:20 PM, Shams Khan wrote: > Can somebody tell me how we can automate the switch over process, I > know there is once file recovery.conf which contains the parameter > trigger_file. But my question is what code that file contains....Hope > my thinking is correct. > > The trigger file itself contains nothing. You can simply create an empty file when it's needed. You can use 'touch' in linux. The server will see that it has appeared and do what it needs to do from there. Bill MacArthur