From: | Ken Hill <ken(at)scottshill(dot)com> |
---|---|
To: | Devrim GUNDUZ <devrim(at)commandprompt(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: How to find data directory |
Date: | 2005-12-19 01:29:21 |
Message-ID: | 1134955761.7555.9.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
There they are:
csalgorithm=# SELECT oid,datname FROM pg_database;
oid | datname
-------+-------------
17142 | testdb
17143 | csalgorithm
1 | template1
17141 | template0
(4 rows)
Thank you for the help!
On Mon, 2005-12-19 at 03:01 +0200, Devrim GUNDUZ wrote:
> 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,
From | Date | Subject | |
---|---|---|---|
Next Message | Zep | 2005-12-19 02:27:10 | postgres on gentoo. |
Previous Message | Peter Eisentraut | 2005-12-19 01:06:20 | Re: How to find data directory |