Changes between Version 60 and Version 61 of InstallationGuidelines/PostgreSQL
- Timestamp:
- 03/14/12 22:57:34 (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
InstallationGuidelines/PostgreSQL
v60 v61 261 261 == Troubleshooting == 262 262 263 === Install === 264 {{{ 265 createdb: database creation failed: ERROR: encoding UTF8 does not match server's locale en_US 266 DETAIL: The server's LC_CTYPE setting requires encoding LATIN1. 267 }}} 268 269 1. Ensure all locales are available: {{{apt-get install locales-all}}} 270 1. Uncomment en_US.UTF8 in {{{/etc/locale.gen}}} 271 2. Run {{{locale-gen}}} 272 3. Rebuild the PostgreSQL cluster: {{{pg_createcluster 8.4 utf8_cluster}}} 273 274 === Performance === 263 275 * http://wiki.postgresql.org/wiki/Performance_Optimization 264 276 * http://wiki.postgresql.org/wiki/SlowQueryQuestions