| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Andrus Moor" <kobruleht2(at)hot(dot)ee> |
| Cc: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: index "pg_authid_rolname_index" is not a btree |
| Date: | 2009-08-19 17:20:31 |
| Message-ID: | 25282.1250702431@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Andrus Moor" <kobruleht2(at)hot(dot)ee> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christophe Pettus | 2009-08-19 17:27:50 | Re: Wich the best way to control the logic of a web application? |
| Previous Message | Karsten Hilbert | 2009-08-19 17:20:10 | Re: Unit conversion database (was: multiple paramters in aggregate function) |