Re: pg_dump problems: [archiver (db)] query failed: ERROR: relation "pg_opfamily" does not exist

2019-09-11 Thread Erwin Moller
On 8/20/2019 5:11 PM, Adrian Klaver wrote: On 8/20/19 8:02 AM, Adrian Klaver wrote: On 8/20/19 7:37 AM, Erwin Moller wrote: That is a bummer. Since I have no idea how to safely install an older version of pg_dump alongside my current 10.10 install, I will wait for the patch. A quick

Re: pg_dump problems: [archiver (db)] query failed: ERROR: relation "pg_opfamily" does not exist

2019-08-20 Thread Erwin Moller
Op 8/20/2019 om 3:32 PM schreef Adrian Klaver: On 8/20/19 6:18 AM, Erwin Moller wrote: Op 8/20/2019 om 2:07 PM schreef Ian Barwick: On 8/20/19 7:12 PM, Erwin Moller wrote: Hi, While trying to move an old 8.1 Postgres install to a new server with postgres 10.10, I get an error, listed

Re: pg_dump problems: [archiver (db)] query failed: ERROR: relation "pg_opfamily" does not exist

2019-08-20 Thread Erwin Moller
Op 8/20/2019 om 2:07 PM schreef Ian Barwick: On 8/20/19 7:12 PM, Erwin Moller wrote: Hi, While trying to move an old 8.1 Postgres install to a new server with postgres 10.10, I get an error, listed hereunder: I am trying to get a mydump_x_x_x.sql file to use to reinstall on the target

pg_dump problems: [archiver (db)] query failed: ERROR: relation "pg_opfamily" does not exist

2019-08-20 Thread Erwin Moller
ERE 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 And no archive is created. Does any of you kind people have advice? I am sure this worked on postgres9. Regards, Erwin Moller