Re: Reading information from crashed PGDATA - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Reading information from crashed PGDATA
Date
Msg-id 20080320165111.GE6235@alvh.no-ip.org
Whole thread Raw
In response to Reading information from crashed PGDATA  (veejar <veejar.net@gmail.com>)
List pgsql-admin
veejar escribió:

> When I have only folder base or base+global, can I read tables data
> from databases in such PGDATA via any tools or methods?

No, you need pg_clog at the very least.  pg_xlog, pg_multixact and
pg_subtrans are almost equally important -- I think you could start
without them but it's not unlikely that your data would be corrupt.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-admin by date:

Previous
From: Ray Stell
Date:
Subject: Re: lock help
Next
From: Vishal Arora
Date:
Subject: Re: Postgres Performance