Re: Need help - Unable to grant a role - Mailing list pgsql-admin

From Siraj G
Subject Re: Need help - Unable to grant a role
Date
Msg-id CAC5iy62CVhgU8wR1te8-6J-fA3_PGpw-+YAOniwwcZg9WFCQ7Q@mail.gmail.com
Whole thread Raw
In response to Re: Need help - Unable to grant a role  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Need help - Unable to grant a role
Re: Need help - Unable to grant a role
List 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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Need help - Unable to grant a role
Next
From: "David G. Johnston"
Date:
Subject: Re: Need help - Unable to grant a role