pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRecovering from numbered directories
2+ messages / 2 participants
[nested] [flat]
* Recovering from numbered directories
@ 2007-03-07 16:44 Bradley Kieser <brad@kieser.net>
0 siblings, 1 reply; 2+ messages in thread
From: Bradley Kieser @ 2007-03-07 16:44 UTC (permalink / raw)
To: pgsql-admin
Has anyone done this? In a fatal crash where the backup only recovered
the numbered directories (data dirs) of a PG installation (i.e. nothing
above the numbered directories), is it possible to reinstall the exact
same version of PG and recover the databases from just those numbered
directories?
Thanks,
Brad
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Recovering from numbered directories
@ 2007-03-07 20:21 Tom Lane <tgl@sss.pgh.pa.us>
parent: Bradley Kieser <brad@kieser.net>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2007-03-07 20:21 UTC (permalink / raw)
To: Bradley Kieser <brad@kieser.net>; +Cc: pgsql-admin
Bradley Kieser <brad@kieser.net> writes:
> Has anyone done this? In a fatal crash where the backup only recovered
> the numbered directories (data dirs) of a PG installation (i.e. nothing
> above the numbered directories), is it possible to reinstall the exact
> same version of PG and recover the databases from just those numbered
> directories?
If you haven't got pg_clog you're pretty much screwed :-(
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-03-07 20:21 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-07 16:44 Recovering from numbered directories Bradley Kieser <brad@kieser.net>
2007-03-07 20:21 ` Tom Lane <tgl@sss.pgh.pa.us>
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