postgresql[Windows XP]安装问题解决方案:
[flute0316总结]
最近我们做的家谱GIS要用到一些开源的东西,小组的其它成员在研究,我也没怎么抽出时间来关注.
昨天,突然想弄一下postpostgresql,就安装了一下.呵呵,遇到了几个小问题,搞了一晚上也没安好.今天上午上完课后,专心搞了一下,呵呵,成功了!
1. 首先安装JDK,并配置好环境变量
参考网址: http://www.javazy.com/contentex/2005829151425.shtml
2. 安装过程图解
参考网址: http://hi.baidu.com/person%5Fspace/blog/item/3da7624ae058412608f7efe3.html
3. 安装问题:"The Secondary Login Service is Not Running“
解决:从控制面板--计算机管理--服务里找到 Secondary Login Service 设置为自动启动。
参考网址: http://hi.baidu.com/coolcode/blog/item/bc0486822ce58093f603a698.html
4. 安装问题: Postgresql: Installing "Failed to set permissions" on windows XP
解决:
Postgresql: Installing "Failed to set permissions" on windows XP
Here time to test some advanced features on Postgresql,well,download 8.2.5 from their website. *.msi good,click to install.
but got error on my screen: "Failed to set PErmissions on the installed files Please see the log file in ***/tmp/pgperm.log".
checked document,it recommend NTFS,yeah,I got NTFS here. After a while,I make another approach,it worked!
--install Postgresql without set up it as windows service =>everything goes well
so the problem is clear,something went wrong when Postgresql it tryto register itself as windows service. 1 thing gave me clue quicklyafter I got this:
C:/Psql/8.2/bin>postgres
it is not allowed user with administrator privileges run Postgresql server....
the solution is: create a LIMITED user under windows,thenre-install Postgresql with windows service based on that 'LIMITED' user.
another easy day,uh? you get it. [flute0316注]:上面一段英文是要你建一个受限的计算机用户[注意重启计算机],而不要用管理员帐户.至于为什么,我没弄明白,反正我新建一个受限帐户后,重新安装成功了.