pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #15955: changes in pg_dump from 11.4 to 11.5
2+ messages / 2 participants
[nested] [flat]
* BUG #15955: changes in pg_dump from 11.4 to 11.5
@ 2019-08-13 19:07 PG Bug reporting form <noreply@postgresql.org>
2019-08-13 19:27 ` Re: BUG #15955: changes in pg_dump from 11.4 to 11.5 Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2019-08-13 19:07 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: cybersly7@hotmail.com
The following bug has been logged on the website:
Bug reference: 15955
Logged by: sly
Email address: cybersly7@hotmail.com
PostgreSQL version: 11.5
Operating system: Linux
Description:
currently in the process of migrating a 8.1.23 to 11.x ( I know its
unsupported, long story)
these changes
(https://fossies.org/diffs/postgresql/11.4_vs_11.5/src/bin/pg_dump/pg_dump.c-diff.html)
now make it impossible to dump the old database from the new server.
ERROR:
pg_dump: reading dependency data
pg_dump: [archiver (db)] query failed: ERROR: relation "pg_opfamily" does
not exist
pg_dump: [archiver (db)] query was: SELECT classid, objid, refclassid,
refobjid, deptype FROM pg_depend WHERE deptype != 'p' AND deptype != 'e'
UNION ALL
SELECT 'pg_opfamily'::regclass AS classid, amopfamily AS objid, refclassid,
refobjid, deptype FROM pg_depend d, pg_amop o WHERE deptype NOT IN ('p',
'e', 'i') AND classid = 'pg_amop'::regclass AND objid = o.oid AND NOT
(refclassid = 'pg_opfamily'::regclass AND amopfamily = refobjid)
UNION ALL
SELECT 'pg_opfamily'::regclass AS classid, amprocfamily AS objid,
refclassid, refobjid, deptype FROM pg_depend d, pg_amproc p WHERE deptype
NOT IN ('p', 'e', 'i') AND classid = 'pg_amproc'::regclass AND objid = p.oid
AND NOT (refclassid = 'pg_opfamily'::regclass AND amprocfamily = refobjid)
ORDER BY 1,2
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #15955: changes in pg_dump from 11.4 to 11.5
2019-08-13 19:07 BUG #15955: changes in pg_dump from 11.4 to 11.5 PG Bug reporting form <noreply@postgresql.org>
@ 2019-08-13 19:27 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2019-08-13 19:27 UTC (permalink / raw)
To: cybersly7@hotmail.com; +Cc: pgsql-bugs@lists.postgresql.org
PG Bug reporting form <noreply@postgresql.org> writes:
> currently in the process of migrating a 8.1.23 to 11.x ( I know its
> unsupported, long story)
> these changes
> (https://fossies.org/diffs/postgresql/11.4_vs_11.5/src/bin/pg_dump/pg_dump.c-diff.html)
> now make it impossible to dump the old database from the new server.
Hmm, yeah, somebody (probably me) was sloppy there. Will look into it,
thanks for the report!
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-08-13 19:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-08-13 19:07 BUG #15955: changes in pg_dump from 11.4 to 11.5 PG Bug reporting form <noreply@postgresql.org>
2019-08-13 19:27 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox