determining when a database was created
determining when a database was created
От:
Ian Lipsky <postgres@merk.caltech.edu>
Дата:
is there a way to tell when a database was created? I've tried looking in some of the postgres system tables but i didnt see any that looked like it had a creation date. I would have also looked at the date the data folder for the database was created, but i didnt know which folder belonged to which database. Is there a way to find out the date the db was created? thanks
Re: determining when a database was created
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Ian Lipsky writes: > is there a way to tell when a database was created? Nope, PG doesn't record that anywhere. You could get an upper bound by looking for the oldest file mod time in the database's files. This isn't completely reliable, but unless you're in the habit of changing system catalogs as obscure as pg_am, it'd probably be good enough. regards, tom lane
Re: determining when a database was created
От:
"Ian Lipsky" <postgres@merk.caltech.edu>
Дата:
How can i determine which directory contains the database files? there are a few databases. I
though of doing that, but didnt know how to tell which directory belongs with which database.
thanks
----- Original Message -----
From: Tom Lane
To: Ian Lipsky
Cc: pgsql-admin@postgresql.org
Sent: Mon, 31 May 2004 00:37:40 -0400
Subject: Re: [ADMIN] determining when a database was created
Ian Lipsky writes:
> is there a way to tell when a database was created?
Nope, PG doesn't record that anywhere.
You could get an upper bound by looking for the oldest file mod time in
the database's files. This isn't completely reliable, but unless you're
in the habit of changing system catalogs as obscure as pg_am, it'd
probably be good enough.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Re: determining when a database was created
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Ian Lipsky" writes: > How can i determine which directory contains the database files? there > are a few databases. The database directory names correspond to the OID column of pg_database. So: SELECT datname, oid from pg_database; (BTW, this is likely to change in 7.5 if tablespaces get done.) See also the contrib/oid2name tool. regards, tom lane
Re: determining when a database was created
От:
"Somasekhar Bangalore" <sbangalore@zensutra.com>
Дата:
Hi All, Is there a tool , where in i can convert data from postgres 7.3.2 to oracle 9i. thanks in advance som -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Tuesday, June 01, 2004 7:17 AM To: Ian Lipsky Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] determining when a database was created "Ian Lipsky" writes: > How can i determine which directory contains the database files? there > are a few databases. The database directory names correspond to the OID column of pg_database. So: SELECT datname, oid from pg_database; (BTW, this is likely to change in 7.5 if tablespaces get done.) See also the contrib/oid2name tool. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Re: determining when a database was created
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Somasekhar Bangalore" writes: > Is there a tool , where in i can convert data from postgres 7.3.2 to oracle 9i. No doubt Oracle Corp. would be pleased to assist you with this question. I'm not sure why you expect a bunch of Postgres people to know the answer, though. regards, tom lane
Re: determining when a database was created
От:
Gaetano Mendola <mendola@bigfoot.com>
Дата:
Somasekhar Bangalore wrote: > Hi All, > > Is there a tool , where in i can convert data from postgres 7.3.2 to oracle 9i. http://www.oracle.com/support/index.html?contact.html > thanks in advance > som U'r welcome. Regards Gaeatano Mendola