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
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' |