Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6E7629FA3AC for ; Wed, 10 Jan 2007 04:00:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 39979-02 for ; Wed, 10 Jan 2007 04:00:44 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by postgresql.org (Postfix) with ESMTP id 1F5289F9F75 for ; Wed, 10 Jan 2007 04:00:41 -0400 (AST) Received: from host3.dynacom.ondsl.gr ([62.103.35.211] helo=ip216.internal.net) by matrix.gatewaynet.com with esmtp (Exim 4.62) (envelope-from ) id 1H4YNy-0001pH-QK for pgsql-admin@postgresql.org; Wed, 10 Jan 2007 10:00:38 +0200 From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: Database Create Date Date: Wed, 10 Jan 2007 10:00:37 +0200 User-Agent: KMail/1.9.3 References: <200701091804.13499.achill@matrix.gatewaynet.com> <45A3BE87.3060101@mailnetwork.co.uk> In-Reply-To: <45A3BE87.3060101@mailnetwork.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-7" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200701101000.38342.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/81 X-Sequence-Number: 24237 =D3=F4=E9=F2 =D4=F1=DF=F4=E7 09 =C9=E1=ED=EF=F5=DC=F1=E9=EF=F2 2007 18:10, = =EF/=E7 Andy Shellam (Mailing Lists) =DD=E3=F1=E1=F8=E5: > 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=3Datime" > No, it seems ext3 does not keep this info. (See also Tom's answer). > Also in FreeBSD (at least, 6.1) there is no "-U" option to ls; there is > a "-u" option but this shows the last access, not the creation time. It must have been introduced somewhere in the 6.1-STABLE cycle. =46or my dev machine (6.1-STABLE #8) "-U" support is included, whereas in my other pet machine 6.1-PRERELEASE #1 it is not. =2D-=20 Achilleas Mantzios