[postgis-users] raster2pgsql problem - SSL SYSCALL error EOF detected

[weston mccarron]

The only thing showing up in the log was the following:

LOG:  checkpoints are occurring too frequently (9 seconds apart)
HINT:  Consider increasing the configuration parameter
"checkpoint_segments".

I'm suspicious it had something to do with trying to do too much in one
transaction, so I've now got raster2pgsql running with the -e flag (so
there is no transaction and each insert proceeds separately). So far it's
been running for 15 minutes, I'm up to about 800k records in the table, and
there are no complaints in the log.



On Tue, Jun 2, 2015 at 3:17 PM, Bborie Park <dustymugs at gmail.com> wrote:
>
> Are you tailing the postgresql server logs? There typically is more
information in there about what's causing the error.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150602/cd5704fe/attachment.html>