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
# 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?