or just:
su - postgres -c "createdb <db>"
-----Original Message-----
From: Hiroki Takada [mailto:takada@rh.xdsl.ne.jp]
Sent: Friday, June 21, 2002 10:29 AM
To: pgsql-novice@postgresql.org
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@rh.xdsl.ne.jp>
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