[postgis-users] more memory issues with raster2pgsql

[Bborie Park]

I think you can just connect to the database with psql and issue the
following:

postgres=# SHOW client_encoding;

It should return something like...

 client_encoding
-----------------
 UTF8
(1 row)

If your database doesn't return UTF8, you can forcefully set client_encoding

ALTER DATABASE mydb
  SET client_encoding = UTF8

-bborie


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

> 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.
> _______________________________________________
> 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/20140329/35e56363/attachment.html>