EnterpriseDb –window 启动失败
Postgres Plus AS 8.3R2
服务无法启动
查看日志文件没有提示：
通过使用 pg_ctl ：
cd C:\PostgresPlus\8.3R2AS\dbserver\bin
pg_ctl start –w –D C:\PostgresPlus\8.3R2AS\data -s -l C:\PostgresPlus\8.3R2AS\data\dbserver_logs\happymen20100729.txt
在
happymen20100729.txt
显示：
2010-07-29 11:45:32 LOG:
** EnterpriseDB Dynamic Tuning Agent ********************************************
*
System Utilization: 100%
*
*
Database Version: 8.3.0.106
*
* Operating System Version: Windows_NT
*
*
Number of Processors: 2
*
*
Processor Type: x86 Family 6 Model 15 Stepping 13, GenuineIntel
*
*
Processor Architecture: x86
*
*
Database Size: 0.1
GB
*
*
RAM: 2.0
GB
*
*
Max DB Connections: 100
*
*
Autovacuum: off
*
*
Autovacuum Naptime: 60
Seconds
*
*********************************************************************************
2010-07-29 11:45:32 FATAL:
could not load server certificate file "server.crt": No such file or directory
上网查：server.crt
文件：原来是我前台配置在PostgreSQL.conf
配置SSL
时出问题了，
#ssl = on # (change requires restart) 注释掉即可，重启可以了
如果要配置SSL 可以參考：
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.
- 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
reference:
http://developer.postgresql.org/pgdo...s/ssl-tcp.html
