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/JPWYVOHDVRLNISNH6WMW5KAWRBWI3NZP/
_______________________________________________
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/LKCIV56ELQRI4HTGK2VPYCP35YXMJYXF/


--
Didi