On Mon, Jul 11, 2011 at 6:25 PM, Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> wrote: > On 12/07/11 08:12, Matthew Byrne wrote: >> I have a large database full of irreplaceable data, and due to a >> ridiculous happenstance I accidentally executed this code (as a superuser, >> of course): >> >> DELETE FROM pg_catalog.pg_type; >> >> Now the database is *seriously* unhappy - every SQL command returns an >> error message. How do I get at my data? > > Oh, once you've copied your database you should stop the postmaster and > not start it again without further advice/instructions. The data in > pg_type may not have been vacuumed or overwritten yet if you haven't > been messing about trying to fix it before asking for help. > Second the suggestion of copying everything. Of course with autovacuum the chances that things have been vacuumed is not 0 and may be fairly high depending on configuration. In addition to those suggestions, the obvious question is: Do you have backups? What do they contain? How old are they? What sort of backups do you have? Best Wishes, Chris Travers -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
