Changes
Jump to navigation
Jump to search
Haas PhD Server Configuration (view source)
Revision as of 20:48, 12 July 2011
, 20:48, 12 July 2011→Install and Configure PostgreSQL
Review the performance tuning section on the [[Working with PostgreSQL]] page and make the following changes to ''/var/lib/pgsql/data/postgresql.conf'':
listen_addresses = '*'
port = 5432
shared_buffers = 131072
effective_cache_size = 786432
Alter ''/var/lib/pgsql/data/pg_hba.conf'' to include the lines (under IPv4):
host all all 128.32.74.0/24 md5
host all all 128.32.66.0/24 md5
host all all 128.32.67.0/24 md5
host all all 10.136.0.0/23 md5
Note that this will use encrypted database passwords, and that all accounts must have non-null passwords (i.e. be created with createuser -P username)
And restart Postgres:
