Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.400.131.1.6\))
Subject: Re: libc to libicu via pg_dump/pg_restore?
From: Paul Foerster <paul.foerster@gmail.com>
In-Reply-To: <f90acfff-8b6d-4ee3-814a-ebf44442ce04@dalibo.com>
Date: Thu, 6 Feb 2025 18:37:25 +0100
Cc: pgsql-general@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <12488E77-4D0F-46B1-B7C9-BFA1D61D6B62@gmail.com>
References: <B0DB872D-B2A0-4323-9EA8-A7FB4567ACCB@gmail.com>
 <2256966c-446f-4607-a47d-04b895b0747b@dalibo.com>
 <7A2A897E-AD8B-47F7-A29F-980D57425AD9@gmail.com>
 <f90acfff-8b6d-4ee3-814a-ebf44442ce04@dalibo.com>
To: Guillaume Lelarge <guillaume.lelarge@dalibo.com>
Archived-At: <https://www.postgresql.org/message-id/12488E77-4D0F-46B1-B7C9-BFA1D61D6B62%40gmail.com>
Precedence: bulk

Hi Guillaume,

> On 6 Feb 2025, at 15:51, Guillaume Lelarge =
<guillaume.lelarge@dalibo.com> wrote:
>=20
> You're right. Now I see the "create database" query in your previous =
email. I should have been more careful, sorry for the noise.

No problem.

> Well, the doc says that --disable-triggers is only relevant for =
data-only restore, which is not your use case. So you don't need it and =
it won't help you.

Yes, I found that out too. But it doesn't hurt. =F0=9F=A4=A3

> Me neither. But another comment. You create the database, so there =
should be no objects in it. Why do you use the -c, -C, and --if-exists =
options? Try without them. On a new database, you should only need:
>=20
> pg_restore -d mydb mydb.dump.gz

I need -C because I need ACLs to be recreated too. I tried with -C only, =
i.e. no -c but that doesn't work for some reason. The --if-exists is a =
script remnant of my past tries to suppress some messages. I'll try =
removing that as I rewrote my create database script which runs before =
importing.

Cheers,
Paul=