Patrick Lindeman wrote:
>> I'm trying to start my postgres server and it gives me the following
>> errror
>>
>> FATAL: could not create lock file
>> "/var/run/postgresql/.s.PGSQL.5432.lock":
>> Permission denied
>>
This looks like an Ubuntu or similar install. I believe the standard
PostgreSQL default for unix_socket_directory is /tmp but this can be
changed at build-time. The build Ubuntu provides defaults to
/var/run/postgresql. Other Debian-based distros may do something similar.
In any case, the normal PostgreSQL install for your distro should start
fine via the init scripts such as (Ubuntu style):
sudo /etc/init.d/postgresql-8.2 start
But if you are trying a to run an instance of the PostgreSQL server
owned by your local user, you need to ensure that the unix socket
directory is writable by the user that owns the PostgreSQL server
process. Try:
unix_socket_directory='/tmp'
Cheers,
Steve
