Menu
I've looked all over the internet and nobody seems to have this answer.
I've never created a user, am I supposed to?
"root" and "password" throws up "password authentication failed" and leaving the fields blank throws up "no password supplied"
209
For most systems, the default Postgres user is postgres and a password is not required for authentication. Thus, to add a password, we must first login and connect as the postgres user.
By Default, the user is 'postgres' and the password is the one which you enter while installing the database. (Version 11,12 I have tested). and enter the password used while installing. Or create a user with login permissions using PgAdmin tool.
If you are logged into the same computer that Postgres is running on you can use the following psql login command, specifying the database ( mydb ) and username ( myuser ): psql -d mydb -U myuser.
Did you try with postgres as username and password ?
166
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
