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
"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?
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:
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG