Re: Time travel? - Mailing list pgsql-general

From Paul Jungwirth
Subject Re: Time travel?
Date
Msg-id 0d0cb95b-bf81-ef0b-ffe2-1bcf1da87f2d@illuminatedcomputing.com
Whole thread Raw
In response to Time travel?  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Hi Melvin:

On 09/29/2016 12:06 PM, Melvin Davidson wrote:
> I list the creation time for a WAL file and it shows:
>
>  /home/mdavidson/dba$ ls -l --time=ctime
> /d-log/pg_xlog/000000010000000D000000C9
> -rw------- 1 postgres postgres 16777216 Sep 29 07:14
> /d-log/pg_xlog/000000010000000D000000C9

ctime stands for "changed" not "created". It is not quite the same as
mtime ("modified") because mtime is updated only when the file contents
change, but ctime is updated if either the file contents or file
attributes change:

http://www.linux-faqs.info/general/difference-between-mtime-ctime-and-atime

I hope that explains it!

Paul


pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Time travel?
Next
From: Rakesh Kumar
Date:
Subject: Multi tenancy : schema vs databases