On Thu, 2024-02-29 at 06:36 +0530, Siraj G wrote:
> 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.
Users (= roles) are not part of the database dump, because they are not part
of the database.
Dump and restore the roles separately, *before* you restore the database.
You can dump the roles with "pg_dumpall -r".
Yours,
Laurenz Albe