Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uQq0Z-0017gx-L7 for pgsql-general@arkaria.postgresql.org; Sun, 15 Jun 2025 16:14:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uQq0X-00DJt6-Lv for pgsql-general@arkaria.postgresql.org; Sun, 15 Jun 2025 16:14:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uQq0X-00DJsy-Ba for pgsql-general@lists.postgresql.org; Sun, 15 Jun 2025 16:14:57 +0000 Received: from fhigh-a1-smtp.messagingengine.com ([103.168.172.152]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uQq0V-002D3q-1u for pgsql-general@lists.postgresql.org; Sun, 15 Jun 2025 16:14:57 +0000 Received: from phl-compute-05.internal (phl-compute-05.phl.internal [10.202.2.45]) by mailfhigh.phl.internal (Postfix) with ESMTP id 5529B11401B4; Sun, 15 Jun 2025 12:14:54 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-05.internal (MEProxy); Sun, 15 Jun 2025 12:14:54 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1750004094; x=1750090494; bh=P4N0pwHTSvt3/4qiIikd3OucJB7sSIDDwJN6SDGUapI=; b= eyYgu9Z19P8TUP2LtjwCQn+2FKUuHTfEG9WSNazAFIa8xc8Ba//R7akQ6Ow/X4Ed mvTk2jscaDYUtjJkZbBmfcys4ALFiwW0uk2GFGN4bbOrFvq0SNsUNJL0JwEGesFt D4KXsFEYQlmGKO8dTE1AS4WlWHpUiOQoTVLctk+Oa4SXcKY480t9wpqvJcGQ91Nc lqrafRL5125GvXqLltm5KxdrTCHJxxtzSrNArgRpVyixAxijV9Y9f594T6z6bffo 61MZ2yTowkiZIGodUwB4KUbzVWIRdWgizkKpPV07RoITAOtlric2XBFdcARLzJH0 zkkzH2TivJ8JIsuNjPISXA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1750004094; x= 1750090494; bh=P4N0pwHTSvt3/4qiIikd3OucJB7sSIDDwJN6SDGUapI=; b=N j0h4ziVK7pVArnwcRGyy80P/jB9n9eqrS1mx+QGJmkSubgSq4PMq5Z95Ug3w6r5c fHLUe4DZMRb+kRTHtaGATaG3ZLlv1aHUt4Z+cAhRuNlORk5JMZI0P1183Y3JcUw3 g5dxAO55uxmvfVs0KOsgH475wCEf+bzK0lvmG1oJEUfqK0BEHkInQJBOTUnnrW5f Iqfxuswl4PNo9kp1AVxOp4es0C29dOIt0OomV0L6r+F0S1lsIbNP1+qZGraV1dAL 99YeSiHnh98fsNQmcM/kaFEXahf3SJd/c/56K8B24ibUXA9cfyByL0qZ4RY9PvqC zWO5Dm0dtAPG0frVIENlg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtddugddvgeduiecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpefkffggfgfuhffvvehfjggtgfesthejredttddv jeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvg hrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeejveeliedtvdehieeh veefkeffgeetledtgeevhfekieeiiefgjeevhfejjeduffenucffohhmrghinhepghhnuh drohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmpdhnsggprhgtphhtth hopeefpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehrrhhotghhsehtuhhtrghn ohhtrgdruggvpdhrtghpthhtohepthhglhesshhsshdrphhghhdrphgrrdhushdprhgtph htthhopehpghhsqhhlqdhgvghnvghrrghlsehlihhsthhsrdhpohhsthhgrhgvshhqlhdr ohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 15 Jun 2025 12:14:53 -0400 (EDT) Message-ID: <0187edee-2869-4858-9cdc-9dcdf636e18c@aklaver.com> Date: Sun, 15 Jun 2025 09:14:52 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pg_restore ERROR: permission denied to change default privileges From: Adrian Klaver To: Rachel Roch Cc: Tom Lane , Pgsql General References: <1407215.1749838987@sss.pgh.pa.us> <75443bc4-7366-46b8-b5f5-8b69ee437f02@aklaver.com> Content-Language: en-US In-Reply-To: <75443bc4-7366-46b8-b5f5-8b69ee437f02@aklaver.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 6/15/25 08:15, Adrian Klaver wrote: > On 6/15/25 01:06, Rachel Roch wrote: >> >> >> >> 14 Jun 2025, 16:21 by adrian.klaver@aklaver.com: >> >>> >>> Isn't fgrep -F redundant? As I understand it fgrep = grep -F >>> >> You have the wrong end of the stick. ;-) > > Don't think so, the -F is redundant. It is redundant for fgrep. > > Try grep -F then fgrep and then fgrep -F on the same file. > >> >> As per Grep 3.8 release notes >> (https://lists.gnu.org/archive/html/info-gnu/2022-09/msg00001.html): >> >> "The egrep and fgrep commands, which have been deprecated since >> release 2.5.3 (2007), now warn that they are obsolescent and should >> be replaced by grep -E and grep -F." >> > -- Adrian Klaver adrian.klaver@aklaver.com