Baseball awards exercise "psql: authentication method 10 not supported"

[blog3993955196]

Starting the “Best of Baseball awards” exercise and I’ve installed PostgreSQL version 17, PostBird, and the psql from the command line. I am only trying to import the sql file and get this error:

Select database 'Baseball'
psql: authentication method 10 not supported 
FAILURE

I have seen people get the same error but not in the context of my issue. I have tried reinstalling PostgreSQL, also tried running the psql.exe file numerous times but not getting the fix.

If you need more information to solve the issue please let me know. Thank you in advance for any help.

[lisalisaj]

I think it’s an issue w/the pw in the config file.

See:

Unable to connect to Postgres DB due to the authentication type 10 is not supported

Or, if that doesn’t work, check out this thread in the forums:

PostgreSQL + Postbird 'authentication method 10 not supported'

So after quite a few hours spent looking for a solution, here’s how I solved it Followed instructions in this video : ‘psql’ is not recognized as an internal or external command Followed @davbyron thread and replaced required fields + path : psql -U postgres -d baseball -f C:\Users\alexa\baseball_database.sql. More details in the original post Querying Baseball data off platform project - #40 by neoalexandre

[blog3993955196]

Thank you, and sorry for the late late reply. Despite attempts I found a very easy fix:

Downloading Postgres version 12.

Don’t know how that works but it works.

[lisalisaj]

Excellent. Was going to mention updating Postgres.