Hello! I have trouble with Off Platform Project: The Best Of Baseball Awards now.
The trouble is that I cannot load baseball_database.sql via Postbird. I use postgreSQL 13.
I opened baseball_database.sql, and ran Postbird. In order to connect to my database, I typed “localhost” in Host, “5432” in Port, “postgres” in Username, and “postgres” in Password (I set up my database following this page (Installing and Using PostgreSQL Locally)). After doing this, I connected to my database. I created new database named “baseball”. I clicked “Import .sql file” below “File” tab, and clicked baseball_database.sql. Then, a window named “Import Options” opened, set the “baseball” database, and clicked “Import File” button. However, an error message described below opened, and I cannot open the baseball database!
Select database ‘baseball’
psql: authentication method 10 not supported
I searched how to solve this message in Codecademy Forums and Google. I found one solution, but I cannot understand what this solution means.
To summarize up, in order to load baseball_database.sql via Postbird, what will I do?
I am not an English native (Japanese speaker), so it might be difficult to read my English. If you know an answer, I would appreciate if you could help me. Thank you.