1

I want to backup my postgresql database with a automatic backup program and that program only support a script line that backup with pg_dump. I can't provide password in this script so I changed method from pg_hba.conf file from md5 to trust so that it won't ask for password and I used --no-password option. How can I change this to md5 and provide password for it.

Improve this question
1

1 Answer 1

Reset to default
1

I would use a .pgpass file or use the peer authentication method. Details here:
Run batch file with psql command without password

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.