Postgres Pro
Downloads
Home   >   mailing lists

Re: Cant create new users or databases - Mailing list pgsql-general

From Tom Lane
Subject Re: Cant create new users or databases
Date
Msg-id 4618.969119143@sss.pgh.pa.us
Whole thread Raw
In response to Cant create new users or databases  (AlphaByte <alan@alphabyte.co.nz>)
List pgsql-general
Tree view 
AlphaByte <alan@alphabyte.co.nz> writes:
> NOTICE:  mdopen: couldn't open /var/lib/pgsql/pg_shadow: Permission denied
> NOTICE:  RelationIdBuildRelation: smgropen(pg_shadow): Permission denied

Hmm.  What user is the postmaster running as?  (Look in ps -aux output
if you're not 100% sure.)  What are the permissions on the file
/var/lib/pgsql/pg_shadow, and what userid owns it?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE USER and ODBC
Next
From: Yury Don
Date:
Subject: Re: os.h