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@xxxxxxxxx> wrote:
On Wed, Feb 28, 2024 at 6:36 PM Siraj G <tosiraj.g@xxxxxxxxx> 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.
