[OSM-dev] postgresql issue
Arindam Ghosh
makghosh at gmail.com
Sat Mar 7 07:32:04 GMT 2009
Hi all
I updated to postgresql-8.3-postgis in the freemap.in which was
required for new mapnik
[http://trac.mapnik.org/wiki/DebianInstallation]
The mapnik from the svn was in turn required for latest mod_tile.
But now as i create a new db say 'gis' ex:
$ createdb -E UTF8 -0 username gis
I get following error related to encoding actually:
----------------------
createdb: database creation failed: ERROR: encoding UTF8 does not
match server's locale en_US
DETAIL: The server's LC_CTYPE setting requires encoding LATIN1.
----------------------
On googling, i found some similar recent threads like [1] & [2]
The threads semms to suggest for fixing LC_ALL variable and then
re-initdb. But that may require db backup and restore.
Is there any simpler way to get around this thing?? Please help me on this :)
[1] http://archives.postgresql.org/pdxpug/2009-02/msg00011.php
[2] http://www.nabble.com/Locale---Encoding-mismatch-td16384677.html
--best regards
Arindam
--
Arindam Ghosh
[http://arindamghosh.wordpress.com]
GPG Key: 0EE58920
Key Server: http://pgp.mit.edu
More information about the dev
mailing list