Information
Photography
Syndicate This Blog
Wednesday, March 18. 2009
PostgreSQL Upgrade to 8.3 on Debian Encoding Issues
PostgreSQL has improved its checking for proper locale handling in version 8.3. Due to inconsistencies caused by changing defaults in past versions of Debian, some database clusters contain UTF8 and LATIN1 databases in the same cluster. This can cause problems when trying to restore from a pgdump file with errors similar to:
ERROR: encoding LATIN1 does not match server's locale en_US.UTF-8
DETAIL: The server's LC_CTYPE setting requires encoding UTF8.
Continue reading "PostgreSQL Upgrade to 8.3 on Debian Encoding Issues"
