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. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
