Re: Rename or Removing Postgres user - Mailing list pgsql-admin

From John Wiencek
Subject Re: Rename or Removing Postgres user
Date
Msg-id 9F3A3635-5DAD-4483-BE6A-D6B4ADBB0B4F@comcast.net
Whole thread Raw
In response to Rename or Removing Postgres user  (Devendra Yadav <devendra.857@gmail.com>)
Responses Re: Rename or Removing Postgres user  (Devendra Yadav <devendra.857@gmail.com>)
List pgsql-admin
Why do you want to do this considering you are prevented because it is REQUIRED?

Sent from my iPad

> On Feb 14, 2019, at 12:49 AM, Devendra Yadav <devendra.857@gmail.com> wrote:
>
> Dear Postgres Experts,
>
> I want to know if I rename 'postgres' user to 'someuser' retaining it's privileges i.e superuser and other
privileges. 
>
> Or what if I drop the 'postgres' user and create a new superuser. I tried dropping Postgres user but it says "cannot
droprole postgres because it is required by the database system".  
>
> So my concern is what happens if I rename it. As far as I can check there's no impact, but in case anyone has faced
issuesregarding this, please suggest. 
>
> Thanks & Regards,
> Devendra



pgsql-admin by date:

Previous
From: Shreeyansh Dba
Date:
Subject: Re: Rename or Removing Postgres user
Next
From: Devendra Yadav
Date:
Subject: Re: Rename or Removing Postgres user