Project

Profile

Help

Issue #5327

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

Added by ttereshc 5 months ago. Updated about 1 month ago.

Status:
CLOSED - CURRENTRELEASE
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 4 months ago

Automatically source the SCL when using CentOS

Make sure commands like psql work correctly.

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

Revision 98c55227 View on GitHub
Added by dalley 4 months 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 5 months ago

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

#2 Updated by rchan 5 months ago

  • Sprint changed from Sprint 57 to Sprint 58

#3 Updated by ttereshc 5 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 4 months ago

  • Sprint deleted (Sprint 58)

#5 Updated by dalley 4 months 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 4 months ago

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

#7 Updated by dalley 4 months ago

  • Status changed from POST to MODIFIED

#8 Updated by rchan 4 months ago

  • Sprint set to Sprint 59

#9 Updated by bmbouter about 1 month ago

  • Sprint/Milestone set to 3.0.0

#10 Updated by bmbouter about 1 month ago

  • Status changed from MODIFIED to CLOSED - CURRENTRELEASE

Please register to edit this issue

Also available in: Atom PDF