pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Reading information from crashed PGDATA
2+ messages / 2 participants
[nested] [flat]

* Reading information from crashed PGDATA
@ 2008-03-20 16:02 veejar <veejar.net@gmail.com>
  2008-03-20 16:51 ` Re: Reading information from crashed PGDATA Alvaro Herrera <alvherre@commandprompt.com>
  0 siblings, 1 reply; 2+ messages in thread

From: veejar @ 2008-03-20 16:02 UTC (permalink / raw)
  To: 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?



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Reading information from crashed PGDATA
  2008-03-20 16:02 Reading information from crashed PGDATA veejar <veejar.net@gmail.com>
@ 2008-03-20 16:51 ` Alvaro Herrera <alvherre@commandprompt.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Alvaro Herrera @ 2008-03-20 16:51 UTC (permalink / raw)
  To: veejar <veejar.net@gmail.com>; +Cc: 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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-03-20 16:51 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-20 16:02 Reading information from crashed PGDATA veejar <veejar.net@gmail.com>
2008-03-20 16:51 ` Alvaro Herrera <alvherre@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox