BUG #9472: pg_dumpall fails with "unrecognized node type: 650" - Mailing list pgsql-bugs

From Wilfried.Weiss@nsg.com
Subject BUG #9472: pg_dumpall fails with "unrecognized node type: 650"
Date
Msg-id 20140307125347.1917.19496@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #9472: pg_dumpall fails with "unrecognized node type: 650"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      9472
Logged by:          Wilfried Weiss
Email address:      Wilfried.Weiss@nsg.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #9464: PANIC with 'failed to re-find shared lock object'
Next
From: dylan-pgsql@dylex.net
Date:
Subject: BUG #9457: replace materialized view?