PostgreSQL从13升级到15导致pgAdmin连接失败

oo7oh9g9  于 12个月前  发布在  PostgreSQL
关注(0)|答案(1)|浏览(221)

我们目前有一个托管在pg 13.1(与PostGIS 3.1.1)的数据库,我们渴望转移到pg 15.3(与PostGIS 3.3.3),所有运行在Windows 10上。
我安装了pg15没有问题。pgAdmin 4实用程序(与postgres 15捆绑)连接正常。
然后,我使用pg_tagde.exe实用程序成功地将我们的数据库迁移到新的pg15服务器。

pg_upgrade.exe --old-datadir "D:\PostgreSQL\13\data" --new-datadir "D:\PostgreSQL\15\data" --old-bindir "C:\Program Files\PostgreSQL\13\bin" --new-bindir "C:\Program Files\PostgreSQL\15\bin" --username=super_user

字符串
我们的应用程序和服务似乎对新的pg15数据库很满意。
然而,使用pg_tagde.exe实用程序迁移我们的数据库导致了某种问题,pgAdmin(与15捆绑的版本)将不再访问我们的服务器。
启动较新的pgAdmin会导致UI出现超时错误,并在pgAdmin日志文件中出现以下错误

2023-09-12 15:04:03,159: WARNING    werkzeug:    WebSocket transport not available. Install simple-websocket for improved performance.
2023-09-12 15:04:03,159: WARNING    werkzeug:    Werkzeug appears to be used in a production deployment. Consider switching to a production web server instead.
2023-09-12 15:04:12,182: ERROR    pgadmin:    Exception when checking for update
Traceback (most recent call last):
File "urllib\request.py", line 1348, in do_open
File "http\client.py", line 1282, in request
File "http\client.py", line 1328, in _send_request
File "http\client.py", line 1277, in endheaders
File "http\client.py", line 1037, in _send_output
File "http\client.py", line 975, in send
File "http\client.py", line 1447, in connect
File "http\client.py", line 941, in connect
File "socket.py", line 845, in create_connection
File "socket.py", line 833, in create_connection
TimeoutError: timed out
 
During handling of the above exception, another exception occurred:
 
Traceback (most recent call last):
File "C:\Program Files\pgAdmin 4\v7\web\pgadmin\browser\__init__.py", line 435, in check_browser_upgrade
response = urlopen(url, data, 5)
File "urllib\request.py", line 216, in urlopen
File "urllib\request.py", line 519, in open
File "urllib\request.py", line 536, in _open
File "urllib\request.py", line 496, in _call_chain
File "urllib\request.py", line 1391, in https_open
File "urllib\request.py", line 1351, in do_open
urllib.error.URLError: <urlopen error timed out>
2023-09-12 15:04:46,062: ERROR    pgadmin:    Could not connect to server(#3) - 'PostgreSQL 15'.
Error: connection timeout expired


我已经安装了最新的pgAdmin4(v7.6),但这给出了相同的错误。

kq0g1dla

kq0g1dla1#

在PostgreSQL中,身份验证发生了变化。
有几种基于密码的身份验证方法。这些方法的操作类似,但不同之处在于用户的密码如何存储在服务器上,以及客户端提供的密码如何通过连接发送。
超燃沙-256
你尝过这个吗?
更多信息,你可以在这里找到:
https://www.postgresql.org/docs/14/auth-password.html

相关问题