Thread

1. Postgresql 18 Linux (all flavors) - with installation, create new instance/main database

   Dutch Glory <dutch.glory@yahoo.com> — 2026-05-07T08:33:53Z

   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
   
   
   
   

2. Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database

   David G. Johnston <david.g.johnston@gmail.com> — 2026-05-07T12:40:39Z

   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.
   
   David J.
   

3. Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database

   Isaac Morland <isaac.morland@gmail.com> — 2026-05-07T12:44:12Z

   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).
   

4. Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database

   Andrew Dunstan <andrew@dunslane.net> — 2026-05-07T13:35:29Z

   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
   

5. Re: Postgresql 18 Linux (all flavors) - with installation, create new instance/main database

   Tom Lane <tgl@sss.pgh.pa.us> — 2026-05-07T14:07:00Z

   Andrew Dunstan <andrew@dunslane.net> 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