On Wed, Oct 21, 2020 at 9:16 PM Strahil Nikolov via Users <[email protected]>
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,
> [email protected] <[email protected]> написа:
>
>
>
>
>
> 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 -- [email protected]
> To unsubscribe send an email to [email protected]
> 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/[email protected]/message/JPWYVOHDVRLNISNH6WMW5KAWRBWI3NZP/
> _______________________________________________
> Users mailing list -- [email protected]
> To unsubscribe send an email to [email protected]
> 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/[email protected]/message/LKCIV56ELQRI4HTGK2VPYCP35YXMJYXF/
>
--
Didi
_______________________________________________
Users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
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/[email protected]/message/CER6XMTHZZD7FA7BIJR4YQV37X5UXQJP/