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.

Zanna
  • 70,465
forvas
  • 775
  • 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 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

2 Answers2

90

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

Jean Carlo Machado
  • 103
  • 4
Sylvain Pineau
  • 62,169
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.

dnang
  • 131