pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
determining when a database was created
7+ messages / 4 participants
[nested] [flat]

* determining when a database was created
@ 2004-05-29 00:56 Ian Lipsky <postgres@merk.caltech.edu>
  2004-05-31 04:37 ` Re: determining when a database was created Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 7+ messages in thread

From: Ian Lipsky @ 2004-05-29 00:56 UTC (permalink / raw)
  To: pgsql-admin

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





^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: determining when a database was created
  2004-05-29 00:56 determining when a database was created Ian Lipsky <postgres@merk.caltech.edu>
@ 2004-05-31 04:37 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2004-05-31 04:37 UTC (permalink / raw)
  To: Ian Lipsky <postgres@merk.caltech.edu>; +Cc: pgsql-admin

Ian Lipsky <postgres@merk.caltech.edu> 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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: determining when a database was created
@ 2004-06-01 00:49 Ian Lipsky <postgres@merk.caltech.edu>
  2004-06-01 01:46 ` Re: determining when a database was created Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 7+ messages in thread

From: Ian Lipsky @ 2004-06-01 00:49 UTC (permalink / raw)
  To: pgsql-admin

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 <postgres@merk.caltech.edu>
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 <postgres@merk.caltech.edu> 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




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: determining when a database was created
  2004-06-01 00:49 Re: determining when a database was created Ian Lipsky <postgres@merk.caltech.edu>
@ 2004-06-01 01:46 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2004-06-01 01:46 UTC (permalink / raw)
  To: Ian Lipsky <postgres@merk.caltech.edu>; +Cc: pgsql-admin

"Ian Lipsky" <postgres@merk.caltech.edu> 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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: determining when a database was created
@ 2004-06-01 04:27 Somasekhar Bangalore <sbangalore@zensutra.com>
  2004-06-01 05:32 ` Re: determining when a database was created Tom Lane <tgl@sss.pgh.pa.us>
  2004-06-02 22:42 ` Re: determining when a database was created Gaetano Mendola <mendola@bigfoot.com>
  0 siblings, 2 replies; 7+ messages in thread

From: Somasekhar Bangalore @ 2004-06-01 04:27 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

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" <postgres@merk.caltech.edu> 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




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: determining when a database was created
  2004-06-01 04:27 Re: determining when a database was created Somasekhar Bangalore <sbangalore@zensutra.com>
@ 2004-06-01 05:32 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 7+ messages in thread

From: Tom Lane @ 2004-06-01 05:32 UTC (permalink / raw)
  To: Somasekhar Bangalore <sbangalore@zensutra.com>; +Cc: pgsql-admin

"Somasekhar Bangalore" <sbangalore@zensutra.com> 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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: determining when a database was created
  2004-06-01 04:27 Re: determining when a database was created Somasekhar Bangalore <sbangalore@zensutra.com>
@ 2004-06-02 22:42 ` Gaetano Mendola <mendola@bigfoot.com>
  1 sibling, 0 replies; 7+ messages in thread

From: Gaetano Mendola @ 2004-06-02 22:42 UTC (permalink / raw)
  To: Somasekhar Bangalore <sbangalore@zensutra.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







^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2004-06-02 22:42 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-29 00:56 determining when a database was created Ian Lipsky <postgres@merk.caltech.edu>
2004-05-31 04:37 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-06-01 00:49 Re: determining when a database was created Ian Lipsky <postgres@merk.caltech.edu>
2004-06-01 01:46 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-06-01 04:27 Re: determining when a database was created Somasekhar Bangalore <sbangalore@zensutra.com>
2004-06-01 05:32 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-06-02 22:42 ` Gaetano Mendola <mendola@bigfoot.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox