pg_dump: error: server version: 14.0; pg_dump version: 12.0

[adamzerner]

Hey guys, I am getting set up with postgres for the first time. I used https://postgresapp.com/ to start the server and it seems like all is good there. Then in Postbird, I used the following connection:

It works when I click "Connect". I then created a new database called calibration-training (for a side project I am working on). Then I created a table called Test, added a column to that table called name (varchar), and added a single record with an id of 1 and a name of first. It looks like it worked.

But then when I tried to retrieve the record via my Node.js app, I got an error. So I started investigating, and in doing so I clicked the "Info" tab and found this:

So I'm getting this error:

Loading...Error happen while running pg_dump:
pg_dump: error: server version: 14.0; pg_dump version: 12.0
pg_dump: error: aborting because of server version mismatch

This is where I am totally lost. When I go to the command line, it looks like I don't have that executable, so I don't know how to proceed.

code/calibration-training-api [master●] » pg_dump
zsh: command not found: pg_dump

Any tips?

[anthonydb]

Hi, I don't work on this project but noticed your note. When you set up Postgress.app, did you set up the command line tools using step 3 on the main page? https://postgresapp.com/

[adamzerner]

@anthonydb Thanks for the help! Yes, I did run that command. I just ran it again too and get the following output.

code/calibration-training-api [master] » sudo mkdir -p /etc/paths.d &&
echo /Applications/Postgres.app/Contents/Versions/latest/bin | sudo tee /etc/paths.d/postgresapp
Password:
/Applications/Postgres.app/Contents/Versions/latest/bin

It didn't fix the problem I am having though.

[adamzerner]

Nevermind, I decided to go with a different Postgres GUI instead.

[maticrivo]

@adamzerner I'm facing the same issue, what Postgres GUI are you using instead?