pg_dump: WARNING: could not find operator

From: Ed Sabol <edwardjsabol(at)gmail(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: pg_dump: WARNING: could not find operator
Date: 2023-07-11 22:15:08
Message-ID: D4B58A89-B5F5-4B26-A5EE-1B6976FD0895@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello! I'm in the process of migrating some 10.23 database instances to 15.3, and I'm getting these warnings when doing a pg_dumpall on one of the servers:

pg_dump: WARNING: could not find operator with OID 2234078
pg_dump: WARNING: could not find operator with OID 2234199

Is this indicative of a problem that I should fix before running pg_upgrade? If so, how?

And how do I find out what these OIDs are and what's referencing them?

Thanks,
Ed

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2023-07-11 22:24:35 Re: pg_dump: WARNING: could not find operator
Previous Message M Sarwar 2023-07-10 23:12:12 Re: Slow perormance