SCRAM authentication requires libpq version 10 or above in

php postgresql enterprisedb
robby dwi hartanto picture robby dwi hartanto · Oct 18, 2019 · Viewed 10.4k times · Source

I get an error when I try to connect to the Postgresql server with PHP, and I get an error like this one:

Unable to connect to PostgreSQL server: SCRAM authentication requires libpq version 10 or above in

I use EnterpriseDb, and is pg_connect(); in my code and I don't know what is wrong.

Answer

robby dwi hartanto picture robby dwi hartanto · Oct 26, 2019

I got that error when I enabled only one extension extension=php_pgsql.dll in php.ini, I tried again uncomment extension=php_pdo_pgsql.dll , and it's worked well for me

Related questions

Cannot simply use PostgreSQL table name ("relation does not exist")

I'm trying to run the following PHP script to do a simple database query: $db_host = "localhost"; $db_name = "showfinder"; $username = "user"; $password = "password"; $dbconn = pg_connect("host=$db_host dbname=$db_name user=$username password=$password") or die('Could …

Read More
Laravel: Error [PDOException]: Could not Find Driver in PostgreSQL

I'm trying to connect with PostgreSQL database through Laravel in order to do a php artisan migrate but doesn't seem to be directed since it's reading the database name of MySQL. Here are the commands from database.php: 'connections' => …

Read More
How do I enable php to work with postgresql?

<?php try { $dbh = new PDO('pgsql:host=localhost;port=5432;dbname=###;user=###;password=##'); echo "PDO connection object created"; } catch(PDOException $e) { echo $e->getMessage(); } ?> I get the error message "Could Not Load Driver"

Read More