Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Vishal AroraDate: 2008-03-20 16:52:22
Subject: Re: Postgres Performance
Previous:From: Ray StellDate: 2008-03-20 16:07:12
Subject: Re: lock help

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group