Re: How to find data directory

Hi,

On Sun, 18 Dec 2005, Ken Hill wrote:

> I have created two database named 'testdb' and 'csalgorithm'. How do I
> find these databases? I was expecting the databases to be subdirectories
> under the database directory (e.g. /var/lib/postresql/7.4/main/testdb
> and /var/lib/postgresql/7.4/main/csalgorithm).

First run these commands:

SELECT oid,datname FROM pg_database;

This will prompt you the oid and the corresponding database name. Say the
oid for the csalgorithm is 41030. Now cd to
/var/lib/postgresql/7.4/main/base/41030

But don't expect to see ascii database format there. :)

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/