Re: Time travel?

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: Time travel?
Дата
Msg-id CANu8FiyVCJEMsfHg6GraojJUDti_J4n-uo1LBrC+MrciJuhifQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Time travel?  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-general


On Thu, Sep 29, 2016 at 3:20 PM, Thomas Munro <thomas.munro@enterprisedb.com> wrote:
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Vinicius Segalin
Дата:
Сообщение: Query generator
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Query generator