On Fri, Sep 30, 2016 at 8:17 AM, Kevin Grittner <kgrittn@gmail.com> wrote: > On Thu, Sep 29, 2016 at 2:06 PM, Melvin Davidson <melvin6925@gmail.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
>Apparently some filesystems change the ctime for rename and others >don't, and POSIX tolerates both.
OK, thanks. Back to the future! :D
--
Melvin Davidson I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.