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 _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
