Hi, While copying a large'ish file (~ 7.6 million rows) into a table with: \copy [tablename] ([columns]) FROM '/path/to/large/file' NULL AS '' The command stopped running after a few minutes with the message: ---<--------------------cut here---------------start------------------->--- server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. ---<--------------------cut here---------------end--------------------->--- Checking /var/log/postgresql/postgresql-8.4-main.log, there's a long series of checkpoint_segments (only the last 2 shown) and an SSL error: ---<--------------------cut here---------------start------------------->--- 2010-02-09 10:47:03 CST LOG: checkpoints are occurring too frequently (6 seconds apart) 2010-02-09 10:47:03 CST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2010-02-09 10:47:10 CST LOG: checkpoints are occurring too frequently (7 seconds apart) 2010-02-09 10:47:10 CST HINT: Consider increasing the configuration parameter "checkpoint_segments". 2010-02-09 10:47:17 CST LOG: SSL renegotiation failure 2010-02-09 10:47:17 CST LOG: SSL renegotiation failure 2010-02-09 10:47:17 CST LOG: SSL error: internal error 2010-02-09 10:47:17 CST LOG: could not send data to client: Connection reset by peer 2010-02-09 10:47:17 CST LOG: SSL error: internal error 2010-02-09 10:47:17 CST LOG: could not receive data from client: Connection reset by peer 2010-02-09 10:47:17 CST LOG: unexpected EOF on client connection ---<--------------------cut here---------------end--------------------->--- Any pointers appreciated. Thanks. -- Seb -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
