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

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


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.


Refer here to backup and restore postgresql databases.

You can automate the backup process using cron jobs

Hope this helps.