Postgres SSL 错误 [英] Postgres SSL error

问题描述

我正在尝试通过 SSH 和 drush(命令行 shell)运行 Drupal 迁移，将数据从 postgres 数据库复制到 mysql.

I'm trying to run a Drupal migration via SSH and drush (a command line shell), copying data from a postgres database to mysql.

它可以正常工作一段时间(约 5 分钟左右)，但随后出现错误:

It works fine for a while (~5 mins or so), but then I get the error:

SQLSTATE[HY000]: General error: 7 SSL [error] SYSCALL error: EOF detected

postgres 数据库连接似乎已经消失，我只是收到错误:

The postgres database connection seems to have gone, and I just get errors:

SQLSTATE[HY000]: General error: 7 no [error] connection to the server

它在本地运行良好，所以我认为问题一定出在 postgres 上并通过 SSH 运行脚本 - 但是在谷歌上搜索这些错误没有任何用处.有谁知道这可能是什么原因造成的?

It works fine locally, so I think the problem must be with postgres and running a script over SSH - but googling these errors returns nothing useful. Does anyone know what could be causing this?

推荐答案

可能是超时.首先检查日志(可能更改 ssl_renegotiation_limit)

Could be a timeout. first inspect the log (maybe change ssl_renegotiation_limit)

顺便说一句:IIRC，重新协商不会在固定的时间后发生，而是在传输一定数量的字符(2GB?)后发生

BTW: IIRC, the renegotiation does not take place after a fixed amount of time, but after a certain amount of transmitted characters (2GB?)

这篇关于Postgres SSL 错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！