Re: Reading information from crashed PGDATA

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: veejar <veejar(dot)net(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Reading information from crashed PGDATA
Date: 2008-03-20 16:51:11
Message-ID: 20080320165111.GE6235@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vishal Arora 2008-03-20 16:52:22 Re: Postgres Performance
Previous Message Ray Stell 2008-03-20 16:07:12 Re: lock help