在MacOS Bash上使用PHP服务器错误的Postgresql数据库

Question

I ran a PHP server with postgresql on my college computers which works fine, however on my local machine (which runs MacOS), I get the following error message:

Call to undefined function pg_Connect() in /Users/mac/Documents/<... the remaining path to php file>.php on line 2

Now, I thought it's an issue of missing the postgresql packages for php, so I used brew to install the php postgresql packages. I ran the following commands:

brew install postgresql
brew install php55 --with-postgresql
brew install php55-pdo-pgsql

However, even after running these commands I get the same error when running the php server, i.e.

Call to undefined function pg_Connect() in /Users/mac/Documents/<... the remaining path to php file>.php on line 2

The php version I have is 5.5.30:

mac$ php -v
PHP 5.5.30 (cli) (built: Oct 23 2015 17:21:45) 
Copyright (c) 1997-2015 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2015 Zend Technologies

Please could you suggest what I am doing wrong to install the packages. I read on stack overflow that the packages can be installed with an apt-get command on linux, however I'm not sure as to what the solution is with the Mac operating system.

Thanks in advance.

Answer 1

The solution was edit the php.ini on your server then find this below line and uncomment that line.

extension="pgsql.so"

then restart the server apache and test it out again.

Also, check this link for the steps regarding installation of the postgress to mac OS.