Re: Redo CREATE DATABASE

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