# Supported authentication types for postgres jdbc driver **URL:** \ **Category:** Ignition\ **Tags:** database\ **Created:** [November 19, 2020, 2:54pm UTC](https://forum.inductiveautomation.com/t/supported-authentication-types-for-postgres-jdbc-driver/40801 "2020-11-19T14:54:18Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![iamthebull](https://avatars.discourse-cdn.com/v4/letter/i/58f4c7/32.png) [@iamthebull](https://forum.inductiveautomation.com/u/iamthebull)\ **Post date:** [November 19, 2020, 2:54pm UTC](https://forum.inductiveautomation.com/t/supported-authentication-types-for-postgres-jdbc-driver/40801/1 "2020-11-19T14:54:18Z")
I’m setting up a new installation with Ignition 8.1.0 (b2020110211). My connection to PostgreSQL database (v13.1) is faulted and the error message is: ```auto Cannot create PoolableConnectionFactory (The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.) ``` Ignition and PostgreSQL are installed on the same machine. My pg\_hba.conf file includes: ```auto # IPv4 local connections: host all all 127.0.0.1/32 scram-sha-256 ``` Does the pg jdbc driver not support scram-sha-256? What types are supported? Is this documented somewhere? ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [November 19, 2020, 3:00pm UTC](https://forum.inductiveautomation.com/t/supported-authentication-types-for-postgres-jdbc-driver/40801/2 "2020-11-19T15:00:48Z")
What version of the PG JDBC driver are you using? Seems you need at least 42.2.0 to use scram-sha-256. [https://wiki.postgresql.org/wiki/List\_of\_drivers](https://wiki.postgresql.org/wiki/List_of_drivers) ---
**Author:** ![iamthebull](https://avatars.discourse-cdn.com/v4/letter/i/58f4c7/32.png) [@iamthebull](https://forum.inductiveautomation.com/u/iamthebull)\ **Post date:** [November 19, 2020, 3:08pm UTC](https://forum.inductiveautomation.com/t/supported-authentication-types-for-postgres-jdbc-driver/40801/3 "2020-11-19T15:08:09Z")
Where does it show the driver version? ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [November 19, 2020, 3:09pm UTC](https://forum.inductiveautomation.com/t/supported-authentication-types-for-postgres-jdbc-driver/40801/4 "2020-11-19T15:09:57Z")
I think you have to look at the JAR file in `$IGNITION/user-lib/jdbc`. It looks like new installs of 8.x should have 42.2.5 but if you upgraded from an older version of Ignition you will still have whatever the previous JDBC driver was. ---
**Author:** ![iamthebull](https://avatars.discourse-cdn.com/v4/letter/i/58f4c7/32.png) [@iamthebull](https://forum.inductiveautomation.com/u/iamthebull)\ **Post date:** [November 19, 2020, 3:14pm UTC](https://forum.inductiveautomation.com/t/supported-authentication-types-for-postgres-jdbc-driver/40801/5 "2020-11-19T15:14:42Z")
It’s a new installation of 8.1. In `$IGNITION/user-lib/jdbc` there is: `postgresql-9.1-901.jdbc4.jar` ---
**Author:** ![iamthebull](https://avatars.discourse-cdn.com/v4/letter/i/58f4c7/32.png) [@iamthebull](https://forum.inductiveautomation.com/u/iamthebull)\ **Post date:** [November 19, 2020, 3:17pm UTC](https://forum.inductiveautomation.com/t/supported-authentication-types-for-postgres-jdbc-driver/40801/6 "2020-11-19T15:17:57Z")
I also changed the method to `md5` and that did not help. And it still shows the same authentication type in the error. I would have expected that to change. ---
**Author:** ![iamthebull](https://avatars.discourse-cdn.com/v4/letter/i/58f4c7/32.png) [@iamthebull](https://forum.inductiveautomation.com/u/iamthebull)\ **Post date:** [November 19, 2020, 3:26pm UTC](https://forum.inductiveautomation.com/t/supported-authentication-types-for-postgres-jdbc-driver/40801/7 "2020-11-19T15:26:51Z")
Do you know which connection type corresponds to type 10? ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [November 19, 2020, 3:46pm UTC](https://forum.inductiveautomation.com/t/supported-authentication-types-for-postgres-jdbc-driver/40801/8 "2020-11-19T15:46:09Z")
> [@iamthebull](#): > > postgresql-9.1-901.jdbc4.jar Huh, well that's an ancient version. Get the latest from here and install it: [https://jdbc.postgresql.org/download.html](https://jdbc.postgresql.org/download.html) ---
**Author:** ![iamthebull](https://avatars.discourse-cdn.com/v4/letter/i/58f4c7/32.png) [@iamthebull](https://forum.inductiveautomation.com/u/iamthebull)\ **Post date:** [November 19, 2020, 3:55pm UTC](https://forum.inductiveautomation.com/t/supported-authentication-types-for-postgres-jdbc-driver/40801/9 "2020-11-19T15:55:18Z")
Does restoring a gateway from a backup restore the drivers to earlier versions? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [November 19, 2020, 4:01pm UTC](https://forum.inductiveautomation.com/t/supported-authentication-types-for-postgres-jdbc-driver/40801/10 "2020-11-19T16:01:47Z")
Yes. You must upgrade the JDBC drivers after restoring an old backup.