How to change postgresql data directory.
- vim /etc/postgresql/8.2/main/postgresql.conf
- set data directory path to the new directory path
- Create new Server Certificate
- openssl req -new -text -out server.req
- openssl rsa -in privkey.pem -out server.key
- rm privkey.pem
- openssl req -x509 -in server.req -text -key server.key -out server.crt
- chmod og-rwx server.key
- chown postgres:postgres server.key
- Stop and Restart Postgresql server