Postgres SSL错误

问题描述

我试图通过SSH运行一个Drupal迁移，然后drush（命令行shell）将数据从postgres数据库复制到mysql。

它工作正常一段时间（约5分钟左右），但是我收到错误：

  SQLSTATE [HY000]：常规错误： 7 SSL [错误] SYSCALL错误：检测到EOF 
  

Postgres数据库连接似乎已经不见了，我只收到错误：

  SQLSTATE [HY000]：常规错误：7否[错误]连接到服务器
  

它在本地工作正常，所以我认为问题必须是postgres并通过SSH运行脚本 - 但是这些错误返回没有用有没有人知道可能导致这种情况？

解决方案

可能是超时。首先检查日志（可能更改ssl_renegotiation_limit）

BTW：IIRC，重新协商不会在固定的时间后发生，但在一定量的传输字符后2GB？）

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

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

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

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?

解决方案

Could be a timeout. first inspect the log (maybe change 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?)

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