[OSM-dev] postgresql issue

[Arindam Ghosh]

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