Re: Pb with createdb

or just:
  su - postgres -c "createdb <db>"

-----Original Message-----
From: Hiroki Takada [mailto:takada@xxxxxxxxxxxxx]
Sent: Friday, June 21, 2002 10:29 AM
To: pgsql-novice@xxxxxxxxxxxxxx
Subject: Re: [NOVICE] Pb with createdb


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

the user admin scheme of PostgreSQL should be considered.
you, however, can simply create an user named 'root' like

su postgres -c 'createuser root'

then, try 'createdb' again.

> i'm very new to pgsql. I've use the debian package to install it on my
> woody, and i'm trying to create a database.
> 
> but : > createdb 
> psql: FATAL 1:  user "root" does not exist
> createdb: database creation failed
>

Hiroki 

- -- 
 ----------------------------------------------------
    Hiroki Takada <takada@xxxxxxxxxxxxx>

    My public key is available at the public key
    servers. The message was signed as iso-2022-jp
    char-set document in no PGP/MINE (RFC 2015)
    format.
 ----------------------------------------------------


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: KUHASIKU WA http://www.gnupg.org/ WO GORANKUDASAI

iD8DBQE9EzgfyTl8Jc+E3sERAmbnAJ9c4rH6BTwFYX/5Cc+9TEt+zq6/fACfYr/Q
fhPX22LqixcFJjrEwJULtzU=
=GaZE
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly