Command pg_dump not found?

Question

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
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
Use [package.ubuntu.com](http://packages.ubuntu.com/search?suite=trusty&arch=any&mode=exactfilename&searchon=contents&keywords=pg_dump) to find which package contains a given command/binary: — Sylvain Pineau, Jul 22 '14 at 13:57
You've copied this from http://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

score 89 · Accepted Answer · edited Nov 09 '16 at 14:13

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

edited Nov 09 '16 at 14:13

Jean Carlo Machado

103
4

answered Jul 22 '14 at 14:11

Sylvain Pineau

61,564
18
149
183

2

this also solves pg_restore not found error – Andrew Sep 18 '18 at 20:51
You may need to add the postgresql repository as indicated here: https://askubuntu.com/a/633923/259828 – douglaslps Feb 20 '19 at 17:04
On ArchLinux: `pacman -S postgresql` – VasyaNovikov Jul 16 '19 at 14:09

score 3 · Answer 2 · answered Nov 08 '17 at 04:04

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.

Command pg_dump not found?

2 Answers2