Install PHP PGSQL extensions on macOS (change PHP_VER with your PHP version)

install_psql_php.sh

PHP_VER="7.3.31"

# Check if extension exists first
php -m | grep pgsql

# Update brew and install requirements
brew update
brew install autoconf

# Download PHP source and extract
mkdir -p ~/php-src; cd ~/php-src
wget -c http://br1.php.net/distributions/php-$PHP_VER.tar.bz2
tar -xjf php-$PHP_VER.tar.bz2

# Go to extension dir and phpize
cd php-$PHP_VER/ext/pdo_pgsql/
phpize

# Configure for Postgress.app
./configure --with-pdo-pgsql="/Applications/Postgres.app/Contents/Versions/9.4"
# Use just "./configure" for brew version
# ./configure --with-pdo-pgsql="/Library/PostgreSQL/9.3/"
make
sudo make install

# Add extension to php.ini
# sudo echo "extension=pdo_pgsql.so" >> /private/etc/php.ini
sudo echo "extension=pdo_pgsql.so" >> /etc/php.ini

# Go to extension dir and phpize
cd ../pgsql/
phpize

# Configure for Postgress.app
./configure --with-pgsql="/Applications/Postgres.app/Contents/Versions/9.4"
# Use just "./configure" for brew version
# ./configure --with-pgsql="/Library/PostgreSQL/9.3/"
make
sudo make install

# Add extension to php.ini
# sudo echo "extension=pgsql.so" >> /private/etc/php.ini
sudo echo "extension=pgsql.so" >> /etc/php.ini

# Check if extension exists, again
php -m | grep pgsql