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.96) (envelope-from ) id 1wKzNb-001S8c-32 for pgsql-hackers@arkaria.postgresql.org; Thu, 07 May 2026 14:07:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wKzNa-004Spc-0e for pgsql-hackers@arkaria.postgresql.org; Thu, 07 May 2026 14:07:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wKzNZ-004SpU-2w for pgsql-hackers@lists.postgresql.org; Thu, 07 May 2026 14:07:05 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wKzNX-000000010uz-3Miv for pgsql-hackers@lists.postgresql.org; Thu, 07 May 2026 14:07:05 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.18.1/8.18.1) with ESMTP id 647E70Hh857895; Thu, 7 May 2026 10:07:00 -0400 From: Tom Lane To: Andrew Dunstan cc: Isaac Morland , "David G. Johnston" , Dutch Glory , "pgsql-hackers@lists.postgresql.org" Subject: Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database In-reply-to: References: <489875059.7072445.1778142833311.ref@mail.yahoo.com> <489875059.7072445.1778142833311@mail.yahoo.com> Comments: In-reply-to Andrew Dunstan message dated "Thu, 07 May 2026 09:35:29 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <857893.1778162820.1@sss.pgh.pa.us> Content-Transfer-Encoding: 8bit Date: Thu, 07 May 2026 10:07:00 -0400 Message-ID: <857894.1778162820@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Andrew Dunstan writes: > On 2026-05-07 Th 8:44 AM, Isaac Morland wrote: >> No, make/ninja install should not create a database. That is >> outside its appropriate responsibilities. Installing from source >> stops once the binaries are installed.  Using the installed >> product is up to the user. >> >> Also there are lots of reasons to install Postgres without creating an >> instance. This is actually one of the things I don't like about the >> Ubuntu installer, which defaults to creating an instance (although >> this behaviour can be suppressed by creating a config file with an >> appropriate directive first). > +1 It's annoyed me many times. Yeah. When I was with Red Hat, there was a pretty nearly ironclad rule that simply installing a package shouldn't cause it to do anything. The argument for this was that you should be able to select fairly large package sets at system install time and not worry about half-configured servers starting up on you. Exceptions were made for services that were (a) essential to system functionality and (b) having default configurations that were both secure and widely useful as-is. It's impossible to argue that Postgres meets either condition. regards, tom lane