From: | Devrim GUNDUZ <devrim(at)commandprompt(dot)com> |
---|---|
To: | Ken Hill <ken(at)scottshill(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: How to find data directory |
Date: | 2005-12-19 01:01:01 |
Message-ID: | Pine.LNX.4.63.0512190250550.28030@evim.gunduz.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-12-19 01:04:36 | Re: How to find data directory |
Previous Message | Ken Hill | 2005-12-19 00:34:16 | Re: How to find data directory |