启动 postgresql 时遇到问题
我刚刚获得了运行 SLES10 的 VM 的副本,其中包含 Postgresql。我尝试使用命令“postgresql start”启动它,但它返回一条错误消息:“无法启动 postmaster”。在旧机器上运行良好。自从复制机器以来我所做的唯一一件事就是更改其 IP 地址和名称、安装 VMWare Tools 并删除 postgresql 日志目录 /.../postgres/pg_log (后来我重新创建了它)。我尝试重新启动机器,但仍然收到错误消息。我可以做什么来确定问题的原因?
I just got a copy of a VM running SLES10 in which I have Postgresql. I try to start it using the command "postgresql start" but it returns an error message: "could not start postmaster". On the old machine it works fine. The only things I did since copying the machine was to change its IP Address and name, install VMWare Tools and delete the postgresql logs directory /.../postgres/pg_log (I recreated it afterwards). I tried restarting the machine but I still get the error. What can I do to determine the cause of the problem?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
检查 Postgres 和系统日志文件
我敢打赌,访问数据目录存在一些问题,例如运行 postmaster 的帐户没有对该目录的读/写访问权限。
编辑
您可以尝试通过运行以下命令“手动”启动 Postgres(而不是系统提供的脚本):
然后您可能会在控制台上看到错误消息。确保您以 postgres 用户身份运行它
Check out the Postgres and system log files
My bet is that there is some problem with accessing the data directory e.g. the account running the postmaster does not have read/write access to that directory.
Edit
You can try to start Postgres "manually" (as opposed to the system provided scripts) by running:
then you might be able to see error messages on the console. Make sure you are running this as the postgres user