| From: | Paul Jungwirth <pj(at)illuminatedcomputing(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Time travel? |
| Date: | 2016-09-29 19:19:13 |
| Message-ID: | 0d0cb95b-bf81-ef0b-ffe2-1bcf1da87f2d@illuminatedcomputing.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2016-09-29 19:20:23 | Re: Time travel? |
| Previous Message | Rakesh Kumar | 2016-09-29 19:18:53 | Multi tenancy : schema vs databases |