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@lfix.co.uk>
LFIX Limited