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

[weston mccarron]

Yeah, it may be a setting. I had read that document and done some tweaking
and customizing on the initial 9.3 database where I started having the
problem. I thought maybe one of my custom settings was the problem, which
was one reason I tried again with a fresh install.

After about three hours, it appears to have finished just fine with the -e
flag and piping raster2pgsql straight into psql. 8 million records total in
the table.

Thanks a lot for your help, Bborie.



On Tue, Jun 2, 2015 at 5:35 PM, Bborie Park <dustymugs at gmail.com> wrote:

> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150602/55d266b5/attachment.html>