Skip site navigation (1) Skip section navigation (2)

Re: Database Create Date

From: "Andy Shellam (Mailing Lists)" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>
To: Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Database Create Date
Date: 2007-01-10 19:33:03
Message-ID: 45A53F6F.50407@mailnetwork.co.uk (view raw or flat)
Thread:
Lists: pgsql-admin
Bruno Wolff III wrote:
> On Wed, Jan 10, 2007 at 10:00:37 +0200,
>   Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> wrote:
>   
>> Στις Τρίτη 09 Ιανουάριος 2007 18:10, ο/η Andy Shellam (Mailing Lists) έγραψε:
>>     
>>> Achilleas Mantzios wrote:
>>>       
>>>> I was able to find that in FreeBSD the -U in ls (1) does the job.
>>>> However i could not find any inode creation time related info for linux
>>>> (ext3).
>>>> Anyone has any clue on that?
>>>>         
>>> I believe "ls -l" by default shows the created time, you can switch to
>>> show the last modified time using "ls -l --time=atime"
>>>       
>
> Just another note on this, atime is the last access time. ctime is the real
> last modify time, mtime is another modify time that can be changed (which
> is useful after backups). atime is often disabled in ext3 file systems to
> reduce I/O, since it isn't all that useful.
>   
I thought it was as well to begin with - but in "ls" on Linux there's a 
separate "atime" and "access" value to the "show time" parameter in "ls" 
- so if "atime" is the last access time, what's "access" mean?

In response to

Responses

pgsql-admin by date

Next:From: Andy Shellam (Mailing Lists)Date: 2007-01-10 19:39:09
Subject: Re: Database Create Date
Previous:From: Bruno Wolff IIIDate: 2007-01-10 18:35:06
Subject: Re: Database Create Date

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group