Re: db user named 'root'

"Atul Shah" <atul(dot)shah(at)hci(dot)utah(dot)edu> writes:
> As postgres (db superuser):
> createuser -s -d root
> CREATE ROLE
> su root
> createdb root_db
> createdb: could not connect to database template1: FATAL: user "root"
> does not exist

Works for me. Are you sure that you are talking to the same postmaster
in both cases? It's possible that root and postgres have different PATH
settings or different PGPORT settings or some such.

> Huntsman Cancer Institute wishes to promote open communication while =
> protecting confidential and/or privileged information. If you have =
> received this message in error, please inform the sender and delete all =
> copies.

You do realize how silly you look with this sort of mumbo-jumbo attached
to mail to an open mailing list, don't you? Even for private mail, do
your lawyers actually think that this accomplishes anything except
wasting people's disk space?

regards, tom lane