"Atul Shah" <atul.shah@xxxxxxxxxxxx> 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
