postgreSQL[Windows XP]安装问题解决方案:

前端之家收集整理的这篇文章主要介绍了postgreSQL[Windows XP]安装问题解决方案:前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

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注]:上面一段英文是要你建一个受限的计算机用户[注意重启计算机],而不要用管理员帐户.至于为什么,我没弄明白,反正我新建一个受限帐户后,重新安装成功了.

猜你在找的Postgre SQL相关文章