Re: db user named 'root' - Mailing list pgsql-admin

From Tom Lane
Subject Re: db user named 'root'
Date
Msg-id 20160.1139445787@sss.pgh.pa.us
Whole thread Raw
In response to db user named 'root'  ("Atul Shah" <atul.shah@hci.utah.edu>)
List pgsql-admin
"Atul Shah" <atul.shah@hci.utah.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

pgsql-admin by date:

Previous
From: "Atul Shah"
Date:
Subject: db user named 'root'
Next
From: "Tomeh, Husam"
Date:
Subject: Upgrading O/S requires Postgres re-build?