I have tried to do everything according to OpenACS docs, i.e. I've created the user answering yes to both questions about it's rights. It worked fine when I used the pgsql packaged in the RH distribution but when I compiled it from the source, this problem occured.