just updated to R1 if you have this problem here is the fix...


2010-11-07 13:49:00 PST FATAL: could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock": Permission denied

edit /etc/postgresql/8.3/main/postgresql.conf

external_pid_file = '/tmp/8.3-main.pid'
unix_socket_directory = '/tmp/'
#ssl = true (dont forget that from the OP)

also just a informational for the how-to you can also install
apt-get install pgadmin3

if your like me and dont like to deal with command line database managment

or you can alternately give posgres permissions everywhere either way.. this was just faster
thanks alot man