Rebuild PostgreSQL data directory
Brought to you by:
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)
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