Re: Database Create Date

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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-09 16:11:13
Message-ID: 8056.1168359073@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2007-01-09 16:30:39 Re: PITR recovery
Previous Message Andy Shellam (Mailing Lists) 2007-01-09 16:10:47 Re: Database Create Date