Thread

1. BUG #18880: Can't have a database without having postgres as a db_name and username

   PG Bug reporting form <noreply@postgresql.org> — 2025-04-06T02:20:27Z

   The following bug has been logged on the website:
   
   Bug reference:      18880
   Logged by:          Keven Boudreau
   Email address:      kevenboudreau58@gmail.com
   PostgreSQL version: 17.4
   Operating system:   Windows 11
   Description:        
   
   Like I said I can't have a database with another db_name and username I find
   that frustrating because I need to change these to class myself for my work
   I need multiple database with differents name and username
   
   Thank you for the support in advance and I hope you will solve that faster!
   
   

2. Re: BUG #18880: Can't have a database without having postgres as a db_name and username

   Daniel Westermann (DWE) <daniel.westermann@dbi-services.com> — 2025-04-07T07:15:02Z

   >Like I said I can't have a database with another db_name and username I find
   >that frustrating because I need to change these to class myself for my work
   >I need multiple database with differents name and username
   
   >Thank you for the support in advance and I hope you will solve that faster!
   
   Can you please describe what you are trying to do exactly? You definitely can have multiple databases with their own owners.
   
   Regards
   Daniel
   

3. Re: BUG #18880: Can't have a database without having postgres as a db_name and username

   Tom Lane <tgl@sss.pgh.pa.us> — 2025-04-07T13:48:14Z

   PG Bug reporting form <noreply@postgresql.org> writes:
   > Like I said I can't have a database with another db_name and
   > username
   
   Sure you can.  The bootstrap superuser account's name is set by
   initdb [1].  It's true that you can't change the initial set of
   database names (postgres, template0, template1), but you can
   create more databases within the installation [2].
   
   If you're really stubborn you can delete or rename the postgres
   database, but you might regret it.  A lot of client tools assume
   that as the default database-to-connect-to.  I don't recommend
   deleting or renaming template0 or template1 under any
   circumstances [3].
   
   			regards, tom lane
   
   [1] https://www.postgresql.org/docs/current/app-initdb.html
   [2] https://www.postgresql.org/docs/current/manage-ag-createdb.html
   [3] https://www.postgresql.org/docs/current/manage-ag-templatedbs.html