| From: | "Tomas J Stehlik" <tomas(at)stehlik(dot)co(dot)uk> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Is it possible to recover the schema from the raw files? |
| Date: | 2016-04-24 16:12:19 |
| Message-ID: | 003901d19e44$142419d0$3c6c4d70$@stehlik.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello Karsten,
Thank you.
> Like replacing (some of) the pg_* containing raw files with
> those from an uncorrupted database (having been suggested
> earlier this year) which may work if the corrupted blocks in
> pg_* only affect data actually describing _that_ database
> rather than establishing relationships not unique to this
> database (say, encodings, default operators, ...). If those
> can be replaced and there is still corruption in some parts
> describing the local schema then it may work to apply
> zero_damaged_pages, pg_resetxlog, and similar tools in order
> to make some of the schema dumpable.
This is actually a very interesting idea.
Kind regards,
Tomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-04-24 16:13:34 | Re: Is it possible to recover the schema from the raw files? |
| Previous Message | David G. Johnston | 2016-04-24 16:10:42 | Is it possible to recover the schema from the raw files? |