Re: [GENERAL] SSL connection lost after long-lasting copy command

2010-02-09 Thread Steve Atkins
On Feb 9, 2010, at 9:55 AM, Seb wrote: > On Tue, 9 Feb 2010 14:44:23 -0300, > Alvaro Herrera wrote: > > [...] > >> Err, remove the renegotiation code from the server. > > Oh I meant something from a user's point of view, not hacking the source > code. If there's not a user option, I don't mi

Re: [GENERAL] SSL connection lost after long-lasting copy command

2010-02-09 Thread Alvaro Herrera
Seb escribió: > On Tue, 9 Feb 2010 14:44:23 -0300, > Alvaro Herrera wrote: > > [...] > > > Err, remove the renegotiation code from the server. > > Oh I meant something from a user's point of view, not hacking the source > code. If there's not a user option, I don't mind the connection loss as

Re: [GENERAL] SSL connection lost after long-lasting copy command

2010-02-09 Thread Seb
On Tue, 9 Feb 2010 14:44:23 -0300, Alvaro Herrera wrote: [...] > Err, remove the renegotiation code from the server. Oh I meant something from a user's point of view, not hacking the source code. If there's not a user option, I don't mind the connection loss as long as the data do get copied t

Re: [GENERAL] SSL connection lost after long-lasting copy command

2010-02-09 Thread Alvaro Herrera
Seb escribió: > On Tue, 9 Feb 2010 10:28:50 -0700, > Scott Marlowe wrote: > > > Are there any PANICs in the log before this? Doesn't seem likely from > > your description, but just wanted to be sure. > > No, there's no such lines in the log. > > AFAICS, the data did make into the table, after

Re: [GENERAL] SSL connection lost after long-lasting copy command

2010-02-09 Thread Seb
On Tue, 9 Feb 2010 10:28:50 -0700, Scott Marlowe wrote: > Are there any PANICs in the log before this? Doesn't seem likely from > your description, but just wanted to be sure. No, there's no such lines in the log. AFAICS, the data did make into the table, after psql re-established connection w

Re: [GENERAL] SSL connection lost after long-lasting copy command

2010-02-09 Thread Scott Marlowe
On Tue, Feb 9, 2010 at 10:03 AM, Seb wrote: > 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: > > ---

Re: [GENERAL] SSL connection lost after long-lasting copy command

2010-02-09 Thread Alvaro Herrera
Seb escribió: > ------ > 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". > 201

[GENERAL] SSL connection lost after long-lasting copy command

2010-02-09 Thread Seb
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: ------ server clo