I have a droplet that has 2 postgresql databases. It is possible for me to backup individual databases and restore each when i need to

July 18, 2017 173 views
Backups Ubuntu

The real issue is that each database hold different type of data. I need the flexibility to backup either database when i like and restore when ever the need arises. So while my droplet is running I should be able to backup a single DB .and restore it.
Is there any tool to do this or even automate it

1 Answer

@techsupport19fe

Refer here to backup and restore postgresql databases.

You can automate the backup process using cron jobs

Hope this helps.

by Justin Ellingwood
PostgreSQL is a popular database management system that can be used to handle the data from your website or application. This article will discuss methods of backing up PostgreSQL databases to ensure that your information will not be lost in the event of a problem.
Have another answer? Share your knowledge.