Laravel Deployment : PHP Error Unable to load dynamic library 'pdo_pgsql'

Question

I want to deploy my laravel app in ubuntu server 18 LTS. So I have install nginx postgres php. But when i try to do php artisan migrate I have this returned error :

This is the errror (a picture beacose of comande line) .

So I have verify different thing : First I can access to my data base in localhost with the postgres user. The laravel app work while database not be required.

In php.ini I have uncomment extention=pdo-pgsql; and extention=pgsql

I have install the php postgres sql extension with this command sudo apt-get install php7.2-pgsql

And this is my .env settings for database in laravel :

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5433
DB_DATABASE=THERY //I have already create the database
DB_USERNAME=postgres
DB_PASSWORD=postgres

Try DB_HOST=localhost instead of DB_HOST=127.0.0.1 in your .env. — Qumber
– Qumber, Commented Feb 19, 2020 at 8:14

Sajidur Rahman · Accepted Answer · 2022-05-26 22:00:28Z

3

So for my problem they have two solution plus a bonus

If the problem come from php and you don't want to reinstall all you can follow this topic here in ask ubuntu and use this two command :

sudo apt-get --purge remove php-common

sudo apt-get install php-common php-pgsql php-cli

If you want to correctly install php for laravel with postgresql you can use this comandes:

#php install comande
sudo apt-get install php-fpm openssl php-common php-curl php-json php-mbstring php-xml php-zip php-pgsql

#make sure to uncomment extension=pdo_pgsql
sudo nano /etc/php/7.2/fpm/php.ini 

#restart fpm service to apply settings
sudo systemctl restar php7.2-fpm

Finally if you have an [SQLSTATE 08006 error] check if the port in .env file in your laravel app correspond to the listened port in your server (form me the used port is 5432 and not 5433)

edited May 26, 2022 at 22:00

Sajidur Rahman

3,0801 gold badge32 silver badges28 bronze badges

answered Feb 20, 2020 at 11:29

MrSolarius

79915 silver badges33 bronze badges

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

Comments

S K R · Accepted Answer · 2020-02-19 09:22:50Z

1

There may be different issues for your problem. Any of the below may be occured:

php PGsql is not installed. install it by

apt-get install php-pgsql

PGsql library is missing in the composer. install it by

composer require asmiarowski/laravel-postgres // There are multiple librariies available in packagist

Your config in .env are not cached. you can cache them by running command

php artisan config:cache

Your PGSql server is not reachable. you can take further action to resolve them.

edited Feb 19, 2020 at 9:22

answered Feb 19, 2020 at 8:55

S K R

6021 gold badge4 silver badges17 bronze badges

6 Comments

MrSolarius Over a year ago

linux don't find php7.3-pgsql It work if I use 7.2 ?

S K R Over a year ago

You can install "php-pgsql" or "php7.2-pgsql (if your PHP version is 7.2)" to use system reliable pgsql according to the installed PHP version. the answer was for representational purposes.

S K R Over a year ago

@MrSolarius What is your PHP version on CLI and on WebServer(Apache) ?

MrSolarius Over a year ago

That have not work I have this return error

Unable to load dynamic library "pdo_pgsql' (tried: /usr/lib/php/20170718/pdo_pgsql (/usr/llb/php/20170718/pdo_pg /usr/lib/php/20170718/pdo_pgsql.so: undefined symbol: pdo parse_params)) in Unknown on line o PHP Warning: Module 'pgsql" already loaded in Unknown on line 0

S K R Over a year ago

apt-get install php-pgsql should resolve the issue. can you paste a snapshot of phpinfo() page ?

|

Collectives™ on Stack Overflow

Laravel Deployment : PHP Error Unable to load dynamic library 'pdo_pgsql'

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related