Permissions problem on new install

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

Responses

Browse pgsql-novice by date

  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