"Andrus Moor" <kobruleht2@xxxxxx> writes: > pg_amop in mydb contains 5 rows. > pg_amop in template1 database contains large number of rows. > mydb does not contain user-defined operators. > How to repair pg_amop in mydb ? Well, you could try copying the physical file for pg_amop from template1 to mydb (and then reindexing it again). I am not holding out a lot of hope though. I think you're most likely going to run into a dead end, unfixable problem before you get any data out. > Most of backup size contains few big tables which are not required to > recover. Maybe you should forget about pg_dump and just see if you can COPY the tables you care about. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
