57

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.

Improve this question
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:
    – Sylvain Pineau
    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.
    – Craig Ringer
    Jul 22, 2014 at 14:09

2 Answers 2

Reset to default
89

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

Improve this answer
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
    – VasyaNovikov
    Jul 16, 2019 at 14:09
3

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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .