Forum OpenACS Q&A: Response to Novice question

Collapse
Posted by Tapiwa Sibanda on
Hi Van

Maybe I am misunderstanding your problem, but I still think that it is a permissions issue... I think the problem I had was similar.

The directory /usr/local/pgsql belongs to the user postgres. The user you are trying to run createdb as is nsadmin

The relationship between the two is that they both belong (or should belong) to the group web

My suggestion is to log in as user nsadmin (assuming you have followed the naming conventions in the docs). Check that this user belongs to the groups nsadmin and web. You might want to log in as user postgres and ensure that it belongs to the group web.

If you can see /usr/local/pgsql/bin/*.* as user postgres and you have set the permissions correctly you should be able to run the command createdb as user nsadmin.

if on the other hand you need to run /usr/local/pgsql/bin/creatdb instead of just createdb as user postgres, then you do need to check that the paths you set (as explained in the docs) are correct.

Hope this helps