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 1tgR52-00Aedn-OJ for pgsql-general@arkaria.postgresql.org; Fri, 07 Feb 2025 16:19:49 +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 1tgR51-002p24-Np for pgsql-general@arkaria.postgresql.org; Fri, 07 Feb 2025 16:19:47 +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 1tgR51-002p1w-DV for pgsql-general@lists.postgresql.org; Fri, 07 Feb 2025 16:19:47 +0000 Received: from fhigh-b5-smtp.messagingengine.com ([202.12.124.156]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tgR4y-004OPV-2B for pgsql-general@lists.postgresql.org; Fri, 07 Feb 2025 16:19:47 +0000 Received: from phl-compute-12.internal (phl-compute-12.phl.internal [10.202.2.52]) by mailfhigh.stl.internal (Postfix) with ESMTP id 0F20F25401CA; Fri, 7 Feb 2025 11:19:44 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-12.internal (MEProxy); Fri, 07 Feb 2025 11:19:44 -0500 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=fm2; t=1738945183; x=1739031583; bh=rAmKCHMa7kWQC16HfV9wJYSP4KyZ5jwUz/i1q5FSnwU=; b= Gz5Y0QhxTLpIuuFwEQBAUmYViwAXSX1I9i7NXv5KG0O0q67/x4jkLO0RA+GkU60x HLavixvI7lzNwkIzHx+FUTaOAAv96a7YhNo6Ig0ADUnT0Mo9oy32Wm9Kl0Duizv1 nOJFQqloa9dcNXa3SJpvX8bXUtZhK59UeXUykX9TjK5imx5o1f+IaeQEaFU05sGd zuZK1fqzAPA1fvcxuwrUzPX8PTEFBiotcqsIbfOy3VGxDi4pJ6DHfnyWJf6TwKCp fqin1er9VLLXK9F71izRnCVG0mL6DbiKmdB8TO8UI0SnAhXFVrsya1EWWRzYD2fo gcpuWWO9KTdiY9JIscr3ZQ== 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=fm3; t=1738945183; x= 1739031583; bh=rAmKCHMa7kWQC16HfV9wJYSP4KyZ5jwUz/i1q5FSnwU=; b=i /6pkjMMRi+WJuzwZZIrDxRr3ktounzeElX04jkpKKkBhGL890JgNNB0Yqd35nnge b+ed+Rh7jOpPnSTcsV6tjp/Z3ZVmx6kCbmSzTKsE8TgTjpG98RqYnFFc1QcAQ1SC Ie9EniC+mgVnxqBemWMzHfiVa17BeTjH08dVUZ/0egyvV8GVBDwig4+1puStoUxR p/bL62856a8N0leuZxjovQt+UHSAz/ZXsWyvM9KlCYaOYIqUFcvDsBLYMqNUGrvh /INtkUk3pnuejvUPfGLuzwPE1yTYFRaIWNkSxPbw5Agxxql1hwhCnLJVQWECnkwW QUFxVR5IXBLXvIejq3T6g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddvleejgecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpefkffggfgfuvfevfhfhjggtgfesthejredttddv jeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvg hrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpefhveeihfevlefffedt hedukeevfefhfedtgeeifeevteffgfefhedtffetudettdenucevlhhushhtvghrufhiii gvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegr khhlrghvvghrrdgtohhmpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuth dprhgtphhtthhopehprghulhdrfhhovghrshhtvghrsehgmhgrihhlrdgtohhmpdhrtghp thhtohepphhgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrd horhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 7 Feb 2025 11:19:43 -0500 (EST) Message-ID: <99d51fe7-c6d2-4421-9456-07ed1f5703a2@aklaver.com> Date: Fri, 7 Feb 2025 08:19:42 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: libc to libicu via pg_dump/pg_restore? To: Paul Foerster Cc: pgsql-general list References: <187f2c5d-f268-4596-bb63-c94790ae761d@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: 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 2/6/25 22:32, Paul Foerster wrote: > Hi Adrian, > >> On 6 Feb 2025, at 17:31, Adrian Klaver wrote: >> >> 1) Log into postgres database and do: >> >> a) DROP DATABASE mydb; >> b) CREATE DATABASE mydb ; >> >> 2) pg_restore -d mydb mydb.dump.gz > > With create database being "template template0", this is what my script does. But I need the -cC options for pg_restore to get ACLs back. Leaving out either one of them will not get me the ACLs back. That does not make sense. Are there ACLs(privileges) in the database at all? What is the pg_dump command you are running? > Cheers > Paul > -- Adrian Klaver adrian.klaver@aklaver.com