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...
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
