I've got a working postgreSQL database with following pg_hba.conf:
local all postgres peer local all all md5 host all all 127.0.0.1/32 md5 host all all ::1/128 md5 hostssl all dbadmin my.ip.at.home/32 md5
Which, to my understanding is correct, and only allows local connections and from my home-ip via SSL. Both via a md5 password.
I now want a local bash script to run some things on the databases (backups). For this I created a new user
backup_user; as the script needs to run autonomous my thoughts were to create a line for this user to trust from the the
host all backup_user 127.0.0.1/32 trust
But when I login via SSH and run this command I have to type the password....
psql -U backup_user -p 5454
What is the best way to let the script do its thing? If it matters, I want this script to sun: Automated Backup