pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Recovering 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