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 1wKyt6-001RoI-1d for pgsql-hackers@arkaria.postgresql.org; Thu, 07 May 2026 13:35:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wKyt4-004L9J-1g for pgsql-hackers@arkaria.postgresql.org; Thu, 07 May 2026 13:35:34 +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.96) (envelope-from ) id 1wKyt4-004L9B-0K for pgsql-hackers@lists.postgresql.org; Thu, 07 May 2026 13:35:34 +0000 Received: from mail-ua1-x934.google.com ([2607:f8b0:4864:20::934]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wKyt1-00000000eIS-2z8j for pgsql-hackers@lists.postgresql.org; Thu, 07 May 2026 13:35:33 +0000 Received: by mail-ua1-x934.google.com with SMTP id a1e0cc1a2514c-95d439bd3a5so232153241.3 for ; Thu, 07 May 2026 06:35:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20251104.gappssmtp.com; s=20251104; t=1778160931; x=1778765731; darn=lists.postgresql.org; h=in-reply-to:autocrypt:content-language:from:references:cc:to :subject:user-agent:mime-version:date:message-id:from:to:cc:subject :date:message-id:reply-to; bh=LLDhFl5V+PkX2diCnVJmk8kejXkmH6uIwTXx64oGfHI=; b=q3V5UEx5H1l5MXnJKffufS0aTtSH5AOniQktYHmJ7s+OOyDAr7Niy8BSsx8Kzo9v4l 24fIQghjEOn/LndapCGQ7a0aeZrsrTai9Bq0U8ABPo/jTahWw6n1rNuculR/N+kbXSqM 5aQqhYWw46+YLuvWfp/m/221mPKd4i1xrwe09AZe4oPMr6TVQN4Erk1nXBwMMsGPyrK2 00cTPfoPBPV+c2Ho3V3/yn4bWKPrxdZWvHwphog7ut2cqLprvSYokZjcyQMy+Cx1VFZk c04Cs8le2BGUAPQ40tI1GA90XjPHwq2eqG0WaAazaLZbuNPgJDmnpq+ze8pgyHVHQAsQ ty1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1778160931; x=1778765731; h=in-reply-to:autocrypt:content-language:from:references:cc:to :subject:user-agent:mime-version:date:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=LLDhFl5V+PkX2diCnVJmk8kejXkmH6uIwTXx64oGfHI=; b=rGmOlP9+hV2gPq9ilsVZAX4vB3ogbsYYuFPF7Oxuph7hHMMyFg5+Q5Fy/pJSrErJae wO3m1KbGFPNUvUDLu+8Os0duZMatYvIlg26BkMmtQFxS2Abv0yWRm+lwIObFJ7FHCJ9s 1o1VC4Xje3p+KE+K+zBc5mSkNhd5jMe/MRcdqM87qukpXrdZz6uruUGlJdNpJOvSuXAH yshaO3TEboLJNDNVIBuGtNDr1q2eQAFPNwIabY8vQq2//hdUqvS6NdQ5uJmc3gXBx9Tl V4/whtRu12rzDALdwWOoDPY95GEqsF2eSyA5dABuAnJvV8Iqu7OTUzoakau0Y6va6soO 7xjw== X-Forwarded-Encrypted: i=1; AFNElJ+YRoQ8RL9AFRNCsK+DgV82XkGjZX/KxpRh44EX8d/gvRExA/9/YJaToWe3OyFizTBNvLE7nb5M3VxfYjZB@lists.postgresql.org X-Gm-Message-State: AOJu0YyiIiA6uDIhs/06E4yvlBPklnj3JoSUIMMAjwQIUzWTM8TIJiBh C074/xnC8n//rGIJSgsbIvvrJ0xFDPji7jYW57b2mDY/U7DICAcJpQKvjzAs6wb1gbk= X-Gm-Gg: AeBDietp1pueGAq7Rn7jimYEQV5HJqJJxzxg6+RhRypMBJoF8rjleQeHZypEvQthmMd xZerU8xyRvMzrFifHsP4YiyxTJWDGiehTV17AJ0hzN44rqCvXSbQZciunzaO7rJ9e2KthtdfMu1 JafTaFUWDo9THAlTT//9N/KqHNy2o0frS5To02O6f11xHasiD1aBDZXL2Rc+IvTou/Jyo3CHYKJ O0poN+Tvm47CLttPKOEqYZweO36tjnIUC80jdh27aH8wcP30/fuEyWsRYPorVJ/F6pJut2Upcy3 mhKhupDjwuJI8LuslbX5ixKIgCdRcZVMrzRgHQb1roAjVY4H1ceVTRU+wR6haFlASW7UCwkVzUM Q0tRSd+Ta01OBmlGngqPKNc26VBTyW7qe0dbhqkdUcKwBoVakuUCAcQPg/Aho/NBTWhnh+girWt 77HILpBcz9gfRYrX2RZtFKYupzYNnoQKHDWBtXYjdijBJLOIx69iI= X-Received: by 2002:a05:6102:3582:b0:62f:4349:ce2b with SMTP id ada2fe7eead31-630f90995eemr4000465137.30.1778160930673; Thu, 07 May 2026 06:35:30 -0700 (PDT) Received: from ?IPV6:2605:a601:a6b0:500::1cb? ([2605:a601:a6b0:500::1cb]) by smtp.googlemail.com with ESMTPSA id 6a1803df08f44-8b53d831651sm203248046d6.47.2026.05.07.06.35.30 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 07 May 2026 06:35:30 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------BaEYqa69mvtLlMpqcw69AivD" Message-ID: Date: Thu, 7 May 2026 09:35:29 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database To: Isaac Morland , "David G. Johnston" Cc: Dutch Glory , "pgsql-hackers@lists.postgresql.org" References: <489875059.7072445.1778142833311.ref@mail.yahoo.com> <489875059.7072445.1778142833311@mail.yahoo.com> From: Andrew Dunstan Content-Language: en-US Autocrypt: addr=andrew@dunslane.net; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNJEFuZHJldyBEdW5zdGFuIDxhbmRyZXdAZHVuc2xhbmUubmV0PsLAlwQTAQgAQQIbAwIX gAIZAQULCQgHAwUVCgkICwUWAgMBAAIeBRYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNGd BQkdEO8nAAoJEJn6f8tZ/DuBq74H/jkTR4Zi3stbw+xC7v2u3QozssK7MYPL2AsVfh7OealS h182fiWXpfvmmAB7WUHbhk9GC2RAOnHI/2d2jgKaMLAHsGYOT0YopTVIwRY43fCw/mK67yxc wmDcX+zyKfLaivNbf5A7QPLNwda98bEAMSJ8Sn652Uc6cA8t3uKGsVzbRBQOoYzjgvBCfSrE 9ql3PDNg0l4BfAqabd2f70ZUm9VAMEPrgv/v2xI7M2XiL4g5BVmqLCOwxLM8RMCotCuoweUr VO43DeBCIDwLxotMJKvGWDjBzQYlU1NPUAtNcz/gN9ITUe1VUGjyvGj4u1lxBOcQQUw7l1+T 5moZ4iZxXzvOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oKWaqf+wmW4tpDe/VV cxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7llV0xSSoFiieQBsr GvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8BoVrRFcdzlIY/NFN hFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C4R+M6w7o2PLGOjdZ +kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaYL++LAEOqrlvm2Tvq QqZRtnEAEQEAAcLAfAQYAQgAJgIbDBYhBOQ+WEYd/Hy/RGkVpZn6f8tZ/DuBBQJoGNI2BQkd EODdAAoJEJn6f8tZ/DuBfw0IAKTsfD40teP/pp+bsLLMSxPXUYrrprTj7WFB5v61p6dkpSr/ qXmMlyahdxQFaPmfVgVirB1Vk/kHiWNnnGjfUV9nB2Zg9LI0Xb9/ts3LsUiRWXzG3tkMY6XL vsVOxW4XFRND9l2q+WW93aZ1DZl+fqWfYgMvsusFRhmGFOKTRfKPta2Pkv+AhA24N4+PrR5p bU4k2MO8PAGiK8eaYKGFG1bHKuAvoDoF7WXJ3FHxuWqLnKEt4dfOLm5pAe3zq1Lt6q8azT9i QWGpSAK5vQUWQHBHpiDjdPeqKZ6HiAXIIKfSmb+jrvXBqoP+D6/K7rUjG2aXiRtTIAXms9sm VRu7cmw= In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------BaEYqa69mvtLlMpqcw69AivD Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 2026-05-07 Th 8:44 AM, Isaac Morland wrote: > On Thu, 7 May 2026 at 08:40, David G. Johnston > wrote: > > On Thursday, May 7, 2026, Dutch Glory wrote: > > > proposal: > Postgresql 18 Linux (all flavors) - with installation, create > new instance/main database: > sudo -u postgres /usr/pgsql-18/bin/pg_ctl -D > /var/lib/pgsql/18/data/ initdb > > > 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. cheers andrew -- Andrew Dunstan EDB:https://www.enterprisedb.com --------------BaEYqa69mvtLlMpqcw69AivD Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit


On 2026-05-07 Th 8:44 AM, Isaac Morland wrote:
On Thu, 7 May 2026 at 08:40, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thursday, May 7, 2026, Dutch Glory <dutch.glory@yahoo.com> wrote:

proposal:
Postgresql 18 Linux (all flavors) - with installation, create new instance/main database:
sudo -u postgres /usr/pgsql-18/bin/pg_ctl -D /var/lib/pgsql/18/data/ initdb


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.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com
--------------BaEYqa69mvtLlMpqcw69AivD--