Permissions problem on new install
От | sdeel |
---|---|
Тема | Permissions problem on new install |
Дата | |
Msg-id | 006001c23e34$06ab3420$9400a8c0@om.om.cox.com обсуждение исходный текст |
Ответы |
Re: Permissions problem on new install
|
Список | pgsql-novice |
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... =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
В списке pgsql-novice по дате отправления: