PostgreSQL 8.4.2在Win2k3安装不成功

从8.4开始,在我的laptop的win2k3下就不能安装成功,不是权限问题,也不是字符集问题,出错的日志如下:

Initialising the database cluster (this may take a few minutes)...
Executing cscript //NoLogo "D:\PostgreSQL\8.4/installer/server/initcluster.vbs" "postgres" "postgres" "sadb" "D:\PostgreSQL\8.4" "D:\PostgreSQL\8.4\data" 5432 "English, United States"
Script exit code: 1

Script output:

Ensuring we can write to the data directory (using cacls):
处理的目录: D:\PostgreSQL\8.4\data

The files belonging to this database system will be owned by user "yuzifu".
This user must also own the server process.

The database cluster will be initialized with locale English, United States.
initdb: could not find suitable text search configuration for locale English, United States
The default text search configuration will be set to "simple".

fixing permissions on existing directory D:/PostgreSQL/8.4/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
creating configuration files ... ok
creating template1 database in D:/PostgreSQL/8.4/data/base/1 ... 当前目录无效。
child process exited with exit code 1
initdb: removing contents of data directory "D:/PostgreSQL/8.4/data"

Failed to initialise the database cluster with initdb

Script stderr:
Program ended with an error exit code

Error running cscript //NoLogo "D:\PostgreSQL\8.4/installer/server/initcluster.vbs" "postgres" "postgres" "(password)" "D:\PostgreSQL\8.4" "D:\PostgreSQL\8.4\data" 5432 "English, United States" : Program ended with an error exit code
Problem running post-install step. Installation may not complete correctly
The database cluster initialisation failed.

问题最大可能是出在与我安装的某个程序相冲突,但是现在我没有头绪。

权限数据库设计

如图:

2009-06-18_110027

可对用户和角色分别设置权限,当两者均有值时,用户的权限优先。

在之前的策划期间是没有使用外键的,后来查看了许多相关资料外,决定在这个地方使用外键。原因是,这里的数据不多,操作量也不多,不至于影响程序性能。