Install pgAdmin
pgAdmin was created to help PostgreSQL users get the most out of their database. The purpose is to provide a graphical administration tool to make it easier to manipulate schema and data in PostgreSQL
1. Install pgAdmin
2. Locate the shared resources
The executeables pgsql, pg_dump and pg_restore is hidden on Mac. Navigate to the App folder in the Finder. Right-click on pgAdmin app and select “Show Package Contents”. Drag one file into Terminal in order to get the path to these files. This path is later used in the script.