Yes, the table is bigger than 512MB. Thank got your tips.
Best Regard, Torello 2013/8/26 Rafael Martinez Guerrero <r.m.guerr...@usit.uio.no> > On 08/26/2013 06:37 PM, Torello Querci wrote: > > > > > > In this moment I get this error while executing the restore of the big > > table in a different database on the same machine: > > > > psql:dump_ess_2013_08_26.sql:271177424: SSL error: sslv3 alert > > unexpected message > > psql:dump_ess_2013_08_26.sql:271177424: connection to server was lost > > > > Hello > > This error has probably nothing to do with your index problem. > > How big is the restore file you are restoring? More than 512MB? > > We had a similar error in our RHEL6 servers and the problem was that the > server could not SSL renegotiate. Some systems has SSL libraries that > are incapable of SSL renegotiation as a safeguard against (old) bugs in > the protocol. > > If you are doing a restore of a database/table bigger than 512MB and > your system can not do SSL renegotiation, you have to change the > parameter ssl_renegotiation_limit to 0 in your postgresql.conf and > restart postgreSQL. > > regards, > -- > Rafael Martinez Guerrero > Center for Information Technology > University of Oslo, Norway > > PGP Public Key: http://folk.uio.no/rafael/ >
