Johann Maar wrote: > But if I try to start PostgreSQL by running "sudo /etc/init.d/ > postgresql start" it will fail because it tries to write a PID file > to "/var/run/postgresql" which does not exist. If I create this > directory and set the permissions for postgres to write it works (!), > but after the next restart of the machine the directory is already > gone.
/var/run/ might be on a temporary file system. So you need to adjust your init script to create that directory if it doesn't exist. > I tried to change the location of the PID target directory in > postgresql.conf, but then clients like psql still try to find the PID > file in /var/run/ postgresql and fail. You must be mistaken about this. psql shouldn't have a reason to read the server's PID file. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
