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 7BA359FB282 for ; Fri, 28 Jul 2006 15:56:52 -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 74948-05 for ; Fri, 28 Jul 2006 15:56:37 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by postgresql.org (Postfix) with ESMTP id 41D2C9FB27A for ; Fri, 28 Jul 2006 15:56:33 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id p77so275809nfc for ; Fri, 28 Jul 2006 11:56:31 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=GMZdBAulY+avjrM3JZ0g00mTwNsMVORyyzysk36HK4yhwM6otaeobwbzUd7/TDW1BYBaig01SD7nnWFm24+uCMW6WxNmKQmWQY8h4In83VNd0guN/rpKXLMvMsUtV+RzdP4imzBRuUrDChCKffxxwfHno+GLdpEETTTfYBtCZ6k= Received: by 10.78.97.7 with SMTP id u7mr964823hub; Fri, 28 Jul 2006 11:56:31 -0700 (PDT) Received: by 10.78.32.10 with HTTP; Fri, 28 Jul 2006 11:56:31 -0700 (PDT) Message-ID: Date: Fri, 28 Jul 2006 13:56:31 -0500 From: "Aaron Bono" To: "Shen, Mingzuo" Subject: Re: Read db files directly Cc: pgsql-admin@postgresql.org In-Reply-To: <348804AD98B8F5458642AA62348E35FE01BC992A@BCMEVS1.ad.bcm.edu> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13228_1822290.1154112991369" References: <348804AD98B8F5458642AA62348E35FE01BC992A@BCMEVS1.ad.bcm.edu> X-Google-Sender-Auth: 0581fa0cc4edb39f X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.385 tagged_above=0 required=5 tests=AWL, HTML_50_60, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/266 X-Sequence-Number: 22512 ------=_Part_13228_1822290.1154112991369 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ================================================================== ------=_Part_13228_1822290.1154112991369 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/22/06, Shen, Mingzuo <mshen@bcm.edu> 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
================================================================== ------=_Part_13228_1822290.1154112991369--