25

I was trying to make a backup in a server and I got the error:

pg_dump command not found

I thought that if you had postgres installed, it worked. What I have to do to install this command? I do not think that it is possible with apt-get or aptitude.

  • I believe pg_dump is part of the package postgresql-client-x.x, as well as a couple of other housekeeping utilities. Make sure you replace x.x by the proper version number for your server. – Jos Jul 22 '14 at 13:32
  • 7
    You need to install postgresql-client-common if you want it to be in the path. Either way it should be available in /usr/lib/postgresql/YOUR_PG_VERSION/bin/pg_dump (14.04) – Salem Jul 22 '14 at 13:43
  • 1
    Use package.ubuntu.com to find which package contains a given command/binary: – Sylvain Pineau Jul 22 '14 at 13:57
  • You've copied this from superuser.com/q/786363/167160. Please don't clone questions between sites, especially without linking between them. It wastes everyone's time. – Craig Ringer Jul 22 '14 at 14:09
43

For 14.04 you can just install postgresql-client (as it depends on postgresql-client-common):

sudo apt-get install postgresql-client

To quickly know which package contains a command/binary missing on your system, just use package.ubuntu.com (Search the contents of packages).

2

For those of you who get the same issue with PostgreSQL 10, you don't need to install additional packages; pg_dump is already there in postgres's bin directory. So you just need to append that bin path (e.g. /opt/PostgreSQL/10/bin) manually to the PATH environment variable.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.