Re: BUG #12187: Cant find the postgresql-client installation by yum install

On Dec 10, 2014, at 7:55 AM, wangzhipengkmust(at)126(dot)com wrote:

> The following bug has been logged on the website:
>
> Bug reference: 12187
> Logged by: Grady
> Email address: wangzhipengkmust(at)126(dot)com
> PostgreSQL version: 9.3.5
> Operating system: Red hat 6.5
> Description:
>
> Hi Master
> I successfully installed postgresql-9.3.5. I used common: "yum install
> postgresql93*". But there are not postgresql93-client are installed. I read
> the offical webiste. It mentioned the client package exist.
> Attached the installed information as below:
>
> Installed:
> postgresql93.x86_64 0:9.3.5-1PGDG.rhel6
> postgresql93-contrib.x86_64 0:9.3.5-1PGDG.rhel6
> postgresql93-debuginfo.x86_64 0:9.3.5-1PGDG.rhel6
> postgresql93-devel.x86_64 0:9.3.5-1PGDG.rhel6
> postgresql93-docs.x86_64 0:9.3.5-1PGDG.rhel6
> postgresql93-jdbc.x86_64 0:9.3.1101-1PGDG.rhel6
> postgresql93-jdbc-debuginfo.x86_64 0:9.3.1101-1PGDG.rhel6
> postgresql93-libs.x86_64 0:9.3.5-1PGDG.rhel6
> postgresql93-odbc.x86_64 0:09.03.0300-1PGDG.rhel6
> postgresql93-odbc-debuginfo.x86_64 0:09.03.0300-1PGDG.rhel6
> postgresql93-plperl.x86_64 0:9.3.5-1PGDG.rhel6
> postgresql93-plpython.x86_64 0:9.3.5-1PGDG.rhel6
> postgresql93-pltcl.x86_64 0:9.3.5-1PGDG.rhel6
> postgresql93-python.x86_64 0:4.1.1-1PGDG.rhel6
> postgresql93-python-debuginfo.x86_64 0:4.1.1-1PGDG.rhel6
> postgresql93-server.x86_64 0:9.3.5-1PGDG.rhel6
> postgresql93-test.x86_64 0:9.3.5-1PGDG.rhel6
>
>

If you look at the output of:

rpm -ql postgresql93

You'll see that the client binaries are installed in /usr/pgsql-9.3/bin:

$ rpm -ql postgresql93
/usr/pgsql-9.3/bin/clusterdb
/usr/pgsql-9.3/bin/createdb
/usr/pgsql-9.3/bin/createlang
/usr/pgsql-9.3/bin/createuser
/usr/pgsql-9.3/bin/dropdb
/usr/pgsql-9.3/bin/droplang
/usr/pgsql-9.3/bin/dropuser
/usr/pgsql-9.3/bin/pg_basebackup
/usr/pgsql-9.3/bin/pg_config
/usr/pgsql-9.3/bin/pg_dump
/usr/pgsql-9.3/bin/pg_dumpall
/usr/pgsql-9.3/bin/pg_isready
/usr/pgsql-9.3/bin/pg_receivexlog
/usr/pgsql-9.3/bin/pg_restore
/usr/pgsql-9.3/bin/pg_test_fsync
/usr/pgsql-9.3/bin/psql
/usr/pgsql-9.3/bin/reindexdb
/usr/pgsql-9.3/bin/vacuumdb

You should also find the common ones lke psql, createdb, vacuumdb, etc in /usr/bin via the 'alternatives' mechanism.

If for some reason they are not in /usr/bin, you can put them there the same way the rpm scriptlet does like so:

/usr/sbin/update-alternatives --install /usr/bin/psql pgsql-psql /usr/pgsql-9.3/bin/psql 930
/usr/sbin/update-alternatives --install /usr/bin/clusterdb pgsql-clusterdb /usr/pgsql-9.3/bin/clusterdb 930
/usr/sbin/update-alternatives --install /usr/bin/createdb pgsql-createdb /usr/pgsql-9.3/bin/createdb 930
/usr/sbin/update-alternatives --install /usr/bin/createlang pgsql-createlang /usr/pgsql-9.3/bin/createlang 930
/usr/sbin/update-alternatives --install /usr/bin/createuser pgsql-createuser /usr/pgsql-9.3/bin/createuser 930
/usr/sbin/update-alternatives --install /usr/bin/dropdb pgsql-dropdb /usr/pgsql-9.3/bin/dropdb 930
/usr/sbin/update-alternatives --install /usr/bin/droplang pgsql-droplang /usr/pgsql-9.3/bin/droplang 930
/usr/sbin/update-alternatives --install /usr/bin/dropuser pgsql-dropuser /usr/pgsql-9.3/bin/dropuser 930
/usr/sbin/update-alternatives --install /usr/bin/pg_basebackup pgsql-pg_basebackup /usr/pgsql-9.3/bin/pg_basebackup 930
/usr/sbin/update-alternatives --install /usr/bin/pg_dump pgsql-pg_dump /usr/pgsql-9.3/bin/pg_dump 930
/usr/sbin/update-alternatives --install /usr/bin/pg_dumpall pgsql-pg_dumpall /usr/pgsql-9.3/bin/pg_dumpall 930
/usr/sbin/update-alternatives --install /usr/bin/pg_restore pgsql-pg_restore /usr/pgsql-9.3/bin/pg_restore 930
/usr/sbin/update-alternatives --install /usr/bin/reindexdb pgsql-reindexdb /usr/pgsql-9.3/bin/reindexdb 930
/usr/sbin/update-alternatives --install /usr/bin/vacuumdb pgsql-vacuumdb /usr/pgsql-9.3/bin/vacuumdb 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/clusterdb.1 pgsql-clusterdbman /usr/pgsql-9.3/share/man/man1/clusterdb.1 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/createdb.1 pgsql-createdbman /usr/pgsql-9.3/share/man/man1/createdb.1 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/createlang.1 pgsql-createlangman /usr/pgsql-9.3/share/man/man1/createlang.1 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/createuser.1 pgsql-createuserman /usr/pgsql-9.3/share/man/man1/createuser.1 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/dropdb.1 pgsql-dropdbman /usr/pgsql-9.3/share/man/man1/dropdb.1 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/droplang.1 pgsql-droplangman /usr/pgsql-9.3/share/man/man1/droplang.1 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/dropuser.1 pgsql-dropuserman /usr/pgsql-9.3/share/man/man1/dropuser.1 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/pg_basebackup.1 pgsql-pg_basebackupman /usr/pgsql-9.3/share/man/man1/pg_basebackup.1 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/pg_dump.1 pgsql-pg_dumpman /usr/pgsql-9.3/share/man/man1/pg_dump.1 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/pg_dumpall.1 pgsql-pg_dumpallman /usr/pgsql-9.3/share/man/man1/pg_dumpall.1 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/pg_restore.1 pgsql-pg_restoreman /usr/pgsql-9.3/share/man/man1/pg_restore.1 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/psql.1 pgsql-psqlman /usr/pgsql-9.3/share/man/man1/psql.1 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/reindexdb.1 pgsql-reindexdbman /usr/pgsql-9.3/share/man/man1/reindexdb.1 930
/usr/sbin/update-alternatives --install /usr/share/man/man1/vacuumdb.1 pgsql-vacuumdbman /usr/pgsql-9.3/share/man/man1/vacuumdb.1 930