Home / server / Questions / 872537
In Process
x-yuri
Asked: 2017-09-08 08:20:14 +0800 CST

Can I use pg_config of other version of PostgreSQL?

  • 772

I have PostgreSQL 9.4 running on CentOS 7. I installed it from PostgreSQL's repository. And now I want to install ruby gem pg. But it fails, since it can't find pg_config.

Now then, psql works, and in the rpm file I can see:

$ rpm -q --scripts -p postgresql94-9.4.12-1PGDG.rhel7.x86_64.rpm | egrep 'psql|pg_config'
/usr/sbin/update-alternatives --install /usr/bin/psql pgsql-psql /usr/pgsql-9.4/bin/psql 940
...

So, it makes psql automatically available, but not pg_config. Is it by design or by accident? Should I install posgresql as well and use pg_config from PosgreSQL 9.2?

centos

1 Answers

  1. From the docs

    You may need to specify the path to the 'pg_config' program installed with Postgres:

    gem install pg -- --with-pg-config=<path to pg_config>

    So try this,

    gem install pg -- --with-pg-config=/usr/pgsql-9.4/bin/pg_config

    Updated for things not previously mentioned, but also in the docs.

    If you're installing via Bundler, you can provide compile hints like so:

    bundle config build.pg --with-pg-config=<path to pg_config>
    • 1