Postgres 14 version has an issue in establishing connection from Axpert

General

Last Post by Akshatha 2 years ago

1 Posts

1 Users

0 Likes

339 Views

RSS

Posts: 85

Akshatha

Admin

Topic starter

May 02, 2022 6:08 am

(@akshatha)

Reputable Member

Joined: 2 years ago

Root cause: PostgresSQL 14 uses the “scram-sha-256” method for authentication by default (as per pg_hba.conf file), which is causing the connectivity issues in Axpert.

Solution: The method “scram-sha-256” needs to be replaced with “trust” in pg_hba.conf file

This topic was modified 2 years ago 2 times by Akshatha

2 Forums
16.7 K Topics
16.9 K Posts
1 Online
3,165 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

PLATFORM

RESOURCES

THE COMPANY

Agile Developer is designed for introducing, instructing and training of Axpert developers for ease of use of the product. Although tutorials, references, and examples are regularly checked for inconsistencies, we can guarantee that the content is sufficiently and entirely accurate to the best of our knowledge with exceptions. You agree to have reading our terms of use and accepting them before using Agile Developer.