[ovirt-users] Re: Please help: Failure Restoring Data on Clean Engine After Migration

On Tue, Jul 19, 2022 at 9:38 AM Andrei Verovski <andreil1@starlett.lv> wrote:

Hi,

Thanks, I solved this problem before by means of executing these commands:

su - postgres -s/bin/bash psql -d ovirt_engine_history

CREATE ROLE ovirt_engine_history_grafana; ALTER DEFAULT PRIVILEGES FOR ROLE ovirt_engine_history IN SCHEMA public GRANT SELECT ON TABLES TO ovirt_engine_history_grafana; ALTER ROLE ovirt_engine_history_grafana WITH ENCRYPTED PASSWORD ‘my_password'; ALTER ROLE ovirt_engine_history_grafana WITH LOGIN;

So this last one, 'LOGIN', was the missing part. OK. Thanks for the update. Glad to hear that you solved it! Any other conclusions/suggestions you'd like to make? Best regards, -- Didi