Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id EE2659FB24D for ; Tue, 9 Jan 2007 12:11:27 -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 84197-01-3 for ; Tue, 9 Jan 2007 12:11:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 2B1129FB21D for ; Tue, 9 Jan 2007 12:11:16 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l09GBDUs008057; Tue, 9 Jan 2007 11:11:13 -0500 (EST) To: Achilleas Mantzios cc: pgsql-admin@postgresql.org Subject: Re: Database Create Date In-reply-to: <200701091804.13499.achill@matrix.gatewaynet.com> References: <45A3B67F.30209@mailnetwork.co.uk> <200701091804.13499.achill@matrix.gatewaynet.com> Comments: In-reply-to Achilleas Mantzios message dated "Tue, 09 Jan 2007 18:04:13 +0200" Date: Tue, 09 Jan 2007 11:11:13 -0500 Message-ID: <8056.1168359073@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/76 X-Sequence-Number: 24232 Achilleas Mantzios writes: > However i could not find any inode creation time related info for linux > (ext3). I don't believe it keeps that. You could possibly look at the mod time on the PG_VERSION file ... Postgres never touches that after DB creation. This is not, however, much of a guarantee as something else could have changed it, eg a file backup/restore process. regards, tom lane