"Ian Lipsky" <postgres(at)merk(dot)caltech(dot)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
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
In response to
pgsql-admin by date
|Next:||From: Somasekhar Bangalore||Date: 2004-06-01 04:27:54|
|Subject: Re: determining when a database was created |
|Previous:||From: Ian Lipsky||Date: 2004-06-01 00:49:31|
|Subject: Re: determining when a database was created|