| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Siraj G <tosiraj(dot)g(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Need help - Unable to grant a role |
| Date: | 2024-02-29 08:00:09 |
| Message-ID: | cf66b06facd180dcf7aaf87ec744b95491d7541c.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bindra | 2024-02-29 15:06:40 | pg_dump blocks insert update on table |
| Previous Message | Siraj G | 2024-02-29 06:58:54 | Re: Need help - Unable to grant a role |