Re: Createdb Problems

Now, after shutting the postmaster down, and attempting to restart the
postmaster, this is the error:

"The data directory was initialized by PostgreSQL version 7.3, which is
not compatible with this version 7.1.3."

Louise

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Louise Cofield
Sent: Friday, November 07, 2003 2:50 PM
To: 'Tom Lane'
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] 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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend