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 <dustym...@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@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Reply via email to