From: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
To: Bruno Wolff III <bruno@wolff.to>
Cc: pgsql-admin@postgresql.org
Subject: Re: Database Create Date
Date: Wed, 10 Jan 2007 19:39:09 +0000
Message-ID: <45A540DD.9050209@mailnetwork.co.uk> (raw)
In-Reply-To: <45A53F6F.50407@mailnetwork.co.uk>
References: <FE0C41EEBEF01C47BF3A91F606694468047BA9FE@PUNISHER.intra.infousa.com>
<200701091804.13499.achill@matrix.gatewaynet.com>
<45A3BE87.3060101@mailnetwork.co.uk>
<200701101000.38342.achill@matrix.gatewaynet.com>
<20070110183506.GA30057@wolff.to>
<45A53F6F.50407@mailnetwork.co.uk>
Andy Shellam (Mailing Lists) wrote:
> Bruno Wolff III wrote:
>> On Wed, Jan 10, 2007 at 10:00:37 +0200,
>> Achilleas Mantzios <achill@matrix.gatewaynet.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 --
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: andy.shellam-lists@mailnetwork.co.uk, bruno@wolff.to
Subject: Re: Database Create Date
In-Reply-To: <45A540DD.9050209@mailnetwork.co.uk>
References: <FE0C41EEBEF01C47BF3A91F606694468047BA9FE@PUNISHER.intra.infousa.com> <200701091804.13499.achill@matrix.gatewaynet.com> <45A3BE87.3060101@mailnetwork.co.uk> <200701101000.38342.achill@matrix.gatewaynet.com> <20070110183506.GA30057@wolff.to> <45A53F6F.50407@mailnetwork.co.uk> <45A540DD.9050209@mailnetwork.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox