pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18880: Can't have a database without having postgres as a db_name and username
3+ messages / 3 participants
[nested] [flat]
* BUG #18880: Can't have a database without having postgres as a db_name and username
@ 2025-04-06 02:20 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 2 replies; 3+ messages in thread
From: PG Bug reporting form @ 2025-04-06 02:20 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: kevenboudreau58@gmail.com
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!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18880: Can't have a database without having postgres as a db_name and username
@ 2025-04-07 07:15 Daniel Westermann (DWE) <daniel.westermann@dbi-services.com>
parent: PG Bug reporting form <noreply@postgresql.org>
1 sibling, 0 replies; 3+ messages in thread
From: Daniel Westermann (DWE) @ 2025-04-07 07:15 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>; kevenboudreau58@gmail.com <kevenboudreau58@gmail.com>
>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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18880: Can't have a database without having postgres as a db_name and username
@ 2025-04-07 13:48 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Bug reporting form <noreply@postgresql.org>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2025-04-07 13:48 UTC (permalink / raw)
To: kevenboudreau58@gmail.com; +Cc: pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-04-07 13:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-04-06 02:20 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-07 07:15 ` Daniel Westermann (DWE) <daniel.westermann@dbi-services.com>
2025-04-07 13:48 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox