How to provide password in one script to connect to postgresql database

Question

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.

http://stackoverflow.com/q/6405127/330315 – a_horse_with_no_name Mar 05 '14 at 07:10 — a_horse_with_no_name, Mar 05 '14 at 07:10

score 1 · Accepted Answer · edited May 23 '17 at 10:26

1

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

edited May 23 '17 at 10:26

Community

1
1

answered Mar 05 '14 at 07:41

Erwin Brandstetter

539,169
125
977
1,137

How to provide password in one script to connect to postgresql database

1 Answers1