I restore this table - "volume_types" from backup of DB and cinderlib work
now, but I did not like how it happened just after changing the cluster
compatibility level
Restore command:
pg_restore -d ovirt_cinderlib_20200824130037 -a -t volume_types
/root/db/cinderlib_backup.db
_
looks like our main cinderlib DB is empty:
sql -d ovirt_cinderlib_20200824130037 -c "\x on" -c "select * from volume_types"
Expanded display is on.
(0 rows)
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
P
cat /var/lib/pgsql/data/pg_hba.conf
# TYPE DATABASEUSERADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
hostovirt_engine_history ovirt_engine_history_grafana 0.0.0.0/0
I got only:
[postgres@ovc-engine-44 ~]$ psql -U ovirt_cinderlib_20200824130037 -d
ovirt_cinderlib_20200824130037 -c "\x on" -c "select * from volume_types"
psql: error: FATAL: Peer authentication failed for user
"ovirt_cinderlib_20200824130037"
___
U
Can you submit a bug?
Looks like a problem with `volume_types` is empty, can you run
(assuming you use the default DB name/user):
$ psql -U ovirt_cinderlib -d ovirt_cinderlib -c "\x on" -c "select *
from volume_types"
The output on my system is:
-[ RECORD 1 ]+-
5 matches
Mail list logo