我们目前有一个托管在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),但这给出了相同的错误。
1条答案
按热度按时间kq0g1dla1#
在PostgreSQL中,身份验证发生了变化。
有几种基于密码的身份验证方法。这些方法的操作类似,但不同之处在于用户的密码如何存储在服务器上,以及客户端提供的密码如何通过连接发送。
超燃沙-256
你尝过这个吗?
更多信息,你可以在这里找到:
https://www.postgresql.org/docs/14/auth-password.html