pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ian Lipsky <postgres@merk.caltech.edu>
To: pgsql-admin@postgresql.org
Subject: Re: determining when a database was created
Date: Mon, 31 May 2004 16:49:31 -0800
Message-ID: <FD06100DD83F4B1BAA060752ED006C5D.MAI@merk.caltech.edu> (raw)

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




view thread (7+ messages)  latest in thread

Message-ID: <FD06100DD83F4B1BAA060752ED006C5D.MAI@merk.caltech.edu>
Permalink:  ../FD06100DD83F4B1BAA060752ED006C5D.MAI@merk.caltech.edu/
Also on:    postgresql.org/message-id/FD06100DD83F4B1BAA060752ED006C5D.MAI@merk.caltech.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: postgres@merk.caltech.edu
  Subject: Re: determining when a database was created
  In-Reply-To: <FD06100DD83F4B1BAA060752ED006C5D.MAI@merk.caltech.edu>
  References: <FD06100DD83F4B1BAA060752ED006C5D.MAI@merk.caltech.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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