Re: [SQL] alter pg_shadow - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: [SQL] alter pg_shadow
Date
Msg-id Pine.LNX.4.21.0011091648410.1244-100000@peter.localdomain
Whole thread Raw
In response to alter pg_shadow  ("pgsql-sql" <pgsql-sql@fc.emc.com.ph>)
List 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 by date:

Previous
From: Brook Milligan
Date:
Subject: Re: large classes (tables)
Next
From: "mike focosi"
Date:
Subject: Table Corruption