postgresql

How to backup and restore postgresql database 9.6 Having regular backups of your database is important as you might already know. You might even have a development environment that you want to load with production data. Here is quick overview of how you can backup your postgresql database and restore it. This will also work if you are backing it up from Ubuntu linux and restoring it to Mac OSX.

Here is a short tutorial on how to remove older versions of PostgreSQL database from OSX when you have multiple versions installed. If you follow one of the popular answers on StackOverFlow you may accidentally delete an important file for your other newer versions of PostgreSQL running on your Mac. These instructions assume you installed the database with the EnterpriseDB installer. Here are the steps you need to follow: First, make a backup of the database if you need any data or schema.