Changes between Version 61 and Version 62 of InstallationGuidelines/PostgreSQL


Ignore:
Timestamp:
06/05/12 12:19:18 (9 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/PostgreSQL

    v61 v62  
    262262
    263263=== Install ===
     264Problem:
    264265{{{
    265266createdb: database creation failed: ERROR:  encoding UTF8 does not match server's locale en_US
     
    267268}}}
    268269
    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 
     270Solution:
     271{{{
     272# Ensure all locales are available
     273apt-get install locales-all
     274sed -i 's|# en_US.UTF-8 UTF-8|en_US.UTF-8 UTF-8|' /etc/locale.gen
     275locale-gen
     276# Rebuild the PostgreSQL cluster
     277pg_createcluster 8.4 utf8_cluster
     278}}}
    274279=== Performance ===
    275280 * http://wiki.postgresql.org/wiki/Performance_Optimization