During my migration to from Microsoft Sql Server 2014 to PostgreSQL 11, the queries were running slower. So I thought maybe the indexes from SQL Server were missing. I did a quick search on google to find a tool that automatically adds missing indexes to tables. I found a tool called Dexter. The Documentation requires that you install HypoPG in order to run dexter.

Install HypoPG:

cd /tmp
curl -L https://github.com/HypoPG/hypopg/archive/1.1.2.tar.gz | tar xz
cd hypopg-1.1.2
make
make install # may need sudo

Install Dexter:

gem install pgdexter

Run Dexter:

dexter --host ${host} -p ${port} -d ${databasename}

Then I get errors that the HypoPG is not installed.

The reason the Install HypoPG text appears is because its not installed in the Postgres App for Mac. In order to get Dexter working properly you have to install the HypoPG into the Postgres App installation directories. The following commands resolved the errors. Hopefully this help someone who runs into the same issue.

/bin/sh /Applications/Postgres.app/Contents/Versions/11/lib/postgresql/pgxs/config/install-sh -c -d '/Applications/Postgres.app/Contents/Versions/11/lib/postgresql'  
/bin/sh /Applications/Postgres.app/Contents/Versions/11/lib/postgresql/pgxs/config/install-sh -c -d '/Applications/Postgres.app/Contents/Versions/11/share/postgresql/extension/'
/bin/sh /Applications/Postgres.app/Contents/Versions/11/lib/postgresql/pgxs/config/install-sh -c -d '/Applications/Postgres.app/Contents/Versions/11/share/postgresql/extension/'
/usr/bin/install -c -m 755  hypopg.so '/Applications/Postgres.app/Contents/Versions/11/lib/postgresql/hypopg.so'
/usr/bin/install -c -m 644 .//hypopg.control '/Applications/Postgres.app/Contents/Versions/11/share/postgresql/extension/'
/usr/bin/install -c -m 644 .//hypopg--1.1.2.sql '/Applications/Postgres.app/Contents/Versions/11/share/postgresql/extension/'