Enabling PostgreSQL support in PHP on Mac OS X

by

The PHP version that comes bundled with OS X doesn’t include PostgreSQL. You’ll have to compile the extension yourself. Here are some instructions:

  1. Find your version of PHP: php -v.
  2. Download the version of PHP that matches yours: curl -O http://us.php.net/distributions/php-5.3.3.tar.gz. (This example downloads PHP 5.3.3 but this must match your version)
  3. Extract the archive you downloaded: tar -xzvf php-5.3.3.tar.gz
  4. Change to the PostgreSQL’s extension directory: cd php-5.3.3/ext/pgsql/
  5. Type phpize.
  6. Type ./configure.
  7. Type make.
  8. Type sudo make install.
  9. Add the extension to you php.ini file by adding extension=pgsql.so. (You may already have done this)
  10. Restart Apache.

Update for OS X Mountain Lion
Apple has removed autoconf from the newer versions of XCode so the procedure above will fail at #5. To solve that problem:

  1. Type /usr/bin/ruby -e "$(/usr/bin/curl -fksSL https://raw.github.com/mxcl/homebrew/master/Library/Contributions/install_homebrew.rb)".
  2. Type sudo chown -R $USER /usr/local/Cellar.
  3. Type brew update.
  4. Type brew install autoconf.

That should install autoconf and allow you to install the module using the instructions above.

More Related Contents:

  1. Cannot simply use PostgreSQL table name (“relation does not exist”)
  2. Best way to get result count before LIMIT was applied
  3. How to install MySQLi on MacOS
  4. Simple Postgresql Statement – column name does not exists
  5. osx 10.10 Curl POST to HTTPS url gives SSLRead() error
  6. How to override the path of PHP to use the MAMP path?
  7. How to use the php that brew installed?
  8. Get last insert id after a prepared insert with PDO
  9. pg_query result contains strings instead of integer, numeric
  10. How can I easily switch between PHP versions on Mac OSX?
  11. install ext-zip for Mac
  12. Installing PHP Zip Extension
  13. Extending PHP with C++?
  14. How do I enable php to work with postgresql?
  15. Getting Started with PHP Extension-Development [closed]
  16. Setting a connect timeout with PDO
  17. How to prevent PDO from interpreting a question mark as a placeholder?
  18. Pass array literal to PostgreSQL function
  19. CakePHP Database connection “Mysql” is missing, or could not be created
  20. Mysql password expired. Can’t connect
  21. Installing mcrypt extension for PHP on OSX Mountain Lion
  22. $PATH environment variable for apache2 on mac
  23. PHP Warning: PHP Startup: Unable to load dynamic library ‘pdo_mysql.so’
  24. How do I see the extensions loaded by PHP?
  25. How to install all required PHP extensions for Laravel?
  26. Installing pecl and pear on OS X 10.11 El Capitan, macOS 10.12 Sierra, macOS 10.13 High Sierra (< 10.13.3)
  27. Convert PostgreSQL array to PHP array
  28. Different timezone_types on DateTime object
  29. change the PHP path to MAMPs PHP
  30. Installing PHP Zip Extension in CentOS

Leave a Comment