There you are :
[root@CTL1 tmp]# su - postgresql
su: user postgresql does not exist
[root@CTL1 tmp]# su - postgres
Last login: Thu Apr 26 12:25:01 CEST 2018 on pts/0
nodectl must be run as root!
nodectl must be run as root!
nodectl must be run as root!
nodectl must be run as root!
-bash-4.2$ psql
psql (9.2.23)
Saisissez « help » pour l'aide.
postgres=# \l
Liste des bases de données
Nom | Propriétaire | Encodage | Collationnement |
Type caract. | Droits d'accès
----------------------+----------------------+----------+-----------------+--------------+-----------------------
dwh | postgres | UTF8 | fr_FR.UTF-8 |
fr_FR.UTF-8 | =Tc/postgres +
| | |
| | postgres=CTc/postgres
engine | engine | UTF8 | en_US.UTF-8 |
en_US.UTF-8 |
ovirt_engine_history | ovirt_engine_history | UTF8 | en_US.UTF-8 |
en_US.UTF-8 |
postgres | postgres | UTF8 | fr_FR.UTF-8 |
fr_FR.UTF-8 |
template0 | postgres | UTF8 | fr_FR.UTF-8 |
fr_FR.UTF-8 | =c/postgres +
| | |
| | postgres=CTc/postgres
template1 | postgres | UTF8 | fr_FR.UTF-8 |
fr_FR.UTF-8 | =c/postgres +
| | |
| | postgres=CTc/postgres
(6 lignes)
postgres=#
Thanks
On Thu, Apr 26, 2018 at 11:49 AM, Marcelo Leandro <marceloltmm(a)gmail.com>
wrote:
Show this information:
1 - su - postgresql
2 - psql
3 - \l
Thanks,
2018-04-26 7:38 GMT-03:00 Marcelo Leandro <marceloltmm(a)gmail.com>:
> What show in the /var/lib/pgsql/upgrade_rh-postgresql95-postgresql.log ?
>
> command:
> cat /var/lib/pgsql/upgrade_rh-postgresql95-postgresql.log
>
> Marcelo Leandro
>
> Em qui, 26 de abr de 2018 07:34, Aziz <azizgstest(a)gmail.com> escreveu:
>
>> Hi Ovirt users,
>>
>> I'm trying to upgrade my Ovirt from version 4.1 to 4.2, but I'm stuck
>> when issuing the command *engine-setup* which returns the following
>> errors :
>>
>> Upgrading PostgreSQL
>> *[ ERROR ] Failed to execute stage 'Misc configuration': Command
>> '/opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup' failed to
execute*
>> [ INFO ] Yum Performing yum transaction rollback
>> [ INFO ] Rolling back to the previous PostgreSQL instance (postgresql).
>> [ INFO ] Stage: Clean up Log file is located at
>> /var/log/ovirt-engine/setup/ovirt-engine-setup-20180426122630-rpkrel.log
>> [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/
>> 20180426122823-setup.conf'
>> [ INFO ] Stage: Pre-termination
>> [ INFO ] Stage: Termination
>> *[ ERROR ] Execution of setup failed*
>>
>>
>> Can anyone help to resolve this ?
>>
>>
>> Thank you in advance.
>>
>> BR.
>> _______________________________________________
>> Users mailing list
>> Users(a)ovirt.org
>>
http://lists.ovirt.org/mailman/listinfo/users
>>
>