pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim Mercer <jim@reptiles.org>
To: Jerry Sievers <gsievers19@comcast.net>
Cc: Henry Korszun <henryk302@yahoo.com>
Cc: Scott Whitney <swhitney@journyx.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re:
Date: Sun, 27 Apr 2014 15:49:41 -0400
Message-ID: <20140427194941.GA16052@reptiles.org> (raw)
In-Reply-To: <86k3adw9nh.fsf@jerry.enova.com>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

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



view thread (11+ messages)  latest in thread

Message-ID: <20140427194941.GA16052@reptiles.org>
Permalink:  ../20140427194941.GA16052@reptiles.org/
Also on:    postgresql.org/message-id/20140427194941.GA16052@reptiles.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: jim@reptiles.org, gsievers19@comcast.net, henryk302@yahoo.com, swhitney@journyx.com
  Subject: Re:
  In-Reply-To: <20140427194941.GA16052@reptiles.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox