I can connect from MacOs development environment, but not from the Centos server.
However, I don't think these options should be necessary for Centos 7.4, PHP 7.4. CentOS 7 PostgreSQL 9. You could try running: rpm -Va -nofiles -nodigest And then connect to the PostgreSQL terminal (in the postgres role): psql.
Let’s switch into that system user: su postgres. Roles internal to Postgres (which are similar to users) match with a system user account. You could try using -skip-broken to work around the problem As part of the installation Postgres adds the system user postgres and is setup to use ident authentication. They said use command: yum install php-pgsqlīut this command will give me error for package conflict and list of required: Error: Package: php-pgsql-5.4.86_64 (base) I also tried other tutorials but most are for PHP 5 and not for PHP 7.4. I also tried installing PostgreSQL on the server, but I don't think I need since the connection is remote server. Checking phpinfo() page does not show PDO driver for PostgreSQL installed, and checking has no output for pgsql. I found another possible driver: yum install php72w-pdo I ran command to install driver: yum install php7.4-pgsql I get the error from PDO when trying to connect to PostgreSQL: Database Connection Error: could not find driver
0 kommentar(er)
