Forums

possible to run a newer pg_dump?

Trying to use pg_dump to backup a PostreSQL server on another cloud.

pg_dump: server version: 11.3 (Ubuntu 11.3-1.pgdg18.04+1); pg_dump version: 9.4.19

pg_dump: aborting because of server version mismatch

Is it possible for me to install and use an upgraded pg_dump ? Thanks.

We have the pg_dump that matches the version of Postgres that we supply to our users, so we cannot upgrade it for you. However, you can do the pg_dump remotely on the machine in question because it will have the correct version of pg_dump for the server installed there:

ssh username@dbserver pg_dump books > books.out