lcofield

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

tgl

"Louise Cofield" <lcofield@box-works.com> writes:

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 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

lcofield

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:

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 ****yze is your friend

lcofield

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
[mailtogsql-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:

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 ****yze is your friend


---------------------------(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

tgl

"Louise Cofield" <lcofield@box-works.com> writes:

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

tgl

"Louise Cofield" <lcofield@box-works.com> writes:


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

lcofield

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
[mailtogsql-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:

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


---------------------------(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