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

From Federico
Subject Re: Rename or Removing Postgres user
Date
Msg-id CAAOrQf0-YMDPCG3Qop3OcT0d4Ctn+JnG2d3eaFcWDPvC3yTUkQ@mail.gmail.com
Whole thread Raw
In response to Rename or Removing Postgres user  (Devendra Yadav <devendra.857@gmail.com>)
List pgsql-admin
AFAIK you cannot rename the postgres default super user. The name is set with initdb.

On Thu, 14 Feb 2019, 07:50 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 drop role 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 issues regarding this, please suggest.

Thanks & Regards,
Devendra

pgsql-admin by date:

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