From: David G Johnston <david.g.johnston@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re:
Date: Sun, 27 Apr 2014 13:26:20 -0700 (PDT)
Message-ID: <1398630380571-5801671.post@n5.nabble.com> (raw)
In-Reply-To: <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>
<20140427194941.GA16052@reptiles.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Jim Mercer wrote
> On Fri, Apr 25, 2014 at 01:23:30PM -0500, Jerry Sievers wrote:
>> Henry Korszun <
> henryk302@
> > 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.
I'm seriously doubting the timestamp info matters - the timestamp would
almost always be in the past (specifying a future recovery date doesn't make
sense anyway) and no arbitrary age is reasonable to make the file invalid
and would be extremely confusing if one did.
"Touch" is a shorthand for "a file whose mere existence is all that is
necessary" and by convention implies that what is in the file doesn't matter
(since actually touching a non-existent file creates a new empty file).
If the file already existed (not that timeframes are being defined all that
well here) the system would never have been in recovery mode...
Henry's last comment is that it is not known what process is creating the
empty trigger file in the first place - whether that process uses touch or
some other means to create the file is irrelevant to the issue at hand.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/no-subject-tp5801536p5801671.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: david.g.johnston@gmail.com
Subject: Re:
In-Reply-To: <1398630380571-5801671.post@n5.nabble.com>
* 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