Wait a minute. I wonder what your psql's client encoding is. This seems familiar...
-bborie On Mar 28, 2014 5:30 PM, "georgew" <[email protected]> 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 > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
