Re: Database Create Date

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database Create Date
Date: 2007-01-10 18:35:06
Message-ID: 20070110183506.GA30057@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andy Shellam (Mailing Lists) 2007-01-10 19:33:03 Re: Database Create Date
Previous Message Alexander Burbello 2007-01-10 18:03:18 Lob datatype