Pg dump version different from server error - docker

Asked Jun 22 '23 at 04:36

Active Jun 22 '23 at 06:19

Viewed 45 times

I know this is an old question that has several answers on the web. I have been following the thread How to fix pg_dump version mismatch errors? But none of them seems to be working.

Issue:

pg_dump: error: server version: 14.5 (Debian 14.5-2.pgdg110+2); pg_dump version: 13.1

Additional info:

pg_dump --version
pg_dump (PostgreSQL) 13.1

which pg_dump
/usr/local/bin/pg_dump

echo $PATH
/Users/prajeeshb/.nvm/versions/node/v14.16.0/bin:/Users/prajeeshb/.rvm/gems/ruby-3.1.0/bin:/Users/prajeeshb/.rvm/gems/ruby-3.1.0@global/bin:/Users/prajeeshb/.rvm/rubies/ruby-3.1.0/bin:/Users/prajeeshb/.rvm/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/go/bin

I am using mac and i tried to put this at the top of .profile file

export PATH="/Applications/PostgreSQL\ 10/pgAdmin\ 4.app/Contents/MacOS/applet:$PATH"

and then run

. ~/.profile

and then opening a new window and run rails db:migrate, i am getting the same version mismatch error.

Any idea on how to fix this?

PS: I am running postgres on docker

edited Jun 22 '23 at 06:19

asked Jun 22 '23 at 04:36

prajeesh

2,202
6
34
59

Put the correct directory first in your path. I cannot tell you where you installed the binaries for PostgreSQL v14. – Laurenz Albe Jun 22 '23 at 05:44
@LaurenzAlbe I am running postgres on docker. Is there any command to find the binary installation path? – prajeesh Jun 22 '23 at 05:56
Sorry; you have to know where you installed PostgreSQL. I have no access to your machine. – Laurenz Albe Jun 22 '23 at 06:31
@LaurenzAlbe: the path is /usr/local/Cellar/postgresql/13.1 – prajeesh Jun 22 '23 at 08:20
But that's probably version 13. You need a `pg_dump` in version 14. – Laurenz Albe Jun 22 '23 at 09:47
@LaurenzAlbe i am using docker to run postgres. I have pulled an image recently and then issue occurs. The postgres that i have installed on my machine is only version 13. Is there anything that i am missing? – prajeesh Jun 23 '23 at 07:03
Install version 14 on the machine. – Laurenz Albe Jun 23 '23 at 09:59

Pg dump version different from server error - docker

0 Answers0