0

I'm adapting scripts that configure PostgreSQL 9.6 and 10.x on Ubuntu 16.04 to also work on Centos 7.4. I'm missing the pg_conftool utility which allows me to identify and modify aspects of the PostgreSQL configuration in a clean, high-level fasion, and I get no results from yum whatprovides pg_conftool. What Yum package would I need to install to have it available?

0

pg_conftool isn't packaged by CentOS or EPEL. You could always check out the source yourself and use the included .spec file to build your own RPM.

1

There is no mention of pg_conftool in the PostgreSQL documentation and I cannot find it in any of the CentOS packages. Given this, I expect this is a Debian/Ubuntu specific tool.

You will find server tools and client tools listed in the official documentation.

Of these, the tool pg_controldata seems the closest match to your use-case but the documentation only talks about retrieving cluster-wide configuration rather than setting it.

For setting data, you could modify the config files whilst using pg_ctl to stop, start, or reload the servers as required.

Packages

pg_controldata is definitely available in Ubuntu 16 and Ubuntu 17 (see the list of files link next to your system architecture)

For CentOS, I don't have anything to hand that will give me file listings for the packages. If you aren't already, then I suggest that you use the official PostgreSQL repos rather than the default system repos.

  • Couldn't find pg_controldata on neither Ubuntu 16.04 nor CentOS 7, unfortunately. – YitzikC Apr 15 '18 at 17:26
  • @YitzikC pg_controldata is definitely in Ubuntu (see revised answer). I don't have anything to hand to check the CentOS packages. – Marvin Apr 15 '18 at 19:11
  • Thanks @Marvin, now I can find it. It's not really a substitute for pg_conftool, though. – YitzikC Apr 16 '18 at 12:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.