8

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

NjFern
  • 161
  • 1
  • 1
  • 5
  • 1
    sudo is in UNIX , whereas .dll is windows . Can you confirm which OS are you on – Satya Mar 02 '17 at 04:52
  • Yes am on ubuntu even am surprised how the .dll packages version got installed. how do i revert? – NjFern Mar 02 '17 at 04:55
  • comment the line , look for php_pgsql.so and uncomment it – Satya Mar 02 '17 at 05:08
  • hi, satya i still dint find and .so files in my php.ini but i got it to work see answer below. can you tell me what i was missing? what should be my approach next time. – NjFern Mar 02 '17 at 05:16
  • just make sure, you follow install instructions as per the OS you are on :) – Satya Mar 02 '17 at 11:33

1 Answers1

6
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 :)

Satya
  • 8,693
  • 5
  • 34
  • 55
NjFern
  • 161
  • 1
  • 1
  • 5