problem creating database..

From: Indira <indira(at)indira(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: problem creating database..
Date: 2002-12-04 18:13:18
Message-ID: Pine.NEB.4.44.0212041312390.28294-100000@durga.theundergroundcity.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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?
thanks a lot!

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Dmitri Touretsky 2002-12-04 18:15:51 Very slow performance - addition
Previous Message Dmitri Touretsky 2002-12-04 18:00:09 Yet one more stupid question