PostgreSQL + Postbird 'authentication method 10 not supported'

Data Science
1

Hello everybody,

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:

Cattura
Cattura1831×445 46.5 KB

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!

Thanks
Marina

4 Likes
2

I have not attempted this particular course yet so I’m not sure how much help I could be. (I’ve also only used PgAdmin as a GUI w/PostgreSQL).

If you’ve googled the error messages and determined that you should change your pw authentication settings, then I suggest trying it. (you can always change it back if it doesn’t work).
I found this:
https://github.com/dbeaver/dbeaver/issues/2122

And the PostgreSQL documentation on authentication methods might help:

2 Likes
3

Hello Lisa,

just tried that and still does not work… When I try to export the database I get this message

image
image1008×434 17 KB

It says that it saved the file but I find no file. However, though I am not sure this is related, when I open pgAdmin I see the same databases created with Postbird and from there I can export the tables I created.

In a way or another, I manage to do what I need to for now but I still wonder what is wrong…

1 Like
4

I have the exact same errors. Since I’ve just started exploring PostgreSQL, I don’t exactly know what the info tab does. However, not able to import/export a .sql file onto Postbird is a bummer:)

1 Like
5

Hi Marina!

Had the same issue here. I fixed it by downgrading to PostgreSQL version 12.

I’m sure you’ve fixed it by now, just writing it for posterity.
Best

2 Likes
6

This post was first open in Dec 2020.
I joined amonth ago (May 2021) and cannot find a suitable solution to this problem.
I already uninstalled/re-installed postbird/postgres, used different versions and can’t use that baseball database at all.

After looking into other forum topics for the same issue, I see no clear answer on how to resolve this “method 10 is not supported”.

Has anyone found a clear solution ?

1 Like
7

So after quite a few hours spent looking for a solution, here’s how I solved it :slight_smile:

  1. Followed instructions in this video : ‘psql’ is not recognized as an internal or external command
  2. 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
9 Likes
8

open the file pg_hba.conf and in the end of the file, put “trust” value in METHOD

TYPE DATABASE USER ADDRESS METHOD

“local” is for Unix domain socket connections only

local all all trust

IPv4 local connections:

host all all 127.0.0.1/32 trust

IPv6 local connections:

host all all ::1/128 trust

Allow replication connections from localhost, by a user with the

replication privilege.

local replication all trust
host replication all 127.0.0.1/32 trust
host replication all ::1/128 trust

31 Likes
9

Thanks for your help. This solves the issue.

1 Like
10

Hello, I had issues importing the data.

SOLUTION
I downgraded from version 13.0 to 12.7.

1 Like
11

I’m curious as to what consequences these changes might have (I’ll see if I can figure it out in the documentation), but this is the first solution that worked for me! Thanks!

Note: I had not yet conceded to installing PostgreSQL 12, but that was my next step.

1 Like
12

I have the same problem. I cannot import .sql files, and I cannot export .sql files because

image
image1366×768 39.2 KB

1 Like
13

I also had this issue. What I did was installing the listed alternative, pgAdmin 4, to export my Postgres database.
Although the interface is more cluttered, you just have to right click on database and chose “Backup” and “Restore”.

I think this is an easy work-around.

2 Likes
14

This solved the “authentication method 10 not supported” error.
Arigatou!

Now I have an issue of mismatched pg_dump - postgres server version

1 Like
15

I had the same problem.
I downgraded postgreSQL to 12.9, keeping the Postbird the same and the issue was solved.

1 Like
16

amazing - thank you so much!!!

17

Worked for me too! <3

18

Excellent info.

Thanks!

19

Import was a success after making these changes. Thank you!

I’m on Postgres 14.

20

Thanks a lot, the import worked!