automate confluence database backups on windows

Question

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?

Rodrigo Girardi Adami · Answer

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