| From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
|---|---|
| To: | Kevin Grittner <kgrittn(at)gmail(dot)com> |
| Cc: | Melvin Davidson <melvin6925(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Time travel? |
| Date: | 2016-09-29 19:20:23 |
| Message-ID: | CAEepm=3_bNetw5gsbRef6fTG5=Wri1uA2aenp=4+psXZXEcGgw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Sep 30, 2016 at 8:17 AM, Kevin Grittner <kgrittn(at)gmail(dot)com> wrote:
> On Thu, Sep 29, 2016 at 2:06 PM, Melvin Davidson <melvin6925(at)gmail(dot)com> wrote:
>
>> I am using PostgreSQL 9.4.0 (Yes, I know 9.4.9 is most recent but
>> it's out of my control)
>
> As long as the decision-maker is aware that 9.4.0 has known bugs
> (fixed in later minor releases) that can render the database
> unusable without warning...
>
>> How is it possible for the WAL file to be accessed BEFORE it was
>> created?
>
> Perhaps renaming it counts as "creation" without affecting access
> time.
Apparently some filesystems change the ctime for rename and others
don't, and POSIX tolerates both.
--
Thomas Munro
http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marek Petr | 2016-09-29 19:25:44 | Re: lost synchronization with server: got message type "Z" |
| Previous Message | Paul Jungwirth | 2016-09-29 19:19:13 | Re: Time travel? |