Move executables to /usr/local/pgsql/bin/

[Fred]

postgresql-client-common puts executable files in /usr/bin/, many of these are not even prefixed with pg which is kind of messy.
http://packages.ubuntu.com/zesty/all/postgresql-client-common/filelist

The Postgres documentation lists these in /usr/local/pgsql/bin/
https://www.postgresql.org/docs/9.6/static/install-short.html

Move the executables in the packages from /usr/bin/ to /usr/local/pgsql/bin/ to stay aligned with the official Postgres documentation. Also, I believe it is the recommended layout for packagers.

ProblemType: Bug
DistroRelease: Ubuntu 17.04
Package: postgresql-client-common 179
ProcVersionSignature: Ubuntu 4.10.0-19.21-generic 4.10.8
Uname: Linux 4.10.0-19-generic x86_64
ApportVersion: 2.20.4-0ubuntu4
Architecture: amd64
CurrentDesktop: GNOME-Classic:GNOME
Date: Wed Apr 12 18:44:55 2017
InstallationDate: Installed on 2013-12-26 (1202 days ago)
InstallationMedia: Ubuntu 13.10 "Saucy Salamander" - Release amd64 (20131016.1)
PackageArchitecture: all
SourcePackage: postgresql-common
UpgradeStatus: No upgrade log present (probably fresh install)

[Mario Splivalo (mariosplivalo)]

As per LSB and FHS (https://en.wikipedia.org/wiki/Filesystem_Hierarchy_Standard) /usr/local/ directory structure is used for locally (manually) installed files (which you might do, for instance, if you install postgres from source).

Putting package specific binaries in /usr/bin is a standard practice not followed just by Debian and Ubuntu.

[Fred (eldmannen+launchpad)]

How about /usr/bin/pgsql/, could that be considered?

Because now you get things such a /usr/bin/createuser which is rather confusing and easily mixed up with "adduser".