Re: Createdb Problems - Mailing list pgsql-novice

From Tom Lane
Subject Re: Createdb Problems
Date
Msg-id 1797.1068241265@sss.pgh.pa.us
Whole thread Raw
In response to Createdb Problems  ("Louise Cofield" <lcofield@box-works.com>)
Responses Re: Createdb Problems  ("Louise Cofield" <lcofield@box-works.com>)
List pgsql-novice
"Louise Cofield" <lcofield@box-works.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

pgsql-novice by date:

Previous
From: "Louise Cofield"
Date:
Subject: Createdb Problems
Next
From: "Louise Cofield"
Date:
Subject: Re: Createdb Problems