====== PostgreSQL 8.0 ======


===== PostgreSQL 8.0 (Gentoo Linux) =====

  # 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