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>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database Create Date
Date: 2007-01-10 19:39:09
Message-ID: 45A540DD.9050209@mailnetwork.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Andy Shellam (Mailing Lists) wrote:
> 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?

Hmm ok just done a bit of experimenting on this - "atime" and "access"
show exactly the same information - "mtime" is an invalid value
according to my Fedora 5 system. Confused.

-- start paste --

ls -l / --time=mtime
ls: invalid argument `mtime' for `--time'
Valid arguments are:
- `atime', `access', `use'
- `ctime', `status'
Try `ls --help' for more information.

-- end paste --

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2007-01-10 20:15:47 Re: Database Create Date
Previous Message Andy Shellam (Mailing Lists) 2007-01-10 19:33:03 Re: Database Create Date