> Is it safe to rename 'postgres' to any__name?
> 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
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/
In response to
pgsql-admin by date
|Next:||From: mike focosi||Date: 2000-11-09 16:38:39|
|Subject: Table Corruption|
|Previous:||From: Brook Milligan||Date: 2000-11-09 15:19:50|
|Subject: Re: large classes (tables)|
pgsql-sql by date
|Next:||From: Stephan Szabo||Date: 2000-11-09 16:24:27|
|Subject: Re: [sql]Joins|
|Previous:||From: Tom Lane||Date: 2000-11-09 15:31:23|
|Subject: Re: alter table add column implementation undesirable? |