Reading information from crashed PGDATA

From: veejar <veejar(dot)net(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Reading information from crashed PGDATA
Date: 2008-03-20 16:02:55
Message-ID: a4c4d7e50803200902x26549357l3aec2884fcda1f9e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

This information I have found in PostgreSQL docs:

Table 52-1. Contents of PGDATA

PG_VERSION A file containing the major version number of PostgreSQL
base Subdirectory containing per-database subdirectories
global Subdirectory containing cluster-wide tables, such as pg_database
pg_clog Subdirectory containing transaction commit status data
pg_multixact Subdirectory containing multitransaction status data
(used for shared row locks)
pg_subtrans Subdirectory containing subtransaction status data
pg_tblspc Subdirectory containing symbolic links to tablespaces
pg_twophase Subdirectory containing state files for prepared transactions
pg_xlog Subdirectory containing WAL (Write Ahead Log) files
postmaster.opts A file recording the command-line options the server
was last started with
postmaster.pid A lock file recording the current server PID and shared
memory segment ID (not present after server shutdown)

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ray Stell 2008-03-20 16:07:12 Re: lock help
Previous Message veejar 2008-03-20 15:07:32 Re: DB Structure Recovery