postgreSQL[Windows XP]安装问题解决方案:_secondary login is-优快云博客

本文链接：https://blog.youkuaiyun.com/aureate820/article/details/2644575

本文提供了解决postgreSQL在Windows XP环境下安装过程中遇到的几个常见问题的解决方案，包括配置JDK环境变量、解决服务未运行及权限设置失败等问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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