Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42435=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WeV5D-0003IX-01
 for pgsql-admin@arkaria.postgresql.org; Sun, 27 Apr 2014 19:49:51 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42435=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WeV5C-0008RT-FM
 for pgsql-admin@arkaria.postgresql.org; Sun, 27 Apr 2014 19:49:50 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <jim@reptiles.org>) id 1WeV5B-0008RM-ET
 for pgsql-admin@postgresql.org; Sun, 27 Apr 2014 19:49:49 +0000
Received: from mailbox.reptiles.org ([198.96.117.3])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <jim@reptiles.org>) id 1WeV58-0002Ez-9u
 for pgsql-admin@postgresql.org; Sun, 27 Apr 2014 19:49:48 +0000
Received: from localhost by mailbox.reptiles.org
 via sendmail with STDIO (1804 bytes) (sender: <jim@reptiles.org>)
 (ident <jim> using UNIX) id <m1WeV53-000zdaC@mailbox.reptiles.org>
 for <pgsql-admin@postgresql.org>;
 Sun, 27 Apr 2014 15:49:41 -0400 (EDT)
 (Smail-3.2.0.121 2005-Nov-17 #10 built 2010-Jul-16)
Date: Sun, 27 Apr 2014 15:49:41 -0400
From: Jim Mercer <jim@reptiles.org>
To: Jerry Sievers <gsievers19@comcast.net>
Cc: Henry Korszun <henryk302@yahoo.com>, Scott Whitney <swhitney@journyx.com>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: 
Message-ID: <20140427194941.GA16052@reptiles.org>
References: <1398447433.8578.YahooMailNeo@web162701.mail.bf1.yahoo.com>
 <712112871.331097.1398447813672.JavaMail.zimbra@mail.int.journyx.com>
 <1398448636.25048.YahooMailNeo@web162704.mail.bf1.yahoo.com>
 <2131729726.331419.1398448843621.JavaMail.zimbra@mail.int.journyx.com>
 <1398449399.70260.YahooMailNeo@web162701.mail.bf1.yahoo.com>
 <86k3adw9nh.fsf@jerry.enova.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <86k3adw9nh.fsf@jerry.enova.com>
User-Agent: Mutt/1.5.20 (2009-06-14)
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On Fri, Apr 25, 2014 at 01:23:30PM -0500, Jerry Sievers wrote:
> Henry Korszun <henryk302@yahoo.com> writes:
> > I understand what you're saying, but I don't know what's causing the "touch" in the first place.  I guess I need to further examine/debug. Thanks for your help.

it may be a semantic difference, but is recovery_mode dependent on the existence
of the trigger file, or the timestamp.

"touch" in the above context could either be the creation of the file,
or simply updating the timestamp of the file.

i suspect that the recovery is triggered by the mere existence of the file,
while henry might be talking in the 'update timestamp' context.

--jim

-- 
Jim Mercer     Reptilian Research      jim@reptiles.org    +1 416 410-5633
"He who dies with the most toys is nonetheless dead"


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin