[postgis-users] more memory issues with raster2pgsql

georgew gws293 at hotmail.com
Fri Mar 28 22:43:17 PDT 2014


Thanks bborie, this is what I did, but no improvement:

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

C:\WINDOWS\system32>set PGCLIENTENCODING=UTF8

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:  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...
                                                         ^
psql:c:/cb09.sql:5: ERROR:  current transaction is aborted, commands ignored
unt
il end of transaction block
psql:c:/cb09.sql:6: ERROR:  current transaction is aborted, commands ignored
unt
il end of transaction block
psql:c:/cb09.sql:7: ERROR:  current transaction is aborted, commands ignored
unt
il end of transaction block
ROLLBACK
psql:c:/cb09.sql:9: ERROR:  relation "cb09_3" does not exist
........
I tried again and the second time got the out of memory error.
What can I try next? I have searched everywhere but have not found a
suitable answer.
But as a start how can I determine what the default character set encoding
is for the server and for the client?



--
View this message in context: http://postgis.17.x6.nabble.com/more-memory-issues-with-raster2pgsql-tp5006000p5006008.html
Sent from the PostGIS - User mailing list archive at Nabble.com.


More information about the postgis-users mailing list