Hi,
I am trying to import this shapefile into a database on my new server:
http://sedac.ciesin.columbia.edu/povmap/downloads/ds_global/imr_shapefile.zip
While this was no problem on my old server running Windows Vista, i now have
problems on my Ubuntu Server.
My last server had the LC_COLLATE AND LC_CTYPE blank, while the new Linux
has en_US.UTF-8 which seems to create the problems.
I tried creating a new database on the new server with blank COLLATE and
CTYPE, but it would not accept blank.
Any ideas?
Thanks,
Andreas
The old database had the following settings on Enconding:
CREATE DATABASE newpg
WITH OWNER = -----
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = ''
LC_CTYPE = ''
CONNECTION LIMIT = -1;
The database on the new server has the following:
CREATE DATABASE priogrid
WITH OWNER = -----
ENCODING = 'UTF8'
TABLESPACE = pg_default
LC_COLLATE = 'en_US.UTF-8'
LC_CTYPE = 'en_US.UTF-8'
CONNECTION LIMIT = -1;
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
