Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A3ABA9FB228 for ; Wed, 10 Jan 2007 14:35:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 48026-04 for ; Wed, 10 Jan 2007 14:35:07 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id F29019FA43F for ; Wed, 10 Jan 2007 14:35:07 -0400 (AST) Received: (qmail 30203 invoked by uid 500); 10 Jan 2007 18:35:06 -0000 Date: Wed, 10 Jan 2007 12:35:06 -0600 From: Bruno Wolff III To: Achilleas Mantzios Cc: pgsql-admin@postgresql.org Subject: Re: Database Create Date Message-ID: <20070110183506.GA30057@wolff.to> Mail-Followup-To: Bruno Wolff III , Achilleas Mantzios , pgsql-admin@postgresql.org References: <200701091804.13499.achill@matrix.gatewaynet.com> <45A3BE87.3060101@mailnetwork.co.uk> <200701101000.38342.achill@matrix.gatewaynet.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200701101000.38342.achill@matrix.gatewaynet.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/88 X-Sequence-Number: 24244 On Wed, Jan 10, 2007 at 10:00:37 +0200, Achilleas Mantzios 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.