[postgis-users] more memory issues with raster2pgsql

[Bborie Park]

You should tell raster2pgsql to tile the raster into smaller bite-size
chucks, 256x256 is a safe value. It sounds like the raster is too big for
what memory is available.

-bborie


On Fri, Mar 28, 2014 at 5:29 PM, georgew <gws293 at hotmail.com> wrote:

> Hi, I am trying to convert a raster from SAGA GIS to Postgis using
> raster2pgsql.The command line and its output is:
> C:\\Progra~1\\PostgreSQL\\9.3\\bin\\raster2pgsql.exe -F -d -
> I -C -M -s 2193 I:\cb09\cb09_3dem.sdat cb09_3 | psql -d NZTPU
>
> Processing 1/1: I:\cb09\cb09_3dem.sdat
>
> BEGIN
> NOTICE:  table "cb09_3" does not exist, skipping
> DROP TABLE
> CREATE TABLE
> ERROR:  could not load library "C:/Program
> Files/PostgreSQL/9.3/lib/rtpostgis-2.1.dll": unknown error 998
> LINE 1: INSERT INTO "cb09_3" ("rast","filename") VALUES ('0100000100...
>                                                          ^
> ERROR:  current transaction is aborted, commands ignored until end of
> transactio
> n block
> .....
>
> I then ran again but just to create the output sql and dumped the first few
> lines of the output as follows:
>
> >C:\\Progra~1\\PostgreSQL\\9.3\\bin\\raster2pgsql.exe -F -d -
> I -C -M -s 2193 I:\cb09\cb09_3dem.sdat cb09_3 > c:\cb09.sql
> Processing 1/1: I:\cb09\cb09_3dem.sdat
>
> C:\WINDOWS\system32>more < c:\cb09.sql
> BEGIN;
> DROP TABLE IF EXISTS "cb09_3";
> CREATE TABLE "cb09_3" ("rid" serial PRIMARY KEY,"rast" raster,"filename"
> text);
> INSERT INTO "cb09_3" ("rast","filename") VALUES
> ('010000010000000000000014400000
>
> 0000000014C0000000801D5F3241000000A0BC3F5341000000000000000000000000000000009108
>
> 0000C112211C4A804FC3C788A5B3446B9CB3440C9BB34412AAB3447FFFB3449DB9B444D679B54413
>
> 06B6446859B6441C52B6441037B6446788B64468C9B64401CCB644EDAAB644797FB64458BCB64417
>
> 95B744E348B844A0C6B8447C1CB944A13AB944DE0EB944D3E0B8445E14B9445B90B9442619BA443D
> .....
>
> Finally executed the sql:
>
> C:\WINDOWS\system32>psql -U postgres -d NZTPU -f c:\cb09.sql
> BEGIN
> psql:c:/cb09.sql:2: NOTICE:  table "cb09_3" does not exist, skipping
> DROP TABLE
> CREATE TABLE
> psql:c:/cb09.sql:4: ERROR:  out of memory
> DETAIL:  String of 276576218 bytes is too long for encoding conversion.
> psql:c:/cb09.sql:5: ERROR:  current transaction is aborted, commands
> ignored
> unt
> il end of transaction block
> ........
> I assume the DLL not found is due to the lack of memory (because the file
> is
> where it should be)
> Is that assumption correct?
>
> All my databases and templates are UTF8 as shown here:
>
> <http://postgis.17.x6.nabble.com/file/n5006000/postgres.png>
>
> So why is the encoding conversion necessary?
> And more importantly how do I get around this problem?
> I am on Windows 8.1 Pro, and the very latest versions of Postgres (9.3) and
> Postgis (2.1.1)
> Many thanks for your help
>
>
>
>
> --
> View this message in context:
> http://postgis.17.x6.nabble.com/more-memory-issues-with-raster2pgsql-tp5006000.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> 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/20140328/ed264bdf/attachment.html>