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 673779FB27A for ; Fri, 28 Jul 2006 16:24:41 -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 75972-10 for ; Fri, 28 Jul 2006 16:24:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web60423.mail.yahoo.com (web60423.mail.yahoo.com [209.73.178.151]) by postgresql.org (Postfix) with SMTP id 190729FB278 for ; Fri, 28 Jul 2006 16:23:57 -0300 (ADT) Received: (qmail 84429 invoked by uid 60001); 28 Jul 2006 19:23:54 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=TeO+FR5LeGmDXnzfXYeEOMVk2O7DbzTb577lFNQC2DalyfXktY/4Fs5uT0c1F+s/NWsJtoz9T8RsQcklB+wk621nWNXUX00OJmuZCyIh9hBV3CBaWsII3LjofEAMTHpmCiJXjnv4WQW5cSqhMoVRS2Nl6fITqkSI26hij8x8Inw= ; Message-ID: <20060728192354.84427.qmail@web60423.mail.yahoo.com> Received: from [128.249.216.224] by web60423.mail.yahoo.com via HTTP; Fri, 28 Jul 2006 12:23:54 PDT Date: Fri, 28 Jul 2006 12:23:54 -0700 (PDT) From: Mingzuo Shen Subject: Re: Read db files directly To: Aaron Bono Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.566 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: ** X-Archive-Number: 200607/267 X-Sequence-Number: 22513 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 > ================================================================== >