Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f740WB665766; Fri, 3 Aug 2001 20:32:11 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f7406XT46884; Fri, 3 Aug 2001 20:06:34 -0400 (EDT) (envelope-from news) From: caldodge@fpcc.net (Calvin Dodge) X-Newsgroups: comp.databases.postgresql.general,comp.databases.postgresql.sql Subject: Re: Where is the database located in 7.1.2? Date: 3 Aug 2001 17:06:31 -0700 Organization: http://groups.google.com/ Lines: 31 Message-ID: References: <3B6AAD1B.3EE76D65@noaa.gov> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-general@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200108/70 X-Sequence-Number: 13291 Raymond Chui wrote in message news:<3B6AAD1B.3EE76D65@noaa.gov>... > I installed PostgreSQL 7.1.2 in Redhat 6.2 > > Now in 7.1.2 when I > > cd $PGDATA/data/base > ls > > I only see some directories like 1, 18719, 18725 > I don't see my dbname. Where is my dbname located now in v7.1.2? > Thank you! Start psql in the database of your choice. Type: select oid,datname from pg_database; Look at the oids - you'll see that each one corresponds to one of those funny numbered directories. For example, one such line on my system is: 88721 | phpgroupware Sure enough, in /var/lib/pgsql/data/base there is a directory called "88721". So directory "88721" contains the "phpgroupware" database on my system. Calvin