Hi Team,
I am facing connectivity issue with PostgreSQL -13 , can you please suggest .
Error coming:
"PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: authentication method 10 not supported in
/var/www/html/myLavaUat/app/webroot/myLavaCronDirect/cron/mylava_stg_arch.php on line 9 "
DB "pg_hba.conf" Conf file setting is as below (172.16.40.32 is my application IP address).
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
#local all postgres peer
local all postgres ident
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all peer
host replication all 127.0.0.1/32 md5
host replication all ::1/128 md5
host replication replication 192.168.1.133/32 md5
host replication postgres 192.168.1.133/32 trust
host replication replication 192.168.1.138/32 md5
host replication postgres 192.168.1.138/32 trust
host replication replication 172.16.40.30/32 md5
host replication postgres 172.16.40.30/32 trust
host replication postgres 127.0.0.1/32 trust
host all all 0.0.0.0/0 md5
host replication replication 172.16.40.32/32 md5
host replication postgres 172.16.40.32/32 trust
Regards,
Ram Pratap.