X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 08A879DC878 for ; Sun, 18 Dec 2005 21:01:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53608-10 for ; Sun, 18 Dec 2005 21:01:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.kivi.com.tr (mail.kivi.com.tr [213.143.254.37]) by postgresql.org (Postfix) with ESMTP id A37119DC86E for ; Sun, 18 Dec 2005 21:01:12 -0400 (AST) Received: from evim.gunduz.org (unknown [81.215.14.250]) by mail.kivi.com.tr (Postfix) with ESMTP id 359658000F; Mon, 19 Dec 2005 03:01:02 +0200 (EET) Date: Mon, 19 Dec 2005 03:01:01 +0200 (EET) From: Devrim GUNDUZ X-X-Sender: devrim@evim.gunduz.org To: Ken Hill Cc: pgsql-admin@postgresql.org Subject: Re: How to find data directory In-Reply-To: <1134952457.7555.5.camel@localhost.localdomain> Message-ID: References: <1134772264.7276.2.camel@localhost.localdomain> <1134784056.7354.2.camel@localhost.localdomain> <1134952457.7555.5.camel@localhost.localdomain> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Kivi-MailScanner-Information: Please contact the ISP for more information X-Kivi-MailScanner: Found to be clean X-Kivi-MailScanner-SpamCheck: not spam, SpamAssassin (score=0.187, required 6, autolearn=disabled, FORGED_RCVD_HELO 0.05, RCVD_IN_SORBS_DUL 0.14) X-Kivi-MailScanner-From: devrim@commandprompt.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.117 required=5 tests=[AWL=0.117] X-Spam-Score: 0.117 X-Spam-Level: X-Archive-Number: 200512/190 X-Sequence-Number: 19910 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/