Re:

From: Jim Mercer <jim(at)reptiles(dot)org>
To: Jerry Sievers <gsievers19(at)comcast(dot)net>
Cc: Henry Korszun <henryk302(at)yahoo(dot)com>, Scott Whitney <swhitney(at)journyx(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re:
Date: 2014-04-27 19:49:41
Message-ID: 20140427194941.GA16052@reptiles.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Apr 25, 2014 at 01:23:30PM -0500, Jerry Sievers wrote:
> Henry Korszun <henryk302(at)yahoo(dot)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(at)reptiles(dot)org +1 416 410-5633
"He who dies with the most toys is nonetheless dead"

In response to

  • Re: at 2014-04-25 18:23:30 from Jerry Sievers

Responses

  • Re: at 2014-04-27 20:26:20 from David G Johnston

Browse pgsql-admin by date

  From Date Subject
Next Message David G Johnston 2014-04-27 20:26:20 Re:
Previous Message Tom Lane 2014-04-27 15:43:09 Re: EXPLAIN time difference in real