CODEWITHSUNDEEP
sqldatabasepostgresqlimportbackend
Tanmay Patel
Tanmay Patel

Reputation: 33

Error importing database in PostgreSQL: 'psql: authentication method 10 not supported" FAILURE'

I am a total beginner. I'm trying to import a database (named "baseball_database.sql") on postgreSQL, with Postbird client, but I'm getting an import error: "psql: authentication method 10 not supported" FAILURE

I tried reinstalling the latest versions of both many times, Postbird (v0.8.4) and Postgres (Version 14), and also tried it with 3 different databases, but got the same error every time.

Below are the error and the specs, in case required:

Error

Specs

Specs 2 Specs 3

Upvotes: 0

Views: 1375

Answers (1)

jjanes
jjanes

Reputation: 44167

Postbird seems to come bundled with those scarily ancient versions of psql.exe and pg_dump.exe. I would ponder whether I really want to use such a poorly organized product.

You can find the locations of those binaries in the postbird program directory, and over-write them with the ones from your modern installation. Or you could change your database to use md5 authentication rather than SCRAM. Or just not use Postbird.

Upvotes: 3

Related Questions