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) setup a database.
> Unfortunately, I was not able to find the CREATE DATABASE instruction used. It is not in any of our docs☹
> At https://www.postgresql.org/docs/17/sql-createdatabase.html we can see that a lot of options are available.
>
> Do you know if it is possible to retrieve the options we have set when 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 the top that you
can use to create a copy of the database. There will also be GRANT statements for the
database.
Yours,
Laurenz Albe
