You have to be user postgres to create postgreSQL users. As root, you can become any username you want like this:
su username Britton Kerin __ GNU GPL: "The Source will be with you... always." On Tue, 30 Jan 2001, Olivier Billet wrote: > Hi everyone, > > i'd like to use postgreSQL but running createuser as root > throw me this error message : > > | $ createuser > | Connection to database 'template1' failed. > | FATAL 1: SetUserId: user 'root' is not in 'pg_shadow' > | > | createuser: database access failed. > > how to set up the postgresql machinery ? > > Thanks, > Olivier. >
