bee1 Posted September 15, 2020 Share 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 Link to comment Share on other sites More sharing options...
Krydos Posted September 15, 2020 Share 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 Link to comment Share on other sites More sharing options...
bee1 Posted September 15, 2020 Author Share Posted September 15, 2020 Perfect, thank you Krydos, just the direction I needed. Quote Link to comment Share on other sites More sharing options...
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.