postgresql Postgres SSL 错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/11450069/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Postgres SSL error
提问by Ben Scott
I'm trying to run a Drupal migration via SSH and drush (a command line shell), copying data from a postgres database to mysql.
我正在尝试通过 SSH 和 drush（命令行 shell）运行 Drupal 迁移，将数据从 postgres 数据库复制到 mysql。
It works fine for a while (~5 mins or so), but then I get the error:
它可以正常工作一段时间（约 5 分钟左右），但随后出现错误：
SQLSTATE[HY000]: General error: 7 SSL [error] SYSCALL error: EOF detected
The postgres database connection seems to have gone, and I just get errors:
postgres 数据库连接似乎已经消失，我只是收到错误：
SQLSTATE[HY000]: General error: 7 no [error] connection to the server
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?
它在本地运行良好，所以我认为问题一定出在 postgres 上并通过 SSH 运行脚本 - 但是谷歌搜索这些错误没有任何用处。有谁知道是什么原因造成的？
采纳答案by wildplasser
Could be a timeout. first inspect the log (maybe change ssl_renegotiation_limit)
可能是超时。首先检查日志（可能更改 ssl_renegotiation_limit）
BTW: IIRC, the renegotiation does not take place after a fixed amount of time, but after a certain amount of transmitted characters (2GB?)
顺便说一句：IIRC，重新协商不会在固定的时间后发生，而是在传输一定数量的字符（2GB？）
回答by Mark Stosberg
You should check both your PostgreSQL and MySQL logs for further potential details. If there's not much in the PostgreSQL log, look at the log_min_error_statementin postgresql.conf. As you'll find through that link, you can tune it to increase the amount of logging. If there's still not clues in the PostgreSQL log, I would look at other components in your system for the problem.
您应该检查 PostgreSQL 和 MySQL 日志以获取更多潜在的详细信息。如果 PostgreSQL 日志中的内容不多，请查看postgresql.conf中的log_min_error_statement。正如您将通过该链接发现的那样，您可以对其进行调整以增加日志记录量。如果 PostgreSQL 日志中仍然没有线索，我会查看您系统中的其他组件以查找问题。
