Re: Read db files directly

From: "Aaron Bono" <postgresql(at)aranya(dot)com>
To: "Shen, Mingzuo" <mshen(at)bcm(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Read db files directly
Date: 2006-07-28 18:56:31
Message-ID: bf05e51c0607281156o5fb9e3bbr776900000db27972@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
==================================================================

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mingzuo Shen 2006-07-28 19:23:54 Re: Read db files directly
Previous Message Aaron Bono 2006-07-28 18:53:49 Re: ODBC connection problem