Rename or Removing Postgres user

Поиск
Список
Период
Сортировка
От Devendra Yadav
Тема Rename or Removing Postgres user
Дата
Msg-id CAE+tJY9ozN5csfYz4+=nuw0ZHKPAojt=6bDVczXH4fYSx-wu2w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Rename or Removing Postgres user  (Federico <rotellaro@gmail.com>)
Re: Rename or Removing Postgres user  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Re: Rename or Removing Postgres user  (John Wiencek <jwiencek3@comcast.net>)
Re: Rename or Removing Postgres user  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: insert data with invalid input syntax for integer:"42P01"
Следующее
От: Federico
Дата:
Сообщение: Re: Rename or Removing Postgres user