Web Hosting Talk







View Full Version : PostgreSQL Help??? Possible simple error?


novanix
10-16-2001, 10:43 PM
i get the following error when I try to run postgresql:

Setting up PostgreSQL: bash: /var/log/postgresql: Permission denied

we have tried chmoding/chowning this every way possible, we tried to even have it create it on its own but it doesnt work does anyone know what is wrong?
In the file the thing that calls the log is:
su postgres -c "nohup /home/usr/bin/postmaster >> /var/log/postgresql 2>&1 &"

SMG
11-03-2003, 11:37 PM
I had a problem like this too, and I still don't know the real answer... but I found something bizarre:

1) psql databasename works fine as root, but not as something else (like admin)

2) as admin:
psql database doesnt work (gives your error)
psql -h localhost database DOES WORK though.

and I also noticed that simply switching localhost to 127.0.0.1 and vice versa in some scripts makes them work if they wont connect.