Re: [GENERAL] Cant create new users or databases

2000-09-20 Thread AlphaByte
On Mon, 18 Sep 2000, Tom Lane wrote regarding "Re: [GENERAL] Cant create new users or databases": > pg_shadow certainly should not be owned by root. It should be owned by > the postgres user (ie, whoever the postmaster is running as, which you > didn't say). pg_shadow

Re: [GENERAL] Cant create new users or databases

2000-09-16 Thread Tom Lane
AlphaByte <[EMAIL PROTECTED]> 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

Re: [GENERAL] Cant create new users or databases

2000-09-16 Thread John McKown
On Sat, 16 Sep 2000, AlphaByte wrote: > Can someone point out to me what I am doing wrong here? I > can't seem to find this in the documentation anywhere. > > [root@alphabyte abyte]# createuser abyte > Shall the new user be allowed to create databases? (y/n) y > Shall the new user be allowed to