Re: Createdb Problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Louise Cofield" <lcofield(at)box-works(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Createdb Problems
Date: 2003-11-07 21:41:05
Message-ID: 1797.1068241265@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Louise Cofield" <lcofield(at)box-works(dot)com> writes:
> The initdb seemed to go fine, the postmaster is running in the
> background, but createdb testdb results in this:

> FATAL: user "postgres" does not exist
> psql: FATAL: user "postgres" does not exist
> createdb: database creation failed

> whoami shows that I am clearly "postgres"

Sounds like you weren't postgres when you ran initdb. The only
initially existing PG user will have the name of the Unix user
who ran initdb. Check the ownership of the files under $PGDATA if
you aren't sure what you did.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Louise Cofield 2003-11-07 21:49:50 Re: Createdb Problems
Previous Message Louise Cofield 2003-11-07 21:14:48 Createdb Problems