From: | Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in> |
---|---|
To: | "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | PostgreSQL server: authentication method 10 not supported |
Date: | 2021-11-30 09:44:29 |
Message-ID: | KL1PR0601MB443359DA32D68F49E51DF7F6F0679@KL1PR0601MB4433.apcprd06.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Fan | 2021-11-30 09:47:46 | Re: Can I assume relation would not be invalid during from ExecutorRun to ExecutorEnd |
Previous Message | Daniel Gustafsson | 2021-11-30 09:39:27 | Re: Update stale code comment in CheckpointerMain() |