#1 Rebuild PostgreSQL data directory

[macpablodesigns]

In the install of the iso image, the postgresql fails to start properly.

CDT FATAL: could not load server certificate file "server.crt": No such file or directory

This should fix it.
Code:

vim /etc/postgresql/8.3/main/postgresql.conf

and comment the following line.
Code:

#ssl = true # (change requires restart)

[macpablodesigns]

If you really wish to SSL On then you need to run the following command and create a new server.key file in your new data directory.

with the following steps.

1. openssl req -new -text -out server.req
2. openssl rsa -in privkey.pem -out server.key
3. rm privkey.pem
4. openssl req -x509 -in server.req -text -key server.key -out server.crt
5. chmod og-rwx server.key
6. chown postgres : postgres server.key