1

Im using the Perl module DBD::pg to connect to Postgres

DBI connect('dbname=db;host=host;port=5432','user',...) failed: authentication method 10 not supported

#connect to database
my $dbh = DBI->connect("dbi:Pg:dbname=$dbname;host=$host;port=$port",
                    $username,
                    $password
                   );
richyen
  • 8,114
  • 4
  • 13
  • 28
Joycel
  • 19
  • 2
  • If you have the latest DBD::Pg, you should probably file a bug report. – choroba Oct 04 '19 at 13:52
  • @choroba makes sense lol – Joycel Oct 04 '19 at 14:03
  • @Joycel can you share some of your `pg_hba.conf` and the subroutine you are using to call `DBI->connect`? – richyen Oct 04 '19 at 17:32
  • 1
    Issue resolved for my case had to download latest lib files from pg v.12, install them in the C:\Strawberry\c\bin, then run the following commands in the directory:pexports libpq.dll > libpq.def dlltool -dllname libpq.dll --def libpq.def --output-lib ..\lib\libpq.a the files are the following: libiconv-2.dll libcrypto-1_1-x64.dll libpq.dll libssl-1_1-x64.dll libintl-8.dll – Joycel Oct 04 '19 at 19:09
  • Does this answer your question? [PostgreSQL authentication method 10 not supported](https://stackoverflow.com/questions/64474420/postgresql-authentication-method-10-not-supported) – miken32 Dec 01 '21 at 23:33

0 Answers0