I've got a postgres database that I want to backup regularly. For that, I'd like to use the automated backup script here
Usually I to proceed admin tasks I use these command:
> sudo -i -u postgres
> psql
No password is requested and I can dump manually my database. It's not too bad.
Using the automated script I face a password issue. It asks me for postgres
password. I've never set it up and I thought I shouldn't need to set it up as the example given above showed.
Here is how is configured my pg_hba.conf
.
# 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
Do I really need to set a postgres
password for running my script?