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 1uQiO5-00GM33-MX for pgsql-general@arkaria.postgresql.org; Sun, 15 Jun 2025 08:06:45 +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 1uQiO3-00BxTv-J0 for pgsql-general@arkaria.postgresql.org; Sun, 15 Jun 2025 08:06:44 +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 1uQiO3-00BxTn-8M for pgsql-general@lists.postgresql.org; Sun, 15 Jun 2025 08:06:43 +0000 Received: from mail.w13.tutanota.de ([185.205.69.213]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uQiO1-00293z-1Y for pgsql-general@lists.postgresql.org; Sun, 15 Jun 2025 08:06:43 +0000 Received: from tutadb.w10.tutanota.de (w10.api.tuta.com [IPv6:fd:ac::d:10]) by mail.w13.tutanota.de (Postfix) with ESMTP id 79B159660E82 for ; Sun, 15 Jun 2025 10:06:40 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; t=1749974800; s=s1; d=tutanota.de; h=From:From:To:To:Subject:Subject:Content-Description:Content-ID:Content-Type:Content-Type:Content-Transfer-Encoding:Content-Transfer-Encoding:Cc:Cc:Date:Date:In-Reply-To:In-Reply-To:MIME-Version:MIME-Version:Message-ID:Message-ID:Reply-To:References:References:Sender; bh=CDPyThYYCxF97n0LC/vWxewpQnjLO7SET5+nhyQUhJ0=; b=IOLnWDediotlTcTzZXdevn6vUjmPnqbip1i4si5lHselWVC5EZQS2R6vto297+vS wPbIPSLZHONGaTiLbzFIn+uHT9GCKEvCXk+8MCe3FB6AV3X92N6MhnDSIZ8FdywcXcM d4Q3xRg1pkbReO2sDDUInHghMObREMYT2UuP9eW3tXHeh4oQoEI/5+9/dNrhxNt6FMS TBLVVEkPluoTQWHUwd8KP//K+MkKU5TqW8fewQ7SBBWfmmp6Uk64Hof/mrviSOwcoNH drje6/mL+IV7rav7R3QYPFNNgZcCEEuE897INgrsAMuZciPzLc5wGRCm4PKuaR+8Tre 9FiBKC1O8g== Date: Sun, 15 Jun 2025 10:06:40 +0200 (CEST) From: Rachel Roch To: Adrian Klaver Cc: Tom Lane , Pgsql General Message-ID: In-Reply-To: References: <1407215.1749838987@sss.pgh.pa.us> Subject: Re: pg_restore ERROR: permission denied to change default privileges MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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. ;-) 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."