Re: - Mailing list pgsql-admin

From Jim Mercer
Subject Re:
Date
Msg-id 20140427194941.GA16052@reptiles.org
Whole thread Raw
In response to Re:  (Jerry Sievers <gsievers19@comcast.net>)
Responses Re:  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-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
furtherexamine/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"


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: EXPLAIN time difference in real
Next
From: David G Johnston
Date:
Subject: Re: