nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

T07 Configuring and restoring postgreSQL databases on Mac (Koprowski)

stan_koprowski

Install the postgreSQL database and associated ODBC driver

Use all defaults when possible.

Install postgreSQL database on your Mac ( http://www.enterprisedb.com/products-services-training/pgdownload#osx )
by double-clicking "postgresql-9.5.1-1-osx.dmg" file.
- Accept all defaults if prompted
- Click Ok/Next if prompted
- Username: postgres
- Password: postgres
Install the postgreSQL ODBC driver (bitness must match your installed version of JMP)
Note: Mac OS is 64bit; JMP / JMP Pro are 64 bit
Configure the driver using either iODBC Openlink ODBC Administrator or the default ODBC Manager.
- Data Source Name is arbitrary; Enter any name you prefer
- Enter a comment for the DSN
- Add the key-value pairs using the Add button as shown below.
- Username and password are the same as you entered when installing the postgreSQL database in step 1 above

11163_Screenshot 2016-03-22 23.00.57.png

4. Test the connection to ensure it is working properly.

11164_Screenshot 2016-03-22 23.01.26.png

RESTORE THE SAMPLE DATABASES

The steps for restoring a postgreSQL database on a Mac are fairly easy to replicate.

Copy the attached "PostgreSQL-MAC-SampleDBs.backup" file to your local drive.
- The file contains some sample databases and data tables from the JMP sample library
Navigate to the postgres database and right-click and select Restore.

11152_Screenshot 2016-03-22 22.13.06.png

3. Click the .... button and navigate and locate the file you saved in step 1 above.

11162_Screenshot 2016-03-22 22.29.23.png

4. Click the Restore button.

5. After the restore has been completed go ahead and close the restore database window.

edb_psqlodbc.app.zip

postgresql-9.5.1-1-osx.dmg

PostgreSQL-MAC-SampleDBs.backup

Comments

Nate_Riordan

Hi Stan,

In attempting this using a newer version of postgres (9.6) I'm running into an error on the restore segment. At first it could not find the location of the pg_dump binaries. I managed to find the path to be "/Library/PostgreSQL/9.6/bin/"

Now I'm getting the error that it cannot find the backup file for restoration when it is in fact present. Any thoughts on how to resolve?

Screen Shot 2016-11-14 at 1.56.54 PM.png

Chris_Kirchberg

@stan_koprowski,

Postgres is now at version 13.2. We might want to update this page for the newest version as well as where to get the latest ODBC Manager. Since macOS 11 is out, it would be helpful to test the instructions for the new OS. I am trying but I get errors installing (something about shortcuts not installing).

The package in this post not longer installs on Big Sur. I have trying to install 13.2 but at the end I get this error message "A non-fatal error occur whilst creating menu shortcuts."

and then this message "Problem running post-install step. Installation may not complete correctly. Failed to start the database server."

Also, how does one install the postgresODBC driver?

Thanks,