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.

Reply via email to