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
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

techsupport19fe

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.

Mouhsen Ibrahim • July 18, 2017

@techsupport19fe

Refer here to backup and restore postgresql databases.

You can automate the backup process using cron jobs

Hope this helps.

Join the DigitalOcean Community