Hi,
We need to automate our backups of the Postgres Database for our confluence installation.
We can already perform a manual backup but we are prompted for the database password each time.
The script content used is below
SET PGPASSFILE=D:\PostgresqlBack\bin\pgpass.conf
"C:\Program Files\PostgreSQL\9.1\bin\pg_dumpall.exe" -U postgres > D:\PostgresqlBack\postgres_db.out
Can you advise how I might achieve this please?
Hi Chris,
I've investigated a bit and it seems that you would need to create a file in your environment of .pgpass type where the pg_dump will run as.
More information can be found in this link:
http://stackoverflow.com/questions/2893954/how-to-pass-in-password-to-pg-dump
Cheers,
Rodrigo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.