X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CE67A9FB280 for ; Fri, 28 Jul 2006 16:32:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 78727-07 for ; Fri, 28 Jul 2006 16:32:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 79F309FB279 for ; Fri, 28 Jul 2006 16:32:40 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Fri, 28 Jul 2006 19:32:33 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 28 Jul 2006 14:32:33 -0500 Subject: Re: Read db files directly From: Scott Marlowe To: Mingzuo Shen Cc: Aaron Bono , pgsql-admin@postgresql.org In-Reply-To: <20060728192354.84427.qmail@web60423.mail.yahoo.com> References: <20060728192354.84427.qmail@web60423.mail.yahoo.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1154115153.31664.129.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Fri, 28 Jul 2006 14:32:33 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.118 tagged_above=0 required=5 tests=AWL, SPF_PASS, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200607/268 X-Sequence-Number: 22514 Can you get postgresql to startup? Are you trying to use pg_ctl to start it or /etc/init.d/postgresql scripts? Basically, you need the database up and running first. When you "psql and pg_dump don't see those files" what errors are you actually getting? On Fri, 2006-07-28 at 14:23, Mingzuo Shen wrote: > Thanks Aaron. > > No. pg_dump, psql do not "see" those files. > As I said, psql -l shows "nothing". > pg_dumpall outputs nothing. > > strings 3476895975 > > for example, does show a lot of text, > some of them seem to be actual data > that I am interested in extracting. > > If I create a new db and create new tables > in the new db, then they work as usual. > > > > --- Aaron Bono wrote: > > > On 7/22/06, Shen, Mingzuo wrote: > > > > > > Hello, > > > > > > I see some OS files (50+ GB total) but cannot see > > anything in psql -l. > > > There seem to be some big tables there. > > > I wonder if there are some tools that would dump > > the tables in text. > > > or, how to make PostgreSQL "connect" to these > > files again? > > > > > > > You can dump the whole database contents with > > pg_dump. This dumps your > > whole database with data into a text file. Is this > > what you mean? > > > > > ================================================================== > > Aaron Bono > > Aranya Software Technologies, Inc. > > http://www.aranya.com > > > ================================================================== > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings