Re: [SQL] alter pg_shadow

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [SQL] alter pg_shadow
Дата
Msg-id Pine.LNX.4.21.0011091648410.1244-100000@peter.localdomain
обсуждение исходный текст
Ответ на alter pg_shadow  ("pgsql-sql" <pgsql-sql@fc.emc.com.ph>)
Список pgsql-admin
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/


В списке pgsql-admin по дате отправления:

Предыдущее
От: Brook Milligan
Дата:
Сообщение: Re: large classes (tables)
Следующее
От: "mike focosi"
Дата:
Сообщение: Table Corruption