Обсуждение: pg_dumpall failed on dumpProcLangs()
-----BEGIN PGP SIGNED MESSAGE----- I was attempting to dump my database (6.4.2) in preparation for an upgrade to 6.5.1. I got the following error, both with and without the `-z'. Any suggestions are welcome.... 999 roland> pg_dumpall -v -z > ~/stuff/pgdump.dat - -- last builtin oid is 17152 - -- reading user-defined types - -- reading user-defined functions - -- reading user-defined aggregates - -- reading user-defined operators - -- reading user-defined tables - -- reading table inheritance information - -- finding the attribute names and types for each table - -- finding the attrs and types for table: 'addresses' - -- finding the attrs and types for table: 'contacts' - -- finding the attrs and types for table: 'dictionary' - -- finding DEFAULT expression for attr: '_rowid' - -- finding the attrs and types for table: 'ebulk' - -- finding DEFAULT expression for attr: '_rowid' - -- finding DEFAULT expression for attr: 'browref' - -- finding the attrs and types for table: 'eschema' - -- finding DEFAULT expression for attr: '_rowid' - -- finding the attrs and types for table: 'filters' - -- finding DEFAULT expression for attr: '_rowid' - -- finding the attrs and types for table: 'followups' - -- finding DEFAULT expression for attr: '_rowid' - -- finding DEFAULT expression for attr: 'f_sid' - -- finding the attrs and types for table: 'groups' - -- finding the attrs and types for table: 'master' - -- finding the attrs and types for table: 'members' - -- finding the attrs and types for table: 'people' - -- finding DEFAULT expression for attr: '_rowid' - -- finding the attrs and types for table: 'phones' - -- finding the attrs and types for table: 'policy' - -- finding DEFAULT expression for attr: 'pid' - -- finding the attrs and types for table: 'policy_grp' - -- finding DEFAULT expression for attr: '_rowid' - -- finding DEFAULT expression for attr: 'pid' - -- finding the attrs and types for table: 'policy_login' - -- finding DEFAULT expression for attr: '_rowid' - -- finding DEFAULT expression for attr: 'pid' - -- finding the attrs and types for table: 'preferences' - -- finding DEFAULT expression for attr: '_rowid' - -- finding the attrs and types for table: 'propdisp' - -- finding DEFAULT expression for attr: '_rowid' - -- finding the attrs and types for table: 'resources' - -- finding the attrs and types for table: 'slips' - -- finding DEFAULT expression for attr: 'sid' - -- finding DEFAULT expression for attr: 'spid' - -- finding the attrs and types for table: 'state' - -- finding DEFAULT expression for attr: '_rowid' - -- finding the attrs and types for table: 'statelist' - -- finding the attrs and types for table: 'status' - -- flagging inherited attributes in subtables - -- dumping out user-defined types - -- dumping out tables - -- dumping out user-defined procedural languages dumpProcLangs(): handler procedure for language plpgsql not found pg_dump failed on ksonline, exiting roland - -- PGP Key ID: 66 BC 3B CD Roland B. Roberts, PhD Custom Software Solutions roberts@panix.com 76-15 113th Street, Apt 3B rbroberts@acm.org Forest Hills, NY 11375 -----BEGIN PGP SIGNATURE----- Version: 2.6.3a Charset: noconv Comment: Processed by Mailcrypt 3.5.4, an Emacs/PGP interface iQCVAwUBN9Hr9uoW38lmvDvNAQFO/AQAjX+1cN7UaVLHtCn1RwEdl6TvQuHdVWtF /g2kd9ey/qts4GQ5ZQBjnuFZp+ZU8PxpyUiTkS63gbKqGhruXKVWps1N/E+ctinC ObAwMags+LgdGYVktDl18TjBzSB7hov7SKBDBvAITTOy8idto7ZldvnI7aP907x5 sZAKtzVuau8= =9/Wn -----END PGP SIGNATURE-----
Roland Roberts <roberts@panix.com> writes: > -----BEGIN PGP SIGNED MESSAGE----- > I was attempting to dump my database (6.4.2) in preparation for an > upgrade to 6.5.1. I got the following error, both with and without > the `-z'. Any suggestions are welcome.... > dumpProcLangs(): handler procedure for language plpgsql not found That's odd. You didn't do something silly like dropping the function definition for plpgsql_call_handler, did you? Anyway, I think you can get rid of the broken table entry by doing drop procedural language 'plpgsql'; but first you might want to see whether there are any functions that depend on it: select proname from pg_proc, pg_language pl where prolang = pl.oid and lanname = 'plpgsql'; If there are, you'll need to drop them too... regards, tom lane
-----BEGIN PGP SIGNED MESSAGE----- >>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes: Tom> Roland Roberts <roberts@panix.com> writes: >> dumpProcLangs(): handler procedure for language plpgsql not >> found Tom> That's odd. You didn't do something silly like dropping the Tom> function definition for plpgsql_call_handler, did you? I don't think so. When I originally installed 6.4.2, I did it from the source RPM. I then loaded the plpgsql language support manually from the suppplied script. Tom> Anyway, I think you can get rid of the broken table entry by Tom> doing drop procedural language 'plpgsql'; but first you might Tom> want to see whether there are any functions that depend on [...] This show not procedures; I remember defining some, but perhaps I dropped them after experimenting. Thanks! roland - -- PGP Key ID: 66 BC 3B CD Roland B. Roberts, PhD Custom Software Solutions roberts@panix.com 76-15 113th Street, Apt 3B rbroberts@acm.org Forest Hills, NY 11375 -----BEGIN PGP SIGNATURE----- Version: 2.6.3a Charset: noconv Comment: Processed by Mailcrypt 3.5.4, an Emacs/PGP interface iQCVAwUBN9MqwuoW38lmvDvNAQHonAQAue0yOg50NlS9vErxY8vkyvlfcLRE+ROH 8LtOu7wZzszINXsmniyJvi/rip0hG+sktZVLrGM7+gf5HjkkXd77M6SqjbHey6nN J4NDSlQsnXDQdFiluRQa8cJFEioQb7wyeIrnaOFm6CGalpb/hHns7e+GzUo4s/lJ EcV9N31tecc= =ICZX -----END PGP SIGNATURE-----