bee1 Posted September 15, 2020 Posted September 15, 2020 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! Quote
Krydos Posted September 15, 2020 Posted September 15, 2020 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. Quote
bee1 Posted September 15, 2020 Author Posted September 15, 2020 Perfect, thank you Krydos, just the direction I needed. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.