PostgreSQL 8.0

# mkdir -p /home/postgresql/data
# chown -R postgres:postgres /home/postgresql
# rm -fr /var/lib/postgresql
# ln -s /home/postgresql /var/lib/postgresql

# vi /etc/locale.gen
      de_DE ISO-8859-1
      de_DE@euro ISO-8859-15
      de_DE.UTF-8 UTF-8

# locale-gen

#su -l postgres -c 'initdb -D /home/postgresql/data -E UNICODE --locale=de_DE.UTF-8'
#su -l postgres -c 'initdb -D /home/postgresql/data -E UTF8 --locale=de_DE.UTF-8'
#su -l postgres -c 'initdb -D /home/postgresql/data -E UTF-8 --locale=de_DE.UTF-8'

# su -l postgres -c 'initdb -D /home/postgresql/data --locale=de_DE.UTF-8'

oder

emerge postgresql --config

# vi /home/postgresql/data/postgresql.conf 
      listen_addresses = 'localhost'
      port = 5432
      max_connections = 1
      ssl = off
      shared_buffers = 1000                   # min 16, at least max_connections*2, 8KB each
      log_directory = '/var/log'
      log_filename = 'postgresql.log'
      log_rotation_size = 10240  # Automatic rotation of logfiles will happen after
      stats_start_collector = true
      stats_row_level = true
      timezone = CET
      #client_encoding = UTF8
      client_encoding = UTF-8
      lc_messages = 'de_DE.UTF-8'              # locale for system error message strings
      lc_monetary = 'de_DE.UTF-8'              # locale for monetary formatting
      lc_numeric = 'de_DE.UTF-8'               # locale for number formatting
      lc_time = 'de_DE.UTF-8'                  # locale for time formatting

# /etc/init.d/postgresql start

# cat /home/postgresql/backup/2008-01-14 | psql -h localhost -U postgres -d template1
# psql -h localhost -U postgres -l