How to update the PostgreSQL version shipped with MATLAB?

I want to use a newer PostgreSQL version than the one shipped with my current release of MATLAB. 

How can I update PostgreSQL files/binaries included with my MATLAB installation?

Answer 1

[MathWorks Support Team]

To update the PostgreSQL version shipped with MATLAB, manually replace the PostgreSQL files/binaries under the MATLAB installation with updated PostgreSQL binaries.

Follow the steps below:

1. Back up the shipped PostgreSQL folder
   • Back up the contents of the shipped PostgreSQL directory so you can revert if needed. For example, on installations where PostgreSQL is located under the following folder, back up that entire folder: <MATLABROOT>/sys/postgresql/glnxa64/PostgreSQL
2. Replace the shipped binaries
   • Download PostgreSQL binaries for your preferred PostgreSQL version and operating system from the PostgreSQL downloads page.
   • Replace all files in the PostgreSQL folder with the updated copies, including the "libpq" driver. For example: <MATLABROOT>/sys/postgresql/glnxa64/PostgreSQL
3. Verify the installation
   • Configure your PostgreSQL Native Interface Data Source to ensure it was correctly installed after the replacement.