Jump to content


Photo

PgAdmin Automated Backups

pgadmin pgagent postgres postgresql backups backup

  • Please log in to reply
2 replies to this topic

#1 bee1

bee1

    Newbie

  • Members
  • 6 posts

Posted 15 September 2020 - 03:43 AM

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!



#2 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 20,593 posts
  • Gender:Male

Posted 15 September 2020 - 04:07 AM

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.



#3 bee1

bee1

    Newbie

  • Members
  • 6 posts

Posted 15 September 2020 - 04:13 AM

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







Also tagged with one or more of these keywords: pgadmin, pgagent, postgres, postgresql, backups, backup

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users