Обсуждение: 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 >