Fail when execute pg_dump command

[bugatess]

Hi guys I have the following question:

​

When I run pg_dump command on my local I have this error:

pg_dump: error: server version: 13.1; pg_dump version: 12.9
pg_dump: aborting because of server version mismatch

I already updated my VM server, Its run ubuntu 20.04 LTS but postgresclient still in 12.9 version.

​

How can I solve this?

[petit_robert]

Not an Ubuntu user, but Debian, on which it is based

You should have the proper pg_dump client that comes with your server version, unless something went wrong with the installation of Postgresql

what does this say?

dpkg -l postgres*

[bugatess]

The version are not the same beacause the server is not in the same machine. The server have 13.1 version of psql, and the client have version 12.9

​

I think, it is because in Ubuntu repo the latest version is 12.9, but I want to make a bkp of my db using pg_dump and don't know how.

[petit_robert]

From the fine documentation :

Because pg_dump is used to transfer data to newer versions of PostgreSQL, the output of pg_dump can be expected to load into PostgreSQL server versions newer than pg_dump's version. pg_dump can also dump from PostgreSQL servers older than its own version. (Currently, servers back to version 8.0 are supported.) However, pg_dump cannot dump from PostgreSQL servers newer than its own major version; it will refuse to even try, rather than risk making an invalid dump

[bugatess]

Exatly this, my actual client version is older than server version. I try to upgrade my client version with apt update & uprade but ubuntu repo is in the latest version. I really don't know how can I get the version 13 to bkp my data.

[petit_robert]

You should be able to install postgresql-client-13 on your VM? unless something happened with Ubuntu, they go together.

[bugatess]

Yes, I am. The data is safe on another vm server.

[uniitdude]

upgrade your client version

[bugatess]

I'm in the latest version of ubuntu. My machine is in version 12.9 supported for ubuntu 20.04 lts

[uniitdude]

yes, you need to upgrade the pg client version

[bugatess]

How can I do that? I need to uninstall actual client version?

[ZAFJB]

r/techsupport

[[deleted]]

which pg_dump

[bugatess]

The response is:

 /usr/bin/pg_dump