public inbox for [email protected]help / color / mirror / Atom feed
Postgresql 18 Linux (all flavors) - with installation, create new instance/main database 5+ messages / 5 participants [nested] [flat]
* Postgresql 18 Linux (all flavors) - with installation, create new instance/main database @ 2026-05-07 08:33 Dutch Glory <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Dutch Glory @ 2026-05-07 08:33 UTC (permalink / raw) To: [email protected] <[email protected]> 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 this way Postgresql is ready to use... _________________________________ Dank U - Thank You Twitter: http://twitter.com/OpenSimFan Facebook: http://www.facebook.com/andre.verwijs Instagram: https://instagram.com/dutchglory ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database @ 2026-05-07 12:40 David G. Johnston <[email protected]> parent: Dutch Glory <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: David G. Johnston @ 2026-05-07 12:40 UTC (permalink / raw) To: Dutch Glory <[email protected]>; +Cc: [email protected] <[email protected]> On Thursday, May 7, 2026, Dutch Glory <[email protected]> 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. David J. ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database @ 2026-05-07 12:44 Isaac Morland <[email protected]> parent: David G. Johnston <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Isaac Morland @ 2026-05-07 12:44 UTC (permalink / raw) To: David G. Johnston <[email protected]>; +Cc: Dutch Glory <[email protected]>; [email protected] <[email protected]> On Thu, 7 May 2026 at 08:40, David G. Johnston <[email protected]> wrote: > On Thursday, May 7, 2026, Dutch Glory <[email protected]> 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). ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database @ 2026-05-07 13:35 Andrew Dunstan <[email protected]> parent: Isaac Morland <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Andrew Dunstan @ 2026-05-07 13:35 UTC (permalink / raw) To: Isaac Morland <[email protected]>; David G. Johnston <[email protected]>; +Cc: Dutch Glory <[email protected]>; [email protected] <[email protected]> On 2026-05-07 Th 8:44 AM, Isaac Morland wrote: > On Thu, 7 May 2026 at 08:40, David G. Johnston > <[email protected]> wrote: > > On Thursday, May 7, 2026, Dutch Glory <[email protected]> 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database @ 2026-05-07 14:07 Tom Lane <[email protected]> parent: Andrew Dunstan <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: Tom Lane @ 2026-05-07 14:07 UTC (permalink / raw) To: Andrew Dunstan <[email protected]>; +Cc: Isaac Morland <[email protected]>; David G. Johnston <[email protected]>; Dutch Glory <[email protected]>; [email protected] <[email protected]> Andrew Dunstan <[email protected]> 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2026-05-07 14:07 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-05-07 08:33 Postgresql 18 Linux (all flavors) - with installation, create new instance/main database Dutch Glory <[email protected]> 2026-05-07 12:40 ` Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database David G. Johnston <[email protected]> 2026-05-07 12:44 ` Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database Isaac Morland <[email protected]> 2026-05-07 13:35 ` Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database Andrew Dunstan <[email protected]> 2026-05-07 14:07 ` Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox