Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qJLdb-0008PQ-HN for pgsql-admin@arkaria.postgresql.org; Tue, 11 Jul 2023 22:15:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJLda-0001tO-63 for pgsql-admin@arkaria.postgresql.org; Tue, 11 Jul 2023 22:15:14 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qJLdZ-0001rm-OJ for pgsql-admin@lists.postgresql.org; Tue, 11 Jul 2023 22:15:13 +0000 Received: from mail-qv1-xf35.google.com ([2607:f8b0:4864:20::f35]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qJLdX-003L32-Ar for pgsql-admin@lists.postgresql.org; Tue, 11 Jul 2023 22:15:12 +0000 Received: by mail-qv1-xf35.google.com with SMTP id 6a1803df08f44-634a3682c25so46781076d6.3 for ; Tue, 11 Jul 2023 15:15:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1689113710; x=1691705710; h=to:message-id:subject:date:mime-version:content-transfer-encoding :from:from:to:cc:subject:date:message-id:reply-to; bh=iwfnQ51MJcEOf7B0BZRl7koGpfrawc1+oftjs61rL0g=; b=YQH4TLnAUcWtCoHJcdOcDGyyrGur8H/84O0+fFUfU3q8qfLi1qSHl68AldYdd9kerB 7Azb5CiWz01QHdjfVm3KkmViZGrzx1an36Q0TCZpJdosjRKBzKksJnzvAyGN5c4S4lCz erd3KwlBaaWqBMqk50x6r7DISNqbXuQdWq6/uM8AwaNjhW9ndJjmNs8afSlmCGG+QYDc RWQY8t1vE8Iq3SkykNEXQq/RoIPRNOgkeTUBDqsu6LcvAnT1fScMfZXzdSC1uSgXSXCX uSawwZpk22LQZUD+TiDmb4RKBb67j4PttvGUVDaXJeCTj3ogYZmJ8xnpE631nHWi64Nx iVLA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689113710; x=1691705710; h=to:message-id:subject:date:mime-version:content-transfer-encoding :from:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=iwfnQ51MJcEOf7B0BZRl7koGpfrawc1+oftjs61rL0g=; b=YBDK49nclJoReIe8jMC9uG3NZMBJKJN+5pHEQTk6EEAXGzZMsATxIploEd/F0M6Eeu snuU7rVDHGbr4omy2BQq7RfJf970u8CAXBx44/cBsrYg3OkmpeZn3N8WymBu19KjqynR tR+wKnHS3UAdPKqR/8ik2/PlJ2QKYB3WerA6mxubBd7u9DEpXYF5/bcSbD2i5t9Lw4Wo SMGxKh86/k7h/42v+IQt0u2MhLG1IEOPpcj3Z/MaJE6mpxVt9MhLux7Pokz3hzoq3av1 6M4zf+TpOuJqgcbg2RLyVnTt6RTXYqfJzqYwBeEoLoh5omuaDZkgJi3gRL4vT7AJmN3e JPww== X-Gm-Message-State: ABy/qLbpqyFxMUGEWdTNimI63cfayW/Wv9x6NdkMNiH/YrIGIT/YfNiW S15WM3tZ3VGrUJwrG/ZSHsmW6t5sW/o= X-Google-Smtp-Source: APBJJlHQMbt8OYRmBh9i5JjgQyCGEmb/jtB/paRpYj5v13XLd+HU1j5/pBjBBxHADpuZ1oJXkb+xHw== X-Received: by 2002:a0c:db90:0:b0:636:9570:74bb with SMTP id m16-20020a0cdb90000000b00636957074bbmr16566533qvk.57.1689113710008; Tue, 11 Jul 2023 15:15:10 -0700 (PDT) Received: from ?IPv6:2601:14b:4100:252f:4520:964c:2eec:dbd0? ([2601:14b:4100:252f:4520:964c:2eec:dbd0]) by smtp.gmail.com with ESMTPSA id x26-20020a0ca89a000000b00621268e14efsm1567993qva.55.2023.07.11.15.15.09 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Tue, 11 Jul 2023 15:15:09 -0700 (PDT) From: Ed Sabol Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.7\)) Date: Tue, 11 Jul 2023 18:15:08 -0400 Subject: pg_dump: WARNING: could not find operator Message-Id: To: "pgsql-admin@lists.postgresql.org" X-Mailer: Apple Mail (2.3445.9.7) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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