why php 8.1 don't have pgsql extendsion
aaP_shoeria7
use root user
- Edited
I performed all the processes above, I'm still having problems installing the extension.
I performed the above procedures, even so the error persists,
danleles
Hello, please describe your problem in detail.
- Edited
Hello aaPanel_Kern
I am facing issue with pgsql driver, encountered error
"message": "could not find driver (SQL: select count(*) as aggregate from \"users\" where \"email\" = user@gmail.com)",
I have installed pgsql extensions from app store but still not able to get it working also tried with this sudo apt install php-pgsql
still not working, My php version : 8.0
aaP_symentix_shubhamk
Hi, is there a relational database for pgsql? Is the configuration of the website correctly configured with pgsql?
Yes It is relational database for pgsql and the configuration in the website is done correctly
Hello, where did you install PostgreSQL from?
- Edited
From app store
Hello, it is recommended to check whether the relevant database exists using the command
Log in:
su - postgres
enter the database
psql
Check out the database:
\l
View all database information
SELECT * FROM pg_database ORDER BY datname;
quit
\q
- Edited
the Database i created is not listed here
DB created in PostgreSQL Manager and in DATABASE (sidebar menu) of aapnel
aaP_symentix_shubhamk
try
Database name and user name cannot start with numbers and cannot have special symbols
If the user name starts with a number, you will not be able to log in. \l View the Access privileges column without access rights.
The beginning of the database name is a number. You can see that it has been established on the interface. In fact, \l it seems that there is no database.
- Edited
aaP_symentix_shubhamk
Also i tried connecting with different DB outside the aapanel from aws rds still facing this issue.
I have checked for pgsql or pdo-pgsql is installed or not please check in the below snap it is not installed and in the app store it is showing that these extension are installed.
It is recommended that you check whether the database other than aapanel can be successfully connected?
The php module shows that the installation is successful
Yes i have connected with Mysql other than aapanel it is working. But when i connect with postgresql it is not connecting.
encountering error "message": "could not find driver (SQL: select count(*) as aggregate from \"users\" where \"email\" = user@gmail.com)",
issue with php-pgsql drivers
It is recommended that you use mysql for use
Could you please provide me ssh command to install php-pgsql extension/driver
We have postgres DB and already using in production env cannot change back mysql
aaP_symentix_shubhamk
install file:
/www/server/panel/install/pgsql.sh
hi i try to install extension pdo_pgsql 8.1 but stuck on y/n in this stage, like this figure