automate confluence database backups on windows

Chris Lakey February 26, 2015

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?

 

1 answer

0 votes
Rodrigo Girardi Adami
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 26, 2015

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events