Skip site navigation (1) Skip section navigation (2)

Re: [SQL] alter pg_shadow

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-sql <pgsql-sql(at)fc(dot)emc(dot)com(dot)ph>
Cc: pgsql-sql(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: [SQL] alter pg_shadow
Date: 2000-11-09 15:53:47
Message-ID: Pine.LNX.4.21.0011091648410.1244-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
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/


In response to

pgsql-admin by date

Next:From: mike focosiDate: 2000-11-09 16:38:39
Subject: Table Corruption
Previous:From: Brook MilliganDate: 2000-11-09 15:19:50
Subject: Re: large classes (tables)

pgsql-sql by date

Next:From: Stephan SzaboDate: 2000-11-09 16:24:27
Subject: Re: [sql]Joins
Previous:From: Tom LaneDate: 2000-11-09 15:31:23
Subject: Re: alter table add column implementation undesirable?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group