Re: Read db files directly

["Aaron Bono" <postgresql(at)aranya(dot)com>]

On 7/22/06, Shen, Mingzuo <mshen(at)bcm(dot)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
==================================================================