Thread: Pb with createdb

Pb with createdb

From

Pierre-Yves LANDURE

Date:

21 June 2002, 13:00:44

Hi,

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

someone can tell me own to configure the users of postgresql ?

Pierre-Yves Landuré

Re: Pb with createdb

From

Hiroki Takada

Date:

21 June 2002, 13:32:36

-----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-----

Re: Pb with createdb

From

"von Schwerdtner, Thomas (GXS, FPI)"

Date:

21 June 2002, 15:30:56

> but : > createdb
> psql: FATAL 1: user "root" does not exist
> createdb: database creation failed
>
> someone can tell me own to configure the users of postgresql ?

I think the default user is 'admin'....I could be wrong though.....Practical PostgreSQL is avail online, should investigate that if your new (I have the hard copy and like it quite a bit).

-Tom

Re: Pb with createdb

From

"Guthrie, John"

Date:

21 June 2002, 16:57:13

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