Message-ID: <16611bea8a93082783eff714b9eb43e34d1ea68f.camel@cybertec.at>
Subject: Re: Redo CREATE DATABASE
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: COURTAULT Francois <francois.courtault@thalesgroup.com>, 
 "pgsql-general@postgresql.org"
	 <pgsql-general@postgresql.org>
Date: Mon, 17 Nov 2025 16:59:01 +0100
In-Reply-To: <MR1PPF8993717D761DDD789CE20C6D9203B9DC9A@MR1PPF8993717D7.FRAP264.PROD.OUTLOOK.COM>
References: 
	<MR1PPF8993717D761DDD789CE20C6D9203B9DC9A@MR1PPF8993717D7.FRAP264.PROD.OUTLOOK.COM>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/16611bea8a93082783eff714b9eb43e34d1ea68f.camel%40cybertec.at>
Precedence: bulk

On Mon, 2025-11-17 at 09:59 +0000, COURTAULT Francois wrote:
> I am looking to an old document where we (I was not there at that time) s=
etup a database.
> Unfortunately, I was not able to find the CREATE DATABASE instruction use=
d. It is not in any of our docs=E2=98=B9
> At https://www.postgresql.org/docs/17/sql-createdatabase.html we can see =
that a lot of options are available.
> =C2=A0
> Do you know=C2=A0 if it is possible to retrieve the options we have set w=
hen we created the database ?

What I recommend is a schema-only dump with the --create option:

  pg_dump --schema-only --create dbname

You will find CREATE DATABASE and perhaps ALTER DATABASE statements near th=
e top that you
can use to create a copy of the database.  There will also be GRANT stateme=
nts for the
database.

Yours,
Laurenz Albe