Hi Didi, thanks for the info - I learned it the hard way (trial & error) and so far it was working. Do we have an entry about that topic in the documentation ? Best Regards, Strahil Nikolov В четвъртък, 22 октомври 2020 г., 08:27:08 Гринуич+3, Yedidyah Bar David <didi@redhat.com> написа: On Wed, Oct 21, 2020 at 9:16 PM Strahil Nikolov via Users <users@ovirt.org> wrote:
I usually run the following (HostedEngine):
[root@engine ~]# su - postgres -bash-4.2$ source /opt/rh/rh-postgresql10/enable
This is applicable to 4.3, on el7. For 4.4 this isn't needed. Also, IIRC this isn't the official method to activate an SCL component, but: $ scl enable rh-postgresql10 bash Which is a significant difference - it runs a process ('bash', in this case, but you can run psql directly) "inside" the environment. A somewhat more official (although IIRC still not the recommended) way is: . scl_source enable rh-postgresql10 (Or 'source' instead of '.', although '.' is the POSIX standard).
-bash-4.2$ psql engine
This works if the engine db is automatically provisioned by engine-setup (which is the default). engine-psql.sh works regardless of version, remote or not, etc. It's a pretty simple script - you can easily read it to see what it does. Best regards,
How did you try to access the Engine's DB ?
Best Regards, Strahil Nikolov
В вторник, 20 октомври 2020 г., 17:00:37 Гринуич+3, kushagra2agarwal@gmail.com <kushagra2agarwal@gmail.com> написа:
I am unable to connect to postgres database running on oVirt engine and while troubleshooting found below possible issue.
semanage fcontext -a -t postgresql_exec_t /opt/rh/rh-postgresql10/root/usr/bin/psql ValueError: File spec /opt/rh/rh-postgresql10/root/usr/bin/psql conflicts with equivalency rule '/opt/rh/rh-postgresql10/root /'; Try adding '//usr/bin/psql' instead
Can someone help to resolve this issue. _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/JPWYVOHDVRLNIS... _______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/LKCIV56ELQRI4H...
-- Didi