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
