Issue #5327: psql doesn't work on the pulp2-nightly-pulp3-source-centos7 box - Pulp

Agile board
Agile charts

Agile boards

Pulp 2 QE Agile Board
Pulp 2 QE Agile Board - Priority View
Pulp 3 QE Agile Board
Pulp 3 RPM Tests Agile Board
Sprint 112 Agile Board

Custom queries

[All Projects] All Test Trackers
2.21.4 - Next Bugfix Release
2.21.4 MODIFIED
2.21.5
3.14.3
CI/CD
Easy Fix
FIPS open
Functional Tests
Galaxy NG
Groomed
Installer - Triage
Installer Items
Issues for Triage
Katello Integration
Next Docs Day
Operator issues
POST/ASSIGNED - no Sprint - Pulp2
POST/ASSIGNED - no Sprint - Pulp3
Prioritized Bugs
Pulp 3 Docs issues
Pulp2 issues available for next release
Pulpcore
SELinux related
Sprint 111
Sprint 112
Sprint Candidates (also groomed)
Un-Triaged Bugs
Verification Required

Actions

Send by e-mail Copy link

Issue #5327

closed

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

Added by ttereshc over 5 years ago. Updated almost 5 years ago.

Status:

CLOSED - CURRENTRELEASE

Priority:

Normal

Assignee:

dalley

Category:

Sprint/Milestone:

3.0.0

Start date:

Due date:

Estimated time:

Severity:

2. Medium

Version:

Platform Release:

OS:

Triaged:

Yes

Groomed:

Sprint Candidate:

Tags:

Dev Environment

Sprint:

Sprint 59

Quarter:

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

History
Notes
Property changes
Associated revisions

Actions

Copy link

Updated by amacdona@redhat.com about 5 years ago

Triaged changed from No to Yes
Sprint set to Sprint 57

Actions

Copy link

Updated by rchan about 5 years ago

Sprint changed from Sprint 57 to Sprint 58

Actions

Copy link

Updated by ttereshc about 5 years 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

Actions

Copy link

Updated by rchan about 5 years ago

Sprint deleted (~~Sprint 58~~)

Actions

Copy link

Updated by dalley about 5 years 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