Обсуждение: alter pg_shadow

Поиск
Список
Период
Сортировка

alter pg_shadow

От
"pgsql-sql"
Дата:
Is it safe to rename 'postgres' to any__name?

like

update pg_shadow set usename = 'any__name' where usename = 'postgres';


Sherwin



Re: [SQL] alter pg_shadow

От
Peter Eisentraut
Дата:
pgsql-sql writes:

> Is it safe to rename 'postgres' to any__name?
>
> like
>
> update pg_shadow set usename = 'any__name' where usename = 'postgres';

If you do that then you won't be able to call the standalone backend
anymore ("postgres"), which authenticates you by comparing this name to
the current Unix user name, but this is something you may or may not care
about.

Better would be if you create a Unix user "any__name" and change the
ownership of the PGDATA files to that user.

Better yet, leave the guy alone and create another superuser account with
a name of your choice.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/