Postgres Pro
Downloads
Home   >   mailing lists

Re: Read db files directly - Mailing list pgsql-admin

From Aaron Bono
Subject Re: Read db files directly
Date
Msg-id bf05e51c0607281156o5fb9e3bbr776900000db27972@mail.gmail.com
Whole thread Raw
In response to Read db files directly  ("Shen, Mingzuo" <mshen@bcm.edu>)
Responses Re: Read db files directly  (Mingzuo Shen <mzshen@yahoo.com>)
List pgsql-admin
Tree view
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
==================================================================

pgsql-admin by date:

Previous
From: "Aaron Bono"
Date:
Subject: Re: ODBC connection problem
Next
From: Mingzuo Shen
Date:
Subject: Re: Read db files directly