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

Reply via email to