问题描述:
http://www.enterprisedb.com/products-services-training/pgdownload#windows
官方下载,安装之后启动pgAdmin III连接localhost默认数据库报错,错误提示:
Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?
查看系统服务(Services)发现postgresql-9.2服务未启动,尝试启动。报错:
The postgres-9.2 -PostgreSQL Server 9.2 service on Local Computer started and then stopped. Some services
stop automatically if they have work to do, for example, the Performance Logs and Alerts service.
查看系统的事件查看器(Event Viewer)。报错:
FATAL: could not create lock file "postmaster.pid": Permission denied和
Timed out waiting for server startup
解决方案:
就我遇到的情况而言,只需将PostgreSQL安装目录的所有权限(ALL权限)赋给Users用户即可。注意,默认data目录在PostgreSQL安装目录下。若安装时指定了其他目录,则需要同时更改其他目录的访问权限。
其他参考:
http://stackoverflow.com/questions/13116511/postgresql-fails-to-start-on-windows-xp
本文介绍了解决PostgreSQL在Windows环境下安装后无法启动的问题。主要错误包括连接被拒绝和无法创建锁文件等。通过调整PostgreSQL安装目录的权限设置,成功解决了问题。
569

被折叠的 条评论
为什么被折叠?



