Need help - Unable to grant a role

From: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Need help - Unable to grant a role
Date: 2024-02-29 01:06:26
Message-ID: CAC5iy62S_j4km2cFtXUaoGGb6MqXhsZc_wYueRkCpxb9q5Lb_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello!

I have a PgSQL 15.4 database newly created. I created a user and is using
it to restore a backup of another database, but unable to do so as it is
failing with the below error:
Error: role 'hd*********' does not exist.

I even tried to grant pg_read_system_files and pg_write_system_files roles,
even then I am getting the same error.

Can someone please advise me on what I should do?

Regards
Siraj

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Erik Wienhold 2024-02-29 01:28:29 Re: Need help - Unable to grant a role
Previous Message Ron Johnson 2024-02-28 18:22:14 Re: Backup strategy