On Thu, 30 Mar 2006, Michael Fuhr wrote:
> On Thu, Mar 30, 2006 at 05:20:00PM +0530, Pradeep Sharma wrote:
> > Thanks for the reply. But I guess there is some communication gap between
> > me and you regarding this topic. As I understood from your reply is, you
> > are talking about the date o
On Thu, Mar 30, 2006 at 05:27:12AM -0700, Michael Fuhr wrote:
> Try a command like the following:
>
> % ls -lt $PGDATA/base/*/PG_VERSION
>
> You should see that each database has a copy of this file and that
> each file has a different modification time (some might be within
> a few seconds of ea
On Thu, Mar 30, 2006 at 05:20:00PM +0530, Pradeep Sharma wrote:
> Thanks for the reply. But I guess there is some communication gap between
> me and you regarding this topic. As I understood from your reply is, you
> are talking about the date of Postgres setup/installation/upgrade.
No, I was ta
On Thu, 30 Mar 2006, Michael Fuhr wrote:
> On Thu, Mar 30, 2006 at 02:05:24PM +0530, Pradeep Sharma wrote:
> > Is there any way to get the date of creation of a database in Postgres?
> > Does postgres store this information in any system table.
>
> I'm not aware that the creation time is store
On Thu, Mar 30, 2006 at 02:05:24PM +0530, Pradeep Sharma wrote:
> Is there any way to get the date of creation of a database in Postgres?
> Does postgres store this information in any system table.
I'm not aware that the creation time is stored anywhere (except
perhaps in query logs) but you migh
Hi,
Is there any way to get the date of creation of a database in Postgres?
Does postgres store this information in any system table.
If anybody have any idea about this please let me know. I need to find
out the creation date of one of my database.
Thanks,
Pradeep
---
