Re: Need help - Unable to grant a role
| От | Siraj G |
|---|---|
| Тема | Re: Need help - Unable to grant a role |
| Дата | |
| Msg-id | CAC5iy62CVhgU8wR1te8-6J-fA3_PGpw-+YAOniwwcZg9WFCQ7Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Need help - Unable to grant a role ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: Need help - Unable to grant a role
Re: Need help - Unable to grant a role |
| Список | pgsql-admin |
Hello David!
Sorry for not giving the clarity. It is a GCP environment, we are trying to import using the GCP feature from a backup (export) taken from another instance in the same infra. While the user (hd*****) is created from the GCP console for a specific instance, I can see its presence from "select * from pg_user".
Since I am trying to restore, I believe the user should have pg_write_system_files role, hence trying to grant it.
Regards
Siraj
On Thu, Feb 29, 2024 at 7:40 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, Feb 28, 2024 at 6:36 PM Siraj G <tosiraj.g@gmail.com> wrote:Do we need to create hd*********' as both user and role?Since a PG role and a PG user are the same thing under the hood, the later simply meaning the role can login, then no. Though maybe you mean a OS user since you are dealing with operating system commands here...?Maybe show your work so we aren't left guessing what you are trying to do.David J.
В списке pgsql-admin по дате отправления: