On 5/11/06, APSC, Patrick Chee Seng Onn <[EMAIL PROTECTED]> wrote:
Hi,
I've just installed postgresql onto my system but unable to successfully add
new users and databases. I would receive a error message:
createuser: could not connect to database template1: FATAL user "root"
does not exist
createdb: could not connect to database template1: FATAL user "root"
does not exist
what is the error I am facing anyway?
Either try:
createuser -U postgres new_username
or, su to postgres:
su - postgres
and try again:
createuser new_username
<shameless plug>
http://www.designmagick.com/article/5/Starting-Out/PostgreSQL-Users
http://www.designmagick.com/article/6/Starting-Out/PostgreSQL-Databases
--
Postgresql & php tutorials
http://www.designmagick.com/
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org