Changes between Version 61 and Version 62 of InstallationGuidelines/PostgreSQL

Timestamp:

06/05/12 12:19:18 (13 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/PostgreSQL

@@ -262 +262 @@
 
 === Install ===
+Problem:
 {{{
 createdb: database creation failed: ERROR:  encoding UTF8 does not match server's locale en_US
@@ -267 +268 @@
 }}}
 
-1. Ensure all locales are available: {{{apt-get install locales-all}}}
-1. Uncomment en_US.UTF8 in {{{/etc/locale.gen}}}
-2. Run {{{locale-gen}}}
-3. Rebuild the PostgreSQL cluster: {{{pg_createcluster 8.4 utf8_cluster}}}
-
+Solution:
+{{{
+# Ensure all locales are available
+apt-get install locales-all
+sed -i 's|# en_US.UTF-8 UTF-8|en_US.UTF-8 UTF-8|' /etc/locale.gen
+locale-gen
+# Rebuild the PostgreSQL cluster
+pg_createcluster 8.4 utf8_cluster
+}}}
 === Performance ===
  * http://wiki.postgresql.org/wiki/Performance_Optimization