From: | "sdeel" <sdeel(at)cox(dot)net> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Permissions problem on new install |
Date: | 2002-08-07 17:01:08 |
Message-ID: | 006001c23e34$06ab3420$9400a8c0@om.om.cox.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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...
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
From | Date | Subject | |
---|---|---|---|
Next Message | Thilo Hille | 2002-08-07 17:25:18 | MemoryContextAlloc: invalid request size 1969649011 |
Previous Message | Robin | 2002-08-07 16:47:20 | Locked out of postgres on my redhat 7.3 |