I'm encountering an issue with my Laravel application where it's unable to connect to the PostgreSQL database, throwing the error "Illuminate\Database\QueryException: could not find driver".

Hello, please check if php has the pgsql extension installed? Also check whether the configured pgsql connection information is correct

I've installed ' PDO-PgSQL ' How to install PgSQL?

Hello, this seems to have been successfully installed. Please check whether the configured pgsql information is correct? Also check whether the relevant libraries and tables are normal? ianasystems

aaPanel_Kern only this one left. i must have to install this to resolve my application error. so please let me know how to install this ' PgSQL ' Database driven Thanks.

@aaPanel_Kern Please update. Thanks in advance.

aaPanel_Kern Hello, this seems to have been successfully installed. Please check whether the configured pgsql information is correct? Also check whether the relevant libraries and tables are normal?

Laravel Database Connection Error Could Not Find Driver pgsql

ianasystems

Check this image it's PHP 7.4 and its shwoing pgsql installed successfully.

now check this image it's php 8.1 and its showing pgsql not installed

aaPanel_Kern

Hello, if you cannot use php8.1 and php7.4 is available, it is recommended that you use php7.4
php8.1 is not supported, you can try to install it yourself

ianasystems

aaPanel_Kern

Thank you for the response.
PHP 8.1 is required for my application.

please let me know how ? you mentioned in this line - you can try to install it yourself

aaPanel_Kern

/www/server/panel/install/pgsql.sh
You can refer to this script

ianasystems

aaPanel_Kern

ianasystems please let me know how ? you mentioned in this line - you can try to install it yourself

aaPanel_Kern /www/server/panel/install/pgsql.sh
You can refer to this script

ianasystems

aaPanel_Kern

and before run this script /www/server/panel/install/pgsql.sh, i must have to install pgsql manager ' app store ' ?
right?
please confirm only this.

thanks in advance.

ianasystems

aaPanel_Kern

Please check.

/www/server/panel/install# ls check.sh fileinfo.sh imagemagick.sh intl.sh lib.sh mysql.sh package.xml pdo_sqlsrv.sh php.sh public.sh redis.sh exif.sh gmp.sh install_soft.sh ioncube.sh mail_sys.sh nginx.sh pdo_pgsql.sh phpmyadmin.sh pm2.sh pureftpd.sh
It seems that the pgsql.sh script is not present in the directory.

ianasystems

aaPanel_Kern

please share with me download link for the PHP PostgreSQL extension package compatible with PHP 8.1 & aaPanel.

I will download the source with wget into this directory /www/server/panel/install/pgsql.sh then i will install.

Thank you.

ianasystems

i also found this link please confirm me this method still work?

https://www.aapanel.com/forum/d/13370-why-php-81-dont-have-pgsql-extendsion

aaPanel_Kern

Hello, I suggest you try it yourself to see if you can successfully install it.

ianasystems

aaPanel_Kern

Finally I've done.
PgSQL For PHP 8.1 using this method.
https://www.aapanel.com/forum/d/13370-why-php-81-dont-have-pgsql-extendsion

version=81 echo $version cd /www/server/php/$version/src/ext/pgsql /www/server/php/$version/bin/phpize ./configure --with-php-config=/www/server/php/$version/bin/php-config --with-pgsql=/www/server/pgsql make && make install extFile='/www/server/php/$version/lib/php/extensions/no-debug-non-zts-20210902/pgsql.so' echo -e "extension = " ${extFile} >> /www/server/php/$version/etc/php.ini echo -e "extension = " ${extFile} >> /www/server/php/$version/etc/php-cli.ini /etc/init.d/php-fpm-$version reload

Thanks Dear @aaPanel_Kern

« Previous Page