Postgres SSL error

postgresql drupal postgresql-8.4
Ben Scott picture Ben Scott · Jul 12, 2012 · Viewed 13.7k times · Source

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?

Answer

wildplasser picture wildplasser · Jul 18, 2012

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?)

Related questions

Postgres 9.2 - add conditional constraint check

I'm using PostgreSQL 9.2 and need to add a conditional constraint on a column. Essentially I want to make sure that a column is false when two other columns have a certain value. gid | int_unsigned | not null default 0 realm | character …

Read More
PostgreSQL: Show tables in PostgreSQL

What's the equivalent to show tables (from MySQL) in PostgreSQL?

Read More
PostgreSQL: How to change PostgreSQL user password?

How do I change the password for PostgreSQL user?

Read More