Thread: Default MacOS Username Database

Default MacOS Username Database

From
Joe Bloggs
Date:
Hi,

I installed PG on a Mac using the Postgres.app and I noticed that a database named after my username is created by default. What's the point of this database? Should/can you delete it? Should you leave it alone?

Thanks!

Re: Default MacOS Username Database

From
Dan Smith
Date:
Hello Joe,

I'm certainly not an authority on the app, but, have used it.  I believe it is just providing the user name database as a developer quick start (place to create ddl outside of system database).  

If I remember correctly, it can safely be removed and/or new databases can be created but you may have to adjust configuration for the quick launch shortcuts for psql or similar.


Best regards,

Dan Smith

On Mon, Dec 13, 2021, 08:15 Joe Bloggs <joebloggs122021@gmail.com> wrote:
Hi,

I installed PG on a Mac using the Postgres.app and I noticed that a database named after my username is created by default. What's the point of this database? Should/can you delete it? Should you leave it alone?

Thanks!