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