Message-ID: <e5f07e84-1d61-4da2-b3b9-918edbf87c6d@dalibo.com>
Date: Mon, 17 Nov 2025 11:16:20 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Redo CREATE DATABASE
To: pgsql-general@lists.postgresql.org
References: <MR1PPF8993717D761DDD789CE20C6D9203B9DC9A@MR1PPF8993717D7.FRAP264.PROD.OUTLOOK.COM>
Content-Language: fr
From: Guillaume Lelarge <guillaume.lelarge@dalibo.com>
Organization: Dalibo
In-Reply-To: <MR1PPF8993717D761DDD789CE20C6D9203B9DC9A@MR1PPF8993717D7.FRAP264.PROD.OUTLOOK.COM>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/e5f07e84-1d61-4da2-b3b9-918edbf87c6d%40dalibo.com>
Precedence: bulk

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