Question

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

Posted July 18, 2017 1.4k views
UbuntuBackups

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

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
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.
Submit an Answer