I have just started learning SQL and I am currently at the exercise Off Platform Project: Making a Database of Movies
I am using PostgreSQL (version 13) and Postbird (version 0.8.4).
Everything is going well except for the fact that I cannot export the database nor I can import the solution provided by Codecademy to double-check it.
When I go to the info section, I see this error message:
I googled a bit and I found this topic with a solution that I don’t fully understand:
And then I found several articles pointing out the password authentication from MD5 to SCRAM-SHA-256. I opened the configuration files of PostgreSQL (both postgreSQL.conf and pg_hba.conf) and saw the settings is SCRAM-SHA-256. Shall I change everywhere and put MD5 instead?
What I would like to understand is what the problem is also because I found very few examples and none with Postbird.
If you need extra info I forgot to mention, please let me know!