Permission Problems:-)? - Mailing list pgsql-general

From Jerome Lyles
Subject Permission Problems:-)?
Date
Msg-id 200401262331.25438.susemail@hawaii.rr.com
Whole thread Raw
Responses Re: Permission Problems:-)?  (Richard Huxton <dev@archonet.com>)
Re: Permission Problems:-)?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm trying to build a database.  But none of the users I try to use works.
I as normal user doesn't work:

:~> createdb mydb
createdb: could not connect to database template1: FATAL:  user "adriel" does
not exist

I as postgresql user doesn't work:
:~> createdb mydb
createdb: could not connect to database template1: FATAL:  user "mypostgre"
does not exist

I as root user doesn't work:

# createdb mydb
createdb: could not connect to database template1: FATAL:  user "root" does
not exist

I can only start postgresql as root.  What am I doing wrong here?  How do I do
it right?

Thanks,
Jerome


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: postmaster growing to consume all memory
Next
From: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]"
Date:
Subject: Re: Reloading Template1