From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | Indira <indira(at)indira(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: problem creating database.. |
Date: | 2002-12-04 20:41:38 |
Message-ID: | 1039034498.11430.930.camel@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, 2002-12-04 at 18:13, Indira wrote:
> hey everyone, im trying to create a database on freebsd, using postgresql
> 7.3. when i try and create a database with createdb i get:
>
> su-2.05b$ id
> uid=1005(postgres) gid=1005(postgres) groups=1005(postgres)
> su-2.05b$ pwd
> /usr/local/pgsql
> su-2.05b$ createdb testdb
> FATAL 1: user "postgres" does not exist
> psql: FATAL 1: user "postgres" does not exist
> createdb: database creation failed
>
> so i
> su-2.05b$ createuser postgres
> Shall the new user be allowed to create databases? (y/n) y
> Shall the new user be allowed to create more new users? (y/n) y
> FATAL 1: user "postgres" does not exist
> psql: FATAL 1: user "postgres" does not exist
> createuser: creation of user "postgres" failed
>
> any ideas on whats wrong?
I think you were not user postgres when you ran initdb.
Try logging in as the user who ran it.
--
Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
LFIX Limited
From | Date | Subject | |
---|---|---|---|
Next Message | Joel Burton | 2002-12-04 20:58:00 | Re: Yet one more stupid question |
Previous Message | Oliver Elphick | 2002-12-04 20:39:48 | Re: Yet one more stupid question |