Set postgresql template1 encoding to UTF8 in Puppet.

postgresql-template1-encodinf.pp

  exec { "postgresql-template1-utf8":
    command => "psql -c \"update pg_database set datistemplate=false where datname='template1';\" &&
                psql -c 'drop database Template1;' &&
                psql -c \"create database template1 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;\"
                ",
    user    => "postgres",
    path    => "/usr/bin",
    unless  => "/usr/bin/psql -Atc \"select pg_encoding_to_char(encoding) from pg_database where datname='template1'\" | /bin/grep -c UTF8"
  }