Search Postgresql Archives

Re: Is it possible to recover the schema from the raw files?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello Karsten,

Thank you.

> I believe Adrian wanted to know whether you attempted a
 > schema or complete dump *after* the fact, like what he
 > suggested a mail ago or so.
 > 
 > In case the FS corruption "only" affects raw files related to
 > user data (as opposed to also affecting data in pg_* tables)
 > a schema-only dump does have a slight chance of success.
 > 
 > That chance might potentially be increased by judicious use
 > of zero_damaged_pages and related low-level techniques the
 > prerequisite conditions of which people seem to have been
 > trying to inquire about upthread.
 > 
 > > The question potentially targets someone who could tell 
 > > whether something like this is possible.
 > 
 > "possible" depends no the exact circumstances, the details of
 > which people have been trying to tease out.

All this relevant information has already been supplied previously.

Kind regards,

Tomas



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux