Provider Notes

Provider Notes — Provider dependent notes.

Introduction

This section contains some provider dependent notes.

PostgreSQL

Default configuration files live in /var/lib/pgsql/data on Linux

Enable TCP/IP connections

Edit file postgresql.conf and search for the setting tcpip_socket and set this to true.

tcpip_socket = true


Enable hosts to connect from to PostgreSQL server.

Edit file pg_hba.conf and add a line similar as this:

host    all         all         127.0.0.1/32        trust


Change message display

Edit file postgresql.conf and add a line like this:

client_min_messages = warning

Messages of the type "NOTICE" must be avoided.