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 cluster already 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 an additional 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-functions which 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 cluster already 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(dot)klaver(at)aklaver(dot)com