Adding PostgreSQL support to already installed PHP

Question

I have php-5.3.6 and postgresql installed in my Fedora 13. But it seems that postgresql support is not enabled in php. My phpinfo() page doesn't show any PostgreSQL section, neither pdo_pgsql section.

I checked /etc/php.ini, and it shows that PostgresSQL is enabled.

[root@localhost ~]# cat /etc/php.ini | grep ^pgsql
pgsql.allow_persistent = On
pgsql.auto_reset_persistent = Off
pgsql.max_persistent = -1
pgsql.max_links = -1
pgsql.ignore_notice = 0
pgsql.log_notice = 0

Is there any way I can add postgresql support to php without recompiling it from the source? Is there any other files I need to make some changes?

Akhil · Accepted Answer · 2020-01-27 13:43:32Z

43

Run yum install php-pgsql php-pdo_pgsql to install the PHP Postgres package.

edited Jan 27, 2020 at 13:43

Akhil

1,08014 silver badges25 bronze badges

answered Nov 18, 2011 at 10:52

Silas Parker

8,1771 gold badge32 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Silas Parker Over a year ago

Great! You may want to run yum list "php*" to view all the php packages that are optional extras.

Fábio Nicolau de Lima Over a year ago

Nice! Works perfectly! Thanks

ThomasSquall Over a year ago

apt-get install php5-pgsql for ubuntu users

user1836049 Over a year ago

you can use sudo yum install php-pdo_pgsql

iver56 · Accepted Answer · 2015-10-09 22:07:56Z

3

Here's what solved the issue for me (on Windows, using WAMPSERVER):

Uncomment extension=php_pgsql.dll and extension=php_pdo_pgsql.dll in php.ini
Restart all services in WAMPSERVER
Make sure that php_pgsql and php_pdo_pgsql are checked in the WAMPSERVER menu -> PHP -> PHP extensions
In httpd.conf add the line LoadFile "C:/Program Files/PostgreSQL/9.4/bin/libpq.dll" before the line LoadModule php5_module "c:/wamp/bin/php/php5.5.12/php5apache2_4.dll"
Restart all services again and check that the WAMPSERVER icon becomes green.

Source: http://toolkt.com/site/install-postgresql-and-phppgadmin-in-windows-with-wamp/

answered Oct 9, 2015 at 22:07

iver56

7771 gold badge10 silver badges12 bronze badges

Comments

user28864 · Accepted Answer · 2014-11-30 21:35:55Z

2

I had a similar problem earlier on today on Windows. I couldn't access "Phppgadmin". Whenever I tried to access it I get this error: "Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option". So I did some search which got me here.

Anyway, I was able find a way around the problem using the instruction I found here as follows:

Browsed to the php.ini file found in C:\xampp\php\php.ini and opened it in text editor as an administrator
Uncommented the following by removing the semicolons prefexing; extension_dir="C:\xampp\php\ext", extension=php_pgsql.dll and extension=php_pgsql.dll
Saved the file and restarted Apache

answered Nov 30, 2014 at 21:35

user28864

3,4731 gold badge28 silver badges19 bronze badges

Comments

Naveen Kumar · Accepted Answer · 2017-07-19 06:47:02Z

0

Similar problem I got earlier on Windows. I couldn't able to access "Phppgadmin". Whenever I access phppgadmin getting error: "Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option".

Finally, got the solution.

You need to follow this path C:\xampp\php\php.ini and opened it in text editor as an administrator and remove the semicolons pre-fexing; extension_dir="C:\xampp\php\ext", extension=php_pgsql.dll and extension=php_pgsql.dll Saved the file and restarted Apache

answered Jul 19, 2017 at 6:47

Naveen Kumar

4756 silver badges16 bronze badges

Comments

Saurabh Chandra Patel · Accepted Answer · 2022-02-02 16:56:29Z

0

uncomment extension=pgsql in php.ini file (for window xampp installation )

answered Feb 2, 2022 at 16:56

Saurabh Chandra Patel

13.7k7 gold badges94 silver badges80 bronze badges

Collectives™ on Stack Overflow

Adding PostgreSQL support to already installed PHP

5 Answers 5

4 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

4 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related