BrnDmp

Postgres Setup

set up server for client. Setup postgres environment:

• create dbuser (as user postgres): createuser -s P
• edit postgresql.conf (listen to address and port)
• edit pg_hba.conf (allowed access for maintenance host -> NOTE! first comment all default settings and start with a clean sheet, only allow specific hosts to connect)
• Later optimize postgres settings