Feedback-ID: i76984098:Fastmail
Message-ID: <3e25830f-cc92-4d4c-b6bf-c3496835c84e@aklaver.com>
Date: Thu, 13 Feb 2025 13:30:43 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: libc to libicu via pg_dump/pg_restore?
To: Paul Foerster <paul.foerster@gmail.com>
Cc: pgsql-general list <pgsql-general@lists.postgresql.org>
References: <B0DB872D-B2A0-4323-9EA8-A7FB4567ACCB@gmail.com>
 <187f2c5d-f268-4596-bb63-c94790ae761d@aklaver.com>
 <D46171D1-80B9-4E81-BC26-D47319B90CE3@gmail.com>
 <99d51fe7-c6d2-4421-9456-07ed1f5703a2@aklaver.com>
 <5A9148A0-CF9C-4841-A9C0-D7E299AC4ADD@gmail.com>
 <0150a3d8-9276-4534-9847-8d3d7bba6e16@aklaver.com>
 <C7FEEB74-B8B2-4681-9961-432F68A2942D@gmail.com>
 <159fd473-e361-4b60-9d62-5cf617bc4be1@aklaver.com>
 <C3E9395C-5235-4E62-A678-BE04E6AF772F@gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <C3E9395C-5235-4E62-A678-BE04E6AF772F@gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/3e25830f-cc92-4d4c-b6bf-c3496835c84e%40aklaver.com>
Precedence: bulk

On 2/13/25 11:57, Paul Foerster wrote:
> Hi Adrian,
> 

> I'm not at work anymore and won't be until Monday (long weekend 🤣). So I don't have the exact case handy. However, I tried on my home database clusters (15.10 and 17.3). Seems, at least here at home, only using -C works. I don't know (yet) why it does not work at work.
> 
> Here's what I tried on my own clusters. Note the access privileges for "paul".
>

> 
> So, "paul" again has CTc after pg_restore. That's what does not work at work. I'll have to figure out what's wrong there.

1) Verify the GRANT is in the dump file.

2) Check the Postgres log manually to see if there is an error that is 
causing the GRANT to be skipped.

> 
> Cheers,
> Paul

-- 
Adrian Klaver
adrian.klaver@aklaver.com