Install pdo for postgres Ubuntu

Question

I am trying to enable the pdo driver for my php installation, but when I runn the command

./configure --prefix=/usr/local/webserver/php --with-apxs2=/usr/local/webserver/apache2/bin/apxs --enable-mbstring --enable-intl --with-icu-dir=/usr --with-pgsql=/usr/local/webserver/postgres --with-pdo-pgsql=/usr/local/webserver/postgres

I get

"Unable to build the PDO PostgreSQL driver: libpq 7.4+ is required"

I install postgresql in that directory

/usr/local/webserver/postgres

I installed postgresql 9.0.4.1 using the bin package and using php 5.3

danlynn · Accepted Answer · 2017-12-22 17:23:38Z

117

Pecl PDO package is now deprecated. By the way the debian package php5-pgsql now includes both the regular and the PDO driver, so just:

apt-get install php-pgsql

Apache also needs to be restarted before sites can use it:

sudo systemctl restart apache2

edited Dec 22, 2017 at 17:23

danlynn

1431 silver badge5 bronze badges

answered May 7, 2013 at 9:48

Alex

1,4041 gold badge10 silver badges10 bronze badges

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

4 Comments

btleffler Over a year ago

I wasn't sure if that package included the PDO driver. Thanks!

Thiago Mata Over a year ago

Remember to execute: php5enmod pgsql after that

Junior Mayhe Over a year ago

After that, it is also needed to restart your web server

Richard Pérez Over a year ago

I don't remember how I solved by that moment, but what I can say now, is that for both Debian and Ubuntu what @alex say, is the correct way to install it. However I must said that versions of Ubuntu like 14 and maybe before of it, already include a version of Postgres (I think 9.0) if you want to install a new one like 9.3 you can use apt-get purge postgresql -y && apt-get install postgresql-9.3 -y

Dave Jarvis · Accepted Answer · 2013-04-23 03:39:14Z

28

Try the packaged pecl version instead (the advantage of the packaged installs is that they're easier to upgrade):

apt-get install php5-dev
pecl install pdo
pecl install pdo_pgsql

or, if you just need a driver for PHP, but that it doesn't have to be the PDO one:

apt-get install php5-pgsql

Otherwise, that message most likely means you need to install a more recent libpq package. You can check which version you have by running:

dpkg -s libpq-dev

edited Apr 23, 2013 at 3:39

Dave Jarvis

31.3k43 gold badges186 silver badges326 bronze badges

answered Aug 30, 2011 at 9:02

wildpeaks

7,4222 gold badges34 silver badges36 bronze badges

1 Comment

Mikko Ohtamaa Over a year ago

Please note that this answer is outdated and see the answer below from Will.

Dylan Pierce · Accepted Answer · 2017-10-03 19:34:22Z

27

If you're using the wonderful ondrej/php ubuntu repository with php7.0:

sudo apt-get install php7.0-pgsql

For ondrej/php Ubuntu repository with php7.1:

sudo apt-get install php7.1-pgsql

Same repository, but for php5.6:

sudo apt-get install php5.6-pgsql

Concise and easy to remember. I love this repository.

edited Oct 3, 2017 at 19:34

answered Sep 8, 2016 at 15:37

Dylan Pierce

4,6883 gold badges41 silver badges49 bronze badges

2 Comments

Dylan Pierce Over a year ago

no probem, but the real thanks goes to ondrej. He/She made PHP installation so easy

james-see Over a year ago

This made it really easy, just did php7.3-pgsql. Cheers

Will · Accepted Answer · 2013-04-24 14:03:58Z

10

PDO driver for PostgreSQL is now included in the debian package php5-dev. The above steps using Pecl no longer works.

answered Apr 24, 2013 at 14:03

Will

2,02922 silver badges20 bronze badges

Comments

joan16v · Accepted Answer · 2017-02-10 12:28:02Z

3

If you are using PHP 5.6, the command is:

sudo apt-get install php5.6-pgsql

answered Feb 10, 2017 at 12:28

joan16v

5,1374 gold badges51 silver badges50 bronze badges

1 Comment

Ben Wilson Over a year ago

This was it for me -- spent several hours banging my head against the wall with: " [PDOException] could not find driver" in Laravel Homestead

Collectives™ on Stack Overflow

Install pdo for postgres Ubuntu

5 Answers 5

4 Comments

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

4 Comments

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related