Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Document pg_bindir #36

Closed
agentgt opened this issue Sep 24, 2014 · 6 comments
Closed

Document pg_bindir #36

agentgt opened this issue Sep 24, 2014 · 6 comments

Comments

@agentgt
Copy link

agentgt commented Sep 24, 2014

I'm not quite sure how my system upgraded to the latest repmgr but apparently pg_bindir has to be explicitly set.

It would be nice if the example documentation and configuration show that new config variable or maybe just have pg_bindir take the default value of /usr/bin as a sensible default otherwise I have a feeling almost every repmgr upgrade is going to break.

@martinmarques
Copy link
Collaborator

How did your repmgr installation upgrade? Are you using yum or apt?
If that's the case, where does the packaging system get repmgr from?
Logs would be nice (yum.log or apt/history.log).

@agentgt
Copy link
Author

agentgt commented Oct 2, 2014

I think because of the whole xen and shellshock security issues rackspace did some auto upgrading. I took a look at the logs and for some reason I don't see an apt (ubuntu) update.

Regardless it should probably still be put in the documentation as I had to go look in the code to make sure what pg_bindir was. Or maybe there is doc for that configuration and I missed it?

@mverwijs
Copy link

+1 For me.

  postgres@testdb01:~$ export pg_bindir=/usr/bin
  postgres@testdb01:~$ repmgr -f /etc/repmgr.conf master register
  [2014-11-12 21:30:13] [ERROR] pg_bindir config value not found. Check the configuration file.

/me looks at the release notes. Ah.

  • New config option: pg_bindir

After adding "pg_bindir='/usr/bin'" it works.

@SOLDIERz
Copy link

Where you add "pg_bindir='/usr/bin'" ?

@SOLDIERz
Copy link

Okay get it! You need to add it in repmgr.conf like:

#for centos

pg_bindir='/usr/pgsql-9.3/bin'

@ibarwick
Copy link
Collaborator

FYI this issue has been resolved in repmgr 3.0, and repmgr will use the default path if pg_bindir isn't provided. There's also a repmgr command line -b/--pg_bindir to provide an explicit path if needed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants