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