Answer the question
In order to leave comments, you need to log in
Why is asking for a password in postgres?
Good evening everyone!
I transfer my project to the server and I need postgres to work.
I followed this
manual Manual
but I don’t understand a dick !!!! It seems that I created a new user alejandro and another alejandroPG,
I go into postgres, sudo -i -u postgres
and then I want to go into my role alejandro, which was created in postgress, but it asks for a password from postgress, nothing asked for a password during installation, here is the log
[email protected]:~$ sudo -i -u postgres
[sudo] password for alejandro:
[email protected]:~$ sudo -i -u alejandro
[sudo] password for postgres:
Sorry, try again.
[sudo] password for postgres:
Role name | Attributes | Member of
-------------+------------------------------------------------------------+-----------
alejandro | Superuser, Create role, Create DB | {}
alejandroPG | Superuser, Create role, Create DB | {}
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
Answer the question
In order to leave comments, you need to log in
[email protected]:~$ sudo -i -u postgres
[sudo] password for alejandro:
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question