Re: Where is 'createdb'?

On 11/01/2012 08:41 AM, Kevin Burton wrote:
>
> I type 'find createdb' and I get an error find: 'createdb' no such
> file or directory.
>
>
Which exact OS/distribution/PostgreSQL-version are you using and how was
PostgreSQL installed (OS-provided or 3rd-party)? The different packagers
deal with things in a variety of ways almost all of which are different
than how PostgreSQL will be installed if compiling from source with
default options.

Ubuntu, for example, will typically include a (non-PostgreSQL-provided)
helper package called postgresql-common which is designed to ease
running multiple versions of PostgreSQL on a single machine. It also
allows different users to connect to different clusters and has some
version-to-version update facilities (which were more important in the
pre-pg_upgrade era).

In Ubuntu, therefore, executables, data and configuration are in
version-specific subdirectories (/usr/lib/postgresql/VERSION/...,
/etc/postgresql/VERSION/..., /var/lib/postgresql/VERSION/...) and
commands like "createdb" (/usr/bin/createdb) are actually links to
/usr/share/postgresql-common/pg_wrapper which loads the appropriate
user/version-specific executable (e.g.
/usr/lib/postgresql/9.1/bin/createdb).

But RHEL/CentOS has a somewhat different layout as do other
distributions and OSs and the layouts have evolved over time so what was
correct for, say, Ubuntu 9.04 will differ from 12.10. Similarly, a
general installer like EnterpriseDB's one-click installer will use a
different layout than the distribution-specific installations.

Cheers,
Steve