49

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.

4
  • 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, 2014 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, 2014 at 13:43
  • 1
    Use package.ubuntu.com to find which package contains a given command/binary: Jul 22, 2014 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. Jul 22, 2014 at 14:09

2 Answers 2

78

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).

3
  • 2
    this also solves pg_restore not found error
    – Andrew
    Sep 18, 2018 at 20:51
  • You may need to add the postgresql repository as indicated here: askubuntu.com/a/633923/259828
    – douglaslps
    Feb 20, 2019 at 17:04
  • On ArchLinux: pacman -S postgresql Jul 16, 2019 at 14:09
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.