Question
How to set up passwordless postgresql for deployer user?
I’m trying to set up passwordless postgres for my ‘deployer’ user. Made a couple of changes to pg_hba.conf file and restarted the service.
Here is how my current pg_hba.conf file looks:
### Database administrative login by Unix domain socket
local all postgres peer
### TYPE DATABASE USER ADDRESS METHOD
### "local" is for Unix domain socket connections only
local all all peer
### IPv4 local connections:
host all all 127.0.0.1/32 md5
### IPv6 local connections:
host all all ::1/128 md5
But even now when I ssh back in as deployer and $ sudo -i -u postgres it asks for the password. Is there something else that I have to do?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×