Re: Createdb Problems

We changed the ownership of all the postgres files and directories to
postgres. Any further ideas?

Thanks.

Louise

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Friday, November 07, 2003 2:41 PM
To: Louise Cofield
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Createdb Problems

"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