BUG #9472: pg_dumpall fails with "unrecognized node type: 650"

From: Wilfried(dot)Weiss(at)nsg(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #9472: pg_dumpall fails with "unrecognized node type: 650"
Date: 2014-03-07 12:53:47
Message-ID: 20140307125347.1917.19496@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 9472
Logged by: Wilfried Weiss
Email address: Wilfried(dot)Weiss(at)nsg(dot)com
PostgreSQL version: 9.2.2
Operating system: AIX 6.1
Description:

Hi,

when trying to run pg_dumpall it fails with the above mentioned error.

The last lines of the output looks like this:

QUOTE START ------

--
-- Database creation
--

pg_dumpall: query failed: ERROR: unrecognized node type: 650
pg_dumpall: query was: SELECT datname, coalesce(rolname, (select rolname
from pg_authid where oid=(select datdba from pg_database where
datname='template0'))), pg_encoding_to_char(d.encoding), datcollate,
datctype, datfrozenxid, datistemplate, datacl, datconnlimit, (SELECT spcname
FROM pg_tablespace t WHERE t.oid = d.dattablespace) AS dattablespace FROM
pg_database d LEFT JOIN pg_authid u ON (datdba = u.oid) WHERE datallowconn
ORDER BY 1

QUOTE END ---

What can I do to be able to unload the data again?

Regards Wilfried

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2014-03-07 15:24:30 Re: BUG #9457: replace materialized view?
Previous Message Tom Lane 2014-03-07 04:47:05 Re: BUG #9464: PANIC with 'failed to re-find shared lock object'