Postgresql 9 2 pg dump version mismatch

Question

I am trying to dump a Postgresql database using the pg dump tool      pg dump books  gt  books out   How ever i am getting this error    pg dump  server version  9 2 1  pg dump version  9 1 6 pg dump  aborting because of server version mismatch   The --ignore-version option is now deprecated and really would not be a a solution to my issue even if it had worked   How can I upgrade pg dump to resolve this issue

User · Answer

The answer sounds silly but if you get the above error and wanna run the pg_dump for earlier version go to bin directory of postgres and type

./pg_dump servername > out.sql ./ ignores the root and looks for pg_dump in current directory

User · Answer

As explained  this is because your postgresql is in old version -  update it For Mac via homebrew   brew tap petere postgresql    brew install  lt formula gt   eg  brew install petere postgresql postgresql-9 6   Remove old postgre   brew unlink postgresql  brew link -f postgresql-9 6  If any error happen  don t forget to read and follow brew instruction in each step   Check this out for more  https   github com petere homebrew-postgresql

User · Answer

Download the appropriate postgres version here   https   www postgresql org download   Make sure to run the following commands  the postgresql org download URL will generate the specific URL for you to use  the one I use below is just an example for centos 7  as sudo   sudo yum install https   download postgresql org pub repos yum reporpms EL-7-x86 64 pgdg-redhat-repo-latest noarch rpm sudo yum install postgresql11-server   your pg dump version should now be updated  verify with pg dump -V

User · Answer

You can just locate pg dump and use the full path in command   locate pg dump   usr bin pg dump  usr bin pg dumpall  usr lib postgresql 9 3 bin pg dump  usr lib postgresql 9 3 bin pg dumpall  usr lib postgresql 9 6 bin pg dump  usr lib postgresql 9 6 bin pg dumpall   Now just use the path of the desired version in the command   usr lib postgresql 9 6 bin pg dump books  gt  books out

User · Answer

If the database is installed on a different machine it has probably correct version of pg dump installed  This means that you can execute pg dump command remotely with SSH     ssh username dbserver pg dump books   books out  You can also use public key authentication for passwordless execution  Steps to achieve that    Generate  if not yet done  a pair of keys with ssh-keygen command   Copy the public key to the database server  usually     ssh authorized keys  Test if the connection works with ssh command

User · Answer

On my scenario the production version was 12  and my development version was 11  upgrading the package postgresql-client-xx was enough to solve my incident  Reference web page   https   www postgresql org download linux ubuntu  sudo apt-get update  amp  amp  sudo apt-get -y upgrade postgresql-client  One interest thing to point out is that after the upgrade the previous version kept installed   mlazo mlazo-pc    dpkg -l  grep -i postgresql-client ii  postgresql-client-11                                             11 8-1 pgdg18 04 1                                  amd64        front-end programs for PostgreSQL 11 ii  postgresql-client-12                                             12 4-1 pgdg18 04 1                                  amd64        front-end programs for PostgreSQL 12   Hope my experience would be helpful to someone  Greetings

User · Answer

An alternative answer that I don t think anyone else has covered   If you have multiple PG clusters installed  as I do   then you can view those using pg lsclusters   You should be able to see the version and cluster from the list displayed   From there  you can then do this   pg dump --cluster 9 6 main books  gt  books out   Obviously  replace the version and cluster name with the appropriate one for your circumstances from what is returned by pg lsclusters separating the version and cluster with a    This targets the specific cluster you wish to run against

User · Answer

If you re on Ubuntu  you might have an old version of postgresql-client installed   Based on the versions in your error message  the solution would be the following   sudo apt-get remove postgresql-client-9 1 sudo apt-get install postgresql-client-9 2

User · Answer

On Ubuntu you can simply add the most recent Apt repository and then run   sudo apt-get install postgresql-client-11

User · Answer

after install postgres version is match 9 2  Create a symbolic link or new shortcut    - on   usr bin   syntag is   sudo ln -s  path for use   new shortcut name    example  sudo ln -s  usr lib postgresql 9 2 bin pg dump new pg dump   -- how to call   new pg dump -h 192 168 9 88 -U postgres database

User · Answer

I encountered this while using Heroku on Ubuntu  and here s how I fixed it    Add the PostgreSQL apt repository as described at  Linux downloads  Ubuntu      There are similar pages for other operating systems   Upgrade to the latest version  9 3 for me  with    sudo apt-get install postgresql  Recreate the symbolic link in  usr bin with   sudo ln -s  usr lib postgresql 9 3 bin pg dump  usr bin pg dump --force   The version number in the  usr lib postgresql     path above should match the server version number in the error you received  So if your error says  pg dump  server version  9 9  then link to  usr lib postgresql 9 9

User · Answer

For macs  use find   -name pg dump -type f 2 gt  dev null find the location of pg dump  For me  I have following results   Applications Postgres app Contents Versions 9 5 bin pg dump  usr local Cellar postgresql 9 4 5 2 bin pg dump   If you don t want to use sudo ln -s new pg dump old pg dump --force  just use   Applications Postgres app Contents Versions 9 5 bin pg dump to replace with pg dump in your terminal  For example   Applications Postgres app Contents Versions 9 5 bin pg dump books  gt  books out   It works for me

User · Answer

You can either install PostgreSQL 9 2 1 in the pg dump client machine or just copy the  PGHOME from the PostgreSQL server machine to the client machine  Note that there is no need to initdb a new cluster in the client machine   After you have finished installing the 9 2 1 software  remember to edit some environment variables in your  bash profile file

User · Answer

For those running Postgres app    Add the following code to your  bash profile   export PATH  Applications Postgres app Contents Versions latest bin  PATH  Restart terminal

User · Answer

If you re using Heroku s Postgres app the pg dump  along with all the other binaries  is in  Applications Postgres app Contents MacOS bin   so in that case it s   ln -s  Applications Postgres app Contents MacOS bin pg dump  usr local bin pg dump   or   ln -s  Applications Postgres app Contents MacOS bin    usr local bin     to just grab them all

User · Answer

For Macs with Homebrew  I had this problem when fetching the db from Heroku  I ve fixed it just running   brew upgrade postgresql

User · Answer

For me the issue was updating psql apt-get wasn t resolving newer versions  even after update  The following worked   Ubuntu  Start with the import of the GPG key for PostgreSQL packages   sudo apt-get install wget ca-certificates wget --quiet -O - https   www postgresql org media keys ACCC4CF8 asc   sudo apt-key add -   Now add the repository to your system   sudo sh -c  echo  deb http   apt postgresql org pub repos apt   lsb release -cs -pgdg main   gt  gt   etc apt sources list d pgdg list    Install PostgreSQL on Ubuntu  sudo apt-get update sudo apt-get install postgresql postgresql-contrib   https   www postgresql org download linux ubuntu

User · Answer

I had same error and this is how I solved it in my case   This means your postgresql version is 9 2 1 but you have started postgresql service of 9 1 6   If you run psql postgres you will see   psql  9 2 1  server 9 1 6   What I did to solve this problem is    brew services stop postgresql 9 1 6 brew services restart postgresql 9 2 1   Now run psql postgres and you should have  psql  9 2 1   You can also run brew services list to see the status of your postgres

User · Answer

First step  see if postgres has a repository with prebuilt binaries for the version you want for your OS  https   www postgresql org download  If that doesn t work  for instance if your distro is there but is no longer supported  so correct binaries aren t provided for it   or if you just want to go straight or the source and not have to worry about adding remote repo s  etc  What I did is download the raw source of postgres for the desired version  Untar it  cd into it  build it   configure  amp  amp  make  then  postgresql-12 3   find   -name pg dump   src bin pg dump pg dump     src bin pg dump pg dump   unable to load libpg so 5   if it says this      find   -name libpg so 5   export LD LIBRARY PATH  your path to the shared dir of above file      src bin pg dump pg dump   works now  Now you have access to any version that builds on your box   Which should be any

User · Answer

Macs have a builtin  usr bin pg dump command that is used as default   With the postgresql install you get another binary at  Library PostgreSQL  lt version gt  bin pg dump

User · Answer

Try that    export PATH  usr local bin  PATH

User · Answer

Every time you upgrade or re install a new version of PostgreSQL  a latest version of  pg dump   is installed    There must be  a  PostgreSQL bin   directory somewhere on your system  under the latest version of PostgreSQL that you ve installed   9 2 1 is latest  and try running the   pg dump  from in there

User · Answer

Check the installed version s  of pg dump   find   -name pg dump -type f 2 gt  dev null  My output was    usr pgsql-9 3 bin pg dump  usr bin pg dump  There are two versions installed  To update pg dump with the newer version   sudo ln -s  usr pgsql-9 3 bin pg dump  usr bin pg dump --force    This will create the symlink to the newer version

User · Answer

For mac users put to the top of  profile file   export PATH   Applications Postgres app Contents MacOS bin  PATH    then run        profile

User · Answer

I experienced a similar problem on my Fedora 17 installation  This is what I did to get around the issue   Delete the builtin pg dump at  usr bin pg dump  as root   rm  usr bin pg dump   Now make a symbolic link of the postgresql installation  Again as root ln -s  usr pgsql-9 2 bin pg dump  usr bin pg dump   That should do the trick

User · Answer

Well  I had the same issue as I have two postgress versions installed   Just use the proper pg dump and you don t need to change anything  in your case       gt   usr lib postgresql 9 2 bin pg dump books  gt  books out

User · Answer

If you have docker installed you can do something like     docker run postgres 9 2 pg dump books  gt  books out  That will download the Docker container with Postgres 9 2 in it  run pg dump inside of the container  and write the output

[postgresql] Postgresql 9.2 pg_dump version mismatch

Examples related to postgresql

Examples related to backup

Examples related to pg-dump

Examples related to postgresql-9.2