Project

Profile

Help

Issue #5327

psql doesn't work on the pulp2-nightly-pulp3-source-centos7 box

Added by ttereshc about 2 months ago. Updated 25 days ago.

Status:
MODIFIED
Priority:
Normal
Assignee:
Category:
-
Sprint/Milestone:
-
Start date:
Due date:
Severity:
2. Medium
Version:
Platform Release:
Blocks Release:
OS:
Backwards Incompatible:
No
Triaged:
Yes
Groomed:
No
Sprint Candidate:
No
Tags:
Dev Environment
QA Contact:
Complexity:
Smash Test:
Verified:
No
Verification Required:
No
Sprint:
Sprint 59

Description

Pulp 3 functions fine, it's just postgresql client which doesn't work.

(pulp) [vagrant@pulp2-nightly-pulp3-source-centos7 ~]$ psql 
psql: error while loading shared libraries: libpq.so.rh-postgresql96-5: cannot open shared object file: No such file or directory

Associated revisions

Revision 98c55227 View on GitHub
Added by dalley 27 days ago

Automatically source the SCL when using CentOS

Make sure commands like psql work correctly.

closes: #5327
https://pulp.plan.io/issues/5327

History

#1 Updated by amacdona@redhat.com about 2 months ago

  • Triaged changed from No to Yes
  • Sprint set to Sprint 57

#2 Updated by rchan about 2 months ago

  • Sprint changed from Sprint 57 to Sprint 58

#3 Updated by ttereshc about 2 months ago

Creating a symlink to the expected location helped. I guess adding /opt/rh/rh-postgresql96/root/ to the path will also help. Though I'm surprised why installation doesn't create symlink in /usr/lib64. :/

sudo ln -s /opt/rh/rh-postgresql96/root/usr/lib64/libpq.so.rh-postgresql96-5  /usr/lib64/libpq.so.rh-postgresql96-5

#4 Updated by rchan about 1 month ago

  • Sprint deleted (Sprint 58)

#5 Updated by dalley 27 days ago

I don't think this is a bug per-se, it's just how SCLs work, since you can have multiple installed in parallel and to accommodate that you are forced to explicitly specify which version you want.

According to: https://www.softwarecollections.org/en/scls/rhscl/rh-postgresql96/

What we should do is

scl enable rh-postgresql96 -- psql

Since we are only using one version of the SCL, we could possibly set it up to be permanently enabled by adding it to the bashprofile.

https://serverfault.com/questions/751155/permanently-enable-a-scl

#6 Updated by dalley 27 days ago

  • Status changed from NEW to POST
  • Assignee set to dalley

#7 Updated by dalley 27 days ago

  • Status changed from POST to MODIFIED

#8 Updated by rchan 25 days ago

  • Sprint set to Sprint 59

Please register to edit this issue

Also available in: Atom PDF