TheCubicWebBook #826634 add some base postgres configuration tip [resolved]

  • utf8 cluster

    psycopg2.DataError: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
    HINT:  Use the same encoding as in the template database, or use template0 as template.
    
  • authentication configuration in pg_hba.conf / using 'host=localhost' vs 'host='

    FATAL:  authentification Ident échouée pour l'utilisateur « docaster »
    
  • when a super user is required

  • plpythonu installation / make it trusted

  • template1 customization

prioritynormal
typeenhancement
done incw_course
load0.300
load left0.000
closed by<not specified>