Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tmc06-0084P5-56 for pgsql-general@arkaria.postgresql.org; Mon, 24 Feb 2025 17:12:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tmc05-005N2d-BM for pgsql-general@arkaria.postgresql.org; Mon, 24 Feb 2025 17:12:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tmc04-005N2U-2m for pgsql-general@lists.postgresql.org; Mon, 24 Feb 2025 17:12:13 +0000 Received: from fout-a6-smtp.messagingengine.com ([103.168.172.149]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tmc00-000Vkx-32 for pgsql-general@lists.postgresql.org; Mon, 24 Feb 2025 17:12:11 +0000 Received: from phl-compute-10.internal (phl-compute-10.phl.internal [10.202.2.50]) by mailfout.phl.internal (Postfix) with ESMTP id 286B81380A1E; Mon, 24 Feb 2025 12:12:09 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-10.internal (MEProxy); Mon, 24 Feb 2025 12:12:09 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1740417129; x=1740503529; bh=m4rWVBNDXGk9dLThwPhk4E8sUC1gaa/S0Mqa1w48c7Q=; b= M7OysyLNgZfAo+uGyM1qQX0ndr09SMzfr3zb7JuZKEnDbnGNYn43gL+dMt3iBtNr tpLOAWBquKVMz1iU55Pl8oZv0Ztc9rWcT1qLfzWvm+f5juLJp40eykzW7qIfpK/h 75UVZzYW60yRRd5gl9Km/MV7a2ehU2idEIZMiyLgTfWDkUFstdjp1eeXlwlyxYw3 DRSMC8MgnDF/J3BeJmnlnFhRc5ZRY/jf7JqwBQAxYljPbGVoM+gS8J7JchhaLKZu VrGDhbcCG4R+l1I7qPxLNKB0mVOJQ2pm5ecmTZhU/wuVkut5yjcVv/BS3gSJ/4Rd C7b9nP2gphYnGeL7j8gJGA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1740417129; x=1740503529; bh=m 4rWVBNDXGk9dLThwPhk4E8sUC1gaa/S0Mqa1w48c7Q=; b=L466avLgPcTOxY6CQ zYGVMvJ4dUx/H+TZ8OtklOTCbGUiplWr+ZHZGZiNTu2IvWdro4Fsub+BujlrWgDS iw8e4gQvr0z8RBTRsBZ2t78vpMXvK4FiVF4ALu+5b3a2q8XCjT9IsHxEjw9Ny3Kk sfA8kWs9+3AUnbL+FGDDsFnVhgPVR/OYndmfdTLLXp4b+FZsN7WW0GJJ/dtKD5TH pR2smwdQjuiWIBt4+FI1Mb7b90rLZRmF/XWS/56IeSYnYx+MHUjgM+eh0ISzo12Q E9QaIj7pBOVo1OFOhhgJ6oqcVbo8hkCaW8QEVFUVt6I2EX46o77dUqRjonog+9Lm 0wzDg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdejleefhecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpefkffggfgfuvfhfhfgjtgfgsehtkeertddtvdej necuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrh esrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepgfekffdtfeehhfejgfev vdevueefiedtvedthfefvdeiffejkeefudelgffgkefgnecuffhomhgrihhnpeguvggsih grnhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhr ohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmpdhnsggprhgtph htthhopedvpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegrnhgurhgvrghsrdhs tghhmhhiugessggurdhsohdrtghhpdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlh eslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 24 Feb 2025 12:12:07 -0500 (EST) Message-ID: <3156b063-bfbd-4b0f-a8f6-aadd104fe215@aklaver.com> Date: Mon, 24 Feb 2025 09:12:07 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: AW: AW: PGDG PostgreSQL Debian package: Question on conditions for creation of new cluster To: Schmid Andreas , "pgsql-general@lists.postgresql.org" References: <30722d87e4c642d0bc6bf4048d250c28@bd.so.ch> <202502191518.364eeafyj7u4@alvherre.pgsql> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/24/25 05:57, Schmid Andreas wrote: >> -----Ursprüngliche Nachricht----- >> I think that lives here: >> https://salsa.debian.org/postgresql/postgresql-common > > Yes, thanks for the hint. The commit which apparently introduced the change is https://salsa.debian.org/postgresql/postgresql-common/-/commit/d9139f7777a42a39b5b6fabbffc9f020fad4dce5: "debian/maintscripts-functions: Create "main" cluster only when no other clusters exist yet." > > Maybe I'm going to ask on the pgsql-pkg-debian mailing list for more details about it, as proposed by Laurenz. > > @Adrian, please note that I'm not the one who asked on Stack Overflow, so I'm not cross posting over here. And I definitely am doing an "alongside" installation of two major versions: On my server is installed v16, and now I'm adding v17, as described in my first message. So that is what the postgresql-common new packages contained. I have not used them for installing a new server version since the changes. Yes they indeed do not create a new cluster when any other Postgres clusters of any flavor exist. You have to resort to manually doing: sudo pg_createcluster 17 main --start It would have been nice if the packagers had mentioned that change somewhere else then as comments in the source. > > Thanks again to everybody for your help. > > Andy -- Adrian Klaver adrian.klaver@aklaver.com