PgAdmin Automated Backups

[bee1]

Hi,

I have a local copy of pgAdmin which I am using to connect to my database, but I am not sure how to connect pgAgent to automate backups / dumps of my databases on a regular schedule. Any suggestions or web tutorials you are able to point me to would be greatly appreciated. 

 

Thanks!

[Krydos]

If I were you I would make a cron job that runs the pg_dump command with your password in a .pgpass file. HelioHost limits crons to 2 per day, so as long as you don't want to backup your database more than every 12 hours this should work for you.

[bee1]

Perfect, thank you Krydos, just the direction I needed.