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 
<d...@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, 
> kushagra2agar...@gmail.com <kushagra2agar...@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-le...@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-le...@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
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/KFMWCGRAH6OFKWNJG3R7LORXPAKQHHZ4/

Reply via email to