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 1qJndX-0001hu-3c for pgsql-admin@arkaria.postgresql.org; Thu, 13 Jul 2023 04:09:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJndV-0000AB-Oe for pgsql-admin@arkaria.postgresql.org; Thu, 13 Jul 2023 04:09:01 +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 ) id 1qJndV-0000A1-Cz for pgsql-admin@lists.postgresql.org; Thu, 13 Jul 2023 04:09:01 +0000 Received: from mail-qv1-xf34.google.com ([2607:f8b0:4864:20::f34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qJndP-0009Z6-1C for pgsql-admin@lists.postgresql.org; Thu, 13 Jul 2023 04:09:00 +0000 Received: by mail-qv1-xf34.google.com with SMTP id 6a1803df08f44-635e8536ed6so1591676d6.0 for ; Wed, 12 Jul 2023 21:08:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1689221333; x=1691813333; h=date:to:in-reply-to:references:message-id:subject:mime-version:from :content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=AEjizIpHcYibiuHaCqabKdbEEweXaVi/jMLqUc28Kdc=; b=Hubgj/cqsaTQ6pyR7cxH6O90luju4Ktbtfv8uTlAwYhq1G9bAWRbWgcL4tRSZUskHy iSBndg+V8RfMGmtj7eJN3vjMIZFSo2vP2gXDVp/zJNC89WDzWtfZvKo+dvv9bI4Wxiw0 iePP/9h3x1FeEtCeanzpeC6WO+oxUfZhVva2zUe7+uHIKDJHWenX/kBfMPWpBCxny1uq FASdlD6disNXh6z5uNN+ndx11DB17CJWJq0JTRS5HtNCKkBW9wu+6nzymGk+cdNi4/rJ nN8+3RhhoxQylSbfzcTYtSw6lVMzExOq2XZuOp7SpiyLxye1ApyWGcJhBTFExDx7aM+I 65cw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689221333; x=1691813333; h=date:to:in-reply-to:references:message-id:subject:mime-version:from :content-transfer-encoding:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=AEjizIpHcYibiuHaCqabKdbEEweXaVi/jMLqUc28Kdc=; b=RB/7hy/LmXPaX7Cy3I/bMFDxSmZWXH/L79bQJmXMCiZYG0LgL/PbMs4hhHgcRF3vil sqHFgNaVhpo4CC10rqq4+MWWxJCqss8ynrhDLvq84qp7Y/rGvYEPNwXIuO2buATwU0Dc FAUcFQav7S3wDGpThGhmS8Qizo9WPOvBres7lDWZ4Y7rjfA5Sq8tbQRz5XUJPet9GYTT m9tz+kerJJDLSjlKmHGCWAHkp9d7L+h3w8/pX5FRAoSq7DXpiXkSc1wyGw2UH9wurGkA CjLiKV0o2eD2xArwVl6g+96lPdpAbkVCaeLCl/z8l/PeQ94Qx4SiU+wWQrVexmHSFJDT GfZg== X-Gm-Message-State: ABy/qLY+nnnNz9InpbwvskTqByK05HTnSvXSkovCpQShUHzGGOqMGzu2 jbfyybmqV+bXtGxaY8IBbC+QJ/Z2mo0= X-Google-Smtp-Source: APBJJlEG9fHn+i457KHEuwQdUal9XdqYL0dAG2WIKoCV7Q5ZV8uaZX0Yk3pD/0CZVZ0k4iRGY213KQ== X-Received: by 2002:a0c:e34c:0:b0:635:4113:baed with SMTP id a12-20020a0ce34c000000b006354113baedmr352392qvm.33.1689221333586; Wed, 12 Jul 2023 21:08:53 -0700 (PDT) Received: from smtpclient.apple ([2601:14b:4100:252f:98ef:ac0b:1e72:9e54]) by smtp.gmail.com with ESMTPSA id u14-20020a0c8dce000000b00632191a70a2sm2721410qvb.103.2023.07.12.21.08.53 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 12 Jul 2023 21:08:53 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable From: "Edward J. Sabol" Mime-Version: 1.0 (1.0) Subject: Re: pg_dump: WARNING: could not find operator Message-Id: References: <312a596e-034d-99d1-2f99-00c8b863eb83@gmail.com> In-Reply-To: <312a596e-034d-99d1-2f99-00c8b863eb83@gmail.com> To: pgsql-admin@lists.postgresql.org Date: Thu, 13 Jul 2023 00:08:42 -0400 X-Mailer: iPad Mail (20F75) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Jul 12, 2023, at 11:08 PM, Ron wrote: > Will they automagically disappear when you restore the pg_dump? Yeah, that's what Tom Lane said, but I'm not planning to restore the pg_dump= (unless something catastrophic happens). I'm planning to use "pg_upgrade --= link". Thanks, Ed