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

[Bborie Park]

How strange. I'm betting some hardware limitation (you didn't specify the
amount of memory or disk space) or default PostgreSQL config setting is
causing this behavior. I don't know which exact PostgreSQL setting but
that's because I always reconfig my servers. For good performance, I
strongly urge you to reconfigure that server. At the very least, take a
read through...

https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

-bborie

On Tue, Jun 2, 2015 at 4:04 PM, weston mccarron <quantumpsychotics at gmail.com
> wrote:

> 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.
> >
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150602/6cc8d45d/attachment.html>