[postgis-users] more memory issues with raster2pgsql

[georgew]

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.