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 577 views
Backups Ubuntu
techsupport19fe
By:
techsupport19fe

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

Log In to Comment
1 Answer
Mohsen47 July 18, 2017

@techsupport19fe

Refer here to backup and restore postgresql databases.

You can automate the backup process using cron jobs

Hope this helps.

How To Backup PostgreSQL Databases on an Ubuntu VPS
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.
Reply
Have another answer? Share your knowledge.

Related Questions