Обсуждение: Permissions problem on new install

Hi,

I am brand new to posgresql and having a problem.  When the user 'postgres'
tries to 'createuser sam',  I get promted for wheather new user can create
dbs & create more users (answered 'y' and 'n' respectfully), then I get
error:
"psql: FATAL 1:  cannot open /var/lib/pgsql/data/global/1262: Permission
denied
creaateuser:  creation of user "sam" failed"

I am running Mandrake 8.2 Linux and used package manager to install the
postgresql distributed with Mandrake.  My PG_VERSION file shows 7.2 as the
installed version.

After install as user 'postgres' I ran 'initdb -D /var/local/pgsql/data'
successfully. Then started with '/usr/bin/gp_ctl -D /var/local/pgsql/data -l
logfile start'.  Got message saying postmaster successfully started.

I checked ownership /var/lib/pgsql/data and contents.  They show postgres as
owner and postgress as group.  Also, ownerships for /var/local/pgsql/data
and contents (which is where I expected the permissions to be needed), were
checked and showed postgres as owner and root as group.

As I was just trying to use the tutorial at this point, I tried 'createdb
mydb' as 'postgres' user but got same error as createuser gave.

Thanks in advance for any assistance.
Sam Deel
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Everybody's got to believe in something, I believe I'll have another beer...
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

"sdeel" <sdeel@cox.net> writes:
> "psql: FATAL 1:  cannot open /var/lib/pgsql/data/global/1262: Permission
> denied

/var/LIB/pgsql ...?  I suspect you made a silly typo in either initdb
or starting Postgres ... you wanted /var/LOCAL/pgsql, no?

            regards, tom lane

Tom, I lost running system and had to restart.  I could not get system to
restart until user 'postgres' cd'd to /data things are going now and I have
created user, etc. OK.  I left message I was preparing before sucess below.
No telling what I had done.

Thanks a lot,
--sad
--------------------------------------------
aborted draft follows:
Tom, this seemed like the most likely source of problem (silly typo).
Howeever, I was scrolling back in terminal window and saw correct entries
when I posted the problem.

I have since had to reboot system (yea I know a real guru would have been
able to ssh in and kill hung xprocess, but that's not me and I am not sure
what the host needs to allow the other box, a Windows machine, in etc.).
The long and short is I can no longer go look at my entries and I now cannot
get postgres  to restart!  Current problem(s):
trying:
su postgres
postmaster -D /var/local/
.
.
.
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "sdeel" <sdeel@cox.net>
Cc: <pgsql-novice@postgresql.org>
Sent: Wednesday, August 07, 2002 9:12 PM
Subject: Re: [NOVICE] Permissions problem on new install


> "sdeel" <sdeel@cox.net> writes:
> > "psql: FATAL 1:  cannot open /var/lib/pgsql/data/global/1262: Permission
> > denied
>
> /var/LIB/pgsql ...?  I suspect you made a silly typo in either initdb
> or starting Postgres ... you wanted /var/LOCAL/pgsql, no?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>