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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qJLsG-0000jh-2j
	for pgsql-admin@arkaria.postgresql.org; Tue, 11 Jul 2023 22:30:24 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qJLsE-0000h4-TH
	for pgsql-admin@arkaria.postgresql.org; Tue, 11 Jul 2023 22:30:22 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <edwardjsabol@gmail.com>)
	id 1qJLsE-0000gu-Hj
	for pgsql-admin@lists.postgresql.org; Tue, 11 Jul 2023 22:30:22 +0000
Received: from mail-qt1-x830.google.com ([2607:f8b0:4864:20::830])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <edwardjsabol@gmail.com>)
	id 1qJLs7-003YM7-Q6
	for pgsql-admin@lists.postgresql.org; Tue, 11 Jul 2023 22:30:21 +0000
Received: by mail-qt1-x830.google.com with SMTP id
 d75a77b69052e-40355e76338so54594381cf.3
        for <pgsql-admin@lists.postgresql.org>;
 Tue, 11 Jul 2023 15:30:15 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20221208; t=1689114614; x=1691706614;
        h=to:references:message-id:content-transfer-encoding:date:in-reply-to
         :from:subject:mime-version:from:to:cc:subject:date:message-id
         :reply-to;
        bh=dNMWi1K10AH86VVJmBqZvN5ESio4xxW2x0EU1T0om9U=;
        b=NMU8+WxCI/RatRkUhuimNgHVc+gZloJVeJnDRyRI06CWK25p4mo2uWOEny/noIUWoJ
         AxQlZpfBOxW5kfWfXrVgrFPlH9fpSpktvQdtulwsIjigVAZ/Ve+EZ5Qt/Cfoo+laE2cL
         /Tqi3pOSt9EKsIC4y1BGHccJ01uQUf4+ngwksPcSBeJ830wNLFEfOhNTX6kUIKQJ4BYT
         8/WN3K3dj12SdWk9tdbtLeHMTp/iS8CnzAx9P1hxAUOsr9O9jUb1tUhdWyG6l+pYfsSz
         aIfipgUAeqajrgC1qTzPx9ZW9Ky2fOjusTZFit16F2uzvFJAHvRO/YTC1twbjaeF0Yh1
         QsbQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20221208; t=1689114614; x=1691706614;
        h=to:references:message-id:content-transfer-encoding:date:in-reply-to
         :from:subject:mime-version:x-gm-message-state:from:to:cc:subject
         :date:message-id:reply-to;
        bh=dNMWi1K10AH86VVJmBqZvN5ESio4xxW2x0EU1T0om9U=;
        b=doe3UqQkiRujb61GS+6/Q3751oUzPUWJOtbYoTnWn8TLdNi7DlRjAEfrwGuB1O+cYS
         Xf5v4hwoAfDbYq0W+uNBh7/caZ0G0JHwQArSwzXMWLkVpgGqDuV2uJN4CLJvWkKP+aqW
         Zqwov5TqV3Y2wRJcAxTYmyDP+q17dbvofAbThzBGk5yS3pRDhiIsZt6ZjMWH65eSaXUA
         uySwwrJfWumZctdIBVhirrzPmJHXmgCLJQgAYeeOTRxpku4m++ke5R/f+5v0Xa1HFvks
         MTmM9gvJbP1d3+XpGNAiOonmgLgOyZwwTLb7+lpvpJ8DlOqikmZzwp+4Zib0NB/WNtXB
         K70Q==
X-Gm-Message-State: ABy/qLai0NtO7tAw+/ki4PQ1RL3ypkt4ftOOFtL18ATtbMn7GRpcA8BE
	OO3B+PvtVAQ6dxyV6vb8sKEVzWn0LtE=
X-Google-Smtp-Source: 
 APBJJlHFbBS8w06OS1W+Aiv/Wfj6kiguTSz3v26xgX199wm/bTkmI0fx1Wx1sGzvjVODoXNLkonbmA==
X-Received: by 2002:a05:622a:d1:b0:3fd:e37c:edea with SMTP id
 p17-20020a05622a00d100b003fde37cedeamr24176458qtw.45.1689114613773;
        Tue, 11 Jul 2023 15:30:13 -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
 c6-20020ac87d86000000b0040378535dccsm1572864qtd.43.2023.07.11.15.30.13
        (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128);
        Tue, 11 Jul 2023 15:30:13 -0700 (PDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.7\))
Subject: Re: pg_dump: WARNING: could not find operator
From: Ed Sabol <edwardjsabol@gmail.com>
In-Reply-To: <2563738.1689114275@sss.pgh.pa.us>
Date: Tue, 11 Jul 2023 18:30:12 -0400
Content-Transfer-Encoding: quoted-printable
Message-Id: <E773BD1D-6B16-463E-96E5-17484B9626EC@gmail.com>
References: <D4B58A89-B5F5-4B26-A5EE-1B6976FD0895@gmail.com>
 <2563738.1689114275@sss.pgh.pa.us>
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
X-Mailer: Apple Mail (2.3445.9.7)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/E773BD1D-6B16-463E-96E5-17484B9626EC%40gmail.com>
Precedence: bulk

On Jul 11, 2023, at 6:24 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> While you could clean it up manually, pg_dump
> is just going to omit those clauses from its output, so there's no
> real need to do anything if that outcome is sufficient.

I'm mainly concerned about the pg_upgrade going smoothly. I'd like to =
minimize downtime as much as possible. I was planning to use "pg_upgrade =
--link", if it matters.