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.