PostgreSQL连接问题 [英] PostgreSQL connection problems

问题描述

我的应用程序有一个非常奇怪的问题，有时连接到Postgres时会出现以下错误。发生这种情况时没有任何模式，通常在运行一些广泛的硒测试时发生。

I have very strange problem with my application, upon occasions I get following error when connecting to postgres. This happens without any pattern, often happens when I run some extensive selenium tests.

警告：pg_connect（）[function.pg-connect]：无法连接到PostgreSQL服务器：服务器意外关闭了连接，这可能意味着服务器在处理请求之前或期间异常终止。

Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

Postgres日志未显示异常，在同一postgres实例上运行的其他应用程序也是如此完全没有问题。

Postgres logs shows no abnormalities, also other applications that run on same postgres instance have no problems at all.

我的Postgres是8.2.9，在Windows 2008服务器上运行

My Postgres is 8.2.9, running on windows 2008 server

有任何提示吗？

推荐答案

服务器意外关闭了连接大多数情况下意味着后端崩溃了。如果是这样的话，服务器日志中应该有一些相关的行。

"server closed the connection unexpectedly" most of the time means the backend crashed. If that's the case there should be some lines about it in the server log.

而且，8.2分支的最新版本是8.2.12。升级，测试，报告。

And by the way the latest version in the 8.2 branch is 8.2.12. Upgrade, test, report.

这篇关于PostgreSQL连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！