None of the supported PHP extensions (PgSQL, PDO_PgSQL) are available

postgresql pdo ubuntu-16.04 adminer
NjFern picture NjFern · Mar 2, 2017 · Viewed 9.4k times · Source

i have enabled extension=php_pdo_pgsql.dll and extension=php_pgsql.dll in my php.ini file but still unable to get adminer to work.

and also sudo service apache2 restart

Answer

NjFern picture NjFern · Mar 2, 2017 
sudo apt-get install php7.0-pgsql

 cd /etc/postgresql/9.5/main 

 sudo nano pg_hba.conf 

local   all             postgres                                peer

should be 

local   all             postgres                                md5

sudo service postgresql restart

then you good to go :)

Related questions

How do I enable php to work with postgresql?

<?php try { $dbh = new PDO('pgsql:host=localhost;port=5432;dbname=###;user=###;password=##'); echo "PDO connection object created"; } catch(PDOException $e) { echo $e->getMessage(); } ?> I get the error message "Could Not Load Driver"

Read More
Install pdo for postgres Ubuntu

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 …

Read More
Get last insert id after a prepared insert with PDO

I'm using PHP PDO with PostgreSQL for a new project. Given the following function, how can I return the id of the row just inserted? It doesn't work the way it looks now. function adauga_administrator($detalii) { global $db; $ultima_…

Read More