pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedReading 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>
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:51 Alvaro Herrera <alvherre@commandprompt.com>
parent: veejar <veejar.net@gmail.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