Re: Rename or Removing Postgres user

Hi Devendra,

Session login user can not rename. You need to create a another super user,
log in as a new super user, and then rename default postgres user using
alter.

Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com

On Thu, Feb 14, 2019 at 12:20 PM Devendra Yadav <devendra(dot)857(at)gmail(dot)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
>