title: PostgreSQL 9.1 installation and database encoding
body: <p>I just did my first install of PostgreSQL 9.1 on Ubuntu 10.04.</p>
  
  <p>note: I have done it a few times on Windows with an installer without issues.</p>
  
  <p>After a bit of effort, I got it set up to connect remotely via pgAdminIII.  However, I was really surprised after connecting to the db, that I got a warning about the encoding.  The "postgres" database itself was created with "SQL_ASCII" encoding.  Every time that I've installed on windows, it created the postgres DB with "UTF8" - which seems like it would be a lot better and would stop the warning message when opening up the database via pgAdminIII.</p>
  
  <p>Is there something I did wrong?  Is there an installation option/param to use to set the default encoding to use?</p>
  
  <p>And is there anyway to fix this?  I've read some things on the web that says that you need to dumb and restore to change the encoding of a database, but I'm not sure this is even possible on the postgres db.  Is it?</p>
  
  <p>Thanks for your help! </p>