So I've already read countless forum entries on this very subject but I still can't seem to get this to work.
Basically I need to move my postgresql database to an external hard drive as it contains a good deal of data and is only going to grow more and more, which is the reason I got a 4TB external HDD to store everything on. So I changed the data_directory variable in etc/postgresql/8.4/main/postgresql.conf and tried restarting but I get an error, cannot open log file.
I'm running postgres 8.4 and Debian. Everything works fine when I revert it to the default directory but the computer hard drive will fill up quickly and I would like to get this onto the external HDD asap.