How to create the first DB in Postgres

Question

I have just installed Postgres 12 on a Mac. As you may soon appreciate I am totally new to it.

During the installation process I was asked to provide a "password". I do not remember specifically, but I think it was for the some sort of admin role.

Now I want to create my first database. Reading the documentation I insert the command

createdb myfistdb

the system asks for a password. I give the one I set during the installation processes but I got the following error

createdb: error: could not connect to database template1: FATAL:  password authentication failed for user "myusername"

where myusername is the user I am logged in.

The same happens if I give the system password of myusername.

I understand that my question is pretty basic, but I have been struggling quite some time without any success, so any help will be appreciated.

Have you tried to reset the password, if yes and it still fails, just restart it and try to login again — YouKnowWhoIAm
– YouKnowWhoIAm, Commented Oct 13, 2019 at 13:36
Try logging in as the postgres user, not the myusername one — Bergi
– Bergi, Commented Oct 13, 2019 at 13:49
You need to provide the DB user name with the -U option. Here are the docs: postgresql.org/docs/current/app-createdb.html — Islingre
– Islingre, Commented Oct 13, 2019 at 15:02

Laurenz Albe · Accepted Answer · 2019-10-14 06:09:51Z

2

The database uset name used by createdb defaults to the operating system user name, so you'll have to specify the administrative superuser explicitly:

createdb -U postgres myfistdb

answered Oct 14, 2019 at 6:09

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create the first DB in Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related