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

On Dec 10, 2014, at 7:55 AM, wangzhipengkmust@126.com wrote:

> The following bug has been logged on the website:
>=20
> Bug reference:      12187
> Logged by:          Grady
> Email address:      wangzhipengkmust@126.com
> PostgreSQL version: 9.3.5
> Operating system:   Red hat 6.5
> Description:       =20
>=20
> 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:
>=20
> Installed:
>  postgresql93.x86_64 0:9.3.5-1PGDG.rhel6                    =20
> postgresql93-contrib.x86_64 0:9.3.5-1PGDG.rhel6              =20
>  postgresql93-debuginfo.x86_64 0:9.3.5-1PGDG.rhel6          =20
> postgresql93-devel.x86_64 0:9.3.5-1PGDG.rhel6                =20
>  postgresql93-docs.x86_64 0:9.3.5-1PGDG.rhel6               =20
> postgresql93-jdbc.x86_64 0:9.3.1101-1PGDG.rhel6              =20
>  postgresql93-jdbc-debuginfo.x86_64 0:9.3.1101-1PGDG.rhel6  =20
> postgresql93-libs.x86_64 0:9.3.5-1PGDG.rhel6                 =20
>  postgresql93-odbc.x86_64 0:09.03.0300-1PGDG.rhel6          =20
> postgresql93-odbc-debuginfo.x86_64 0:09.03.0300-1PGDG.rhel6  =20
>  postgresql93-plperl.x86_64 0:9.3.5-1PGDG.rhel6             =20
> postgresql93-plpython.x86_64 0:9.3.5-1PGDG.rhel6             =20
>  postgresql93-pltcl.x86_64 0:9.3.5-1PGDG.rhel6              =20
> postgresql93-python.x86_64 0:4.1.1-1PGDG.rhel6               =20
>  postgresql93-python-debuginfo.x86_64 0:4.1.1-1PGDG.rhel6   =20
> postgresql93-server.x86_64 0:9.3.5-1PGDG.rhel6               =20
>  postgresql93-test.x86_64 0:9.3.5-1PGDG.rhel6   =20
>=20
>=20

If you look at the output of:=20

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