Re: AW: PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster

On 2/19/25 05:22, Schmid Andreas wrote:
>> -----Ursprüngliche Nachricht-----

> 
> Well, according to the last comment below the Stack Overflow question, it was about installing 17.3 with a v14
clusteralready present.
 
> Anyways, I now tried on an Ubuntu 24.04 machine as well, and installing 17.3 alone created a cluster.
> Cleaned up the machine, then installed 15.11, which created a cluster. Installed 16.7 alongside, which did not create
anadditional cluster. So it's probably not a 17.3 problem.
 
> Same outcome on Ubuntu 20.04.

Which was explained to you in the comments to the SO question. There is 
no 'Installed 16.7 alongside ...'. As was explained this is just minor 
version upgrade to Postgres 16 and will only upgrade the binaries and 
associated libraries for the major version 16.

> 
> Maybe there generally is no cluster created if there is one present already. I now checked
/usr/share/postgresql-common/maintscripts-functionswhich is installed by the postgresql-common_273.pgdg24.04+1_all.deb
package.This script contains the create_main_cluster() function, which according to a comment "skips if any other
clusteralready exists".
 
> So could it be that this function has been updated recently? Can you point me to the repo where this script is
maintained?

Do man pg_createcluster.


-- 
Adrian Klaver
adrian.klaver@aklaver.com