title: How to set encoding to PostgreSQL data base?
body: <p>I cant see cyrillic symbols in PostgreSQL 9.1 on Linux Mint. So i want to create new bd with cyrillic encoding. I says:</p>
  
  <pre><code>CREATE DATABASE ekb_1 ENCODING 'CP1251' TEMPLATE postgistemplate;
  </code></pre>
  
  <p>but get error:</p>
  
  <pre><code>postgres=# CREATE DATABASE ekb_1 ENCODING 'WIN1251' TEMPLATE postgistemplate;
  ERROR:  encoding WIN1251 does not match locale ru_RU.UTF-8
  ПОДРОБНОСТИ:  The chosen LC_CTYPE setting requires encoding UTF8.
  </code></pre>
  
  <p>i try to add <code>lc_type 'ru_RU.WIN1251'</code> but not help.<br>
  Whats wrong?</p>