Hi,
On 17/11/2025 10:59, COURTAULT Francois wrote:
> THALES GROUP LIMITED DISTRIBUTION to email recipients
>
>
> Hello everyone,
>
> 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 <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 ?
>
You can't retrieve the old options if they have been changed later. You
can find the current ones with text tools like pg_restore, pg_dumpall,
or graphical tools (such as pgAdmin).
Regards.
--
Guillaume Lelarge
Consultant
https://dalibo.com