Re: [SQL] alter pg_shadow

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(at)gmx(dot)net http://yi.org/peter-e/