Thread: Createdb Problems

Createdb Problems

From
"Louise Cofield"
Date:
Hi all,
 
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"
 
Does anybody have an idea of what I am doing wrong?
 
Thanks.
 
Louise
 
 
 
 

Re: Createdb Problems

From
Tom Lane
Date:
"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

Re: Createdb Problems

From
"Louise Cofield"
Date:
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@sss.pgh.pa.us]
Sent: Friday, November 07, 2003 2:41 PM
To: Louise Cofield
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Createdb Problems


"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


Re: Createdb Problems

From
"Louise Cofield"
Date:
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@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Louise Cofield
Sent: Friday, November 07, 2003 2:50 PM
To: 'Tom Lane'
Cc: pgsql-novice@postgresql.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@sss.pgh.pa.us]
Sent: Friday, November 07, 2003 2:41 PM
To: Louise Cofield
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Createdb Problems


"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


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


Re: Createdb Problems

From
Tom Lane
Date:
"Louise Cofield" <lcofield@box-works.com> writes:
> We changed the ownership of all the postgres files and directories to
> postgres.  Any further ideas?

That's not going to help, because whatever user name was entered in
pg_shadow is still going to be in pg_shadow.  If you are regretting
your initial choice of who to run initdb as, your best bet is to shut
down the postmaster, rm -rf the PGDATA directory, re-run initdb as the
right person, and restart the postmaster.

            regards, tom lane

Re: Createdb Problems

From
Tom Lane
Date:
"Louise Cofield" <lcofield@box-works.com> writes:
> 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."

Sounds like you also have PATH problems: you've got an old version of
the postmaster in your PATH (possibly left over from your OS install).

            regards, tom lane

Re: Createdb Problems

From
"Louise Cofield"
Date:
Tom,

There were some pathing issues that we modified, and deleting the pgdata
directory and running initdb anew, making sure the user was "postgres",
solved the problems.  We are up and running.  Thanks!

Louise

-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Friday, November 07, 2003 3:06 PM
To: Louise Cofield
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Createdb Problems


"Louise Cofield" <lcofield@box-works.com> writes:
> 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."

Sounds like you also have PATH problems: you've got an old version of
the postmaster in your PATH (possibly left over from your OS install).

            regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly