release notes | Book: 1.9.5, 1.9.12 (opt, FHS), 2.11 (FHS), 2.12 (FHS), 2.13 (FHS), 2.14 (FHS), | Wiki | Q&A black_bg
Web: Multi-page, Single page | PDF: A4-size, Letter-size | eBook: epub black_bg

Configuring Postgres Database

Install the latest PostgreSQL database from PostgreSQL web site. While some like RPMs, others find that they have 100% guarantee of compatibility of the software only if they build it locally from sources. In later case source rpms or archive of sources are available.

We highly recommend to make sure that PostgreSQL database files are stored on a separate disk that is not used for anything else (not even PostgreSQL logging). BNL Atlas Tier one observed a great improvement in srm-database communication performance after they deployed postgres on a separate dedicated machine.

To provide seamless local access to the database please make the following modifications:

The file /var/lib/pgsql/data/pg_hba.conf should contain the following lines

local   all         all                        trust
host    all         all   trust
host    all         all         ::1/128        trust

If SRM or srm monitoring is going to be installed on a separate node, you need to add entry for this node as well:

host    all         all       <monitoring node>    trust
host    all         all       <srm node>    trust

The postgresql.conf should contain the following:

#to enable network connection on the default port
max_connections = 100
port = 5432
shared_buffers = 114688
work_mem = 10240
#to enable autovacuuming
stats_row_level = on
autovacuum = on
autovacuum_vacuum_threshold = 500  # min # of tuple updates before
                                   # vacuum
autovacuum_analyze_threshold = 250      # min # of tuple updates before
                                        # analyze
autovacuum_vacuum_scale_factor = 0.2    # fraction of rel size before
                                        # vacuum
autovacuum_analyze_scale_factor = 0.1   # fraction of rel size before
# setting vacuum_cost_delay might be useful to avoid
# autovacuum penalize general performance
# it is not set in US-CMS T1 at Fermilab
# In IN2P3 add_missing_from = on
# In Fermilab it is commented out

# - Free Space Map -
max_fsm_pages = 500000

# - Planner Cost Constants -
effective_cache_size = 16384            # typically 8KB each

To enable dCache SRM components access to the database server with the user srmdcache:

[root] # createuser -U postgres --no-superuser --no-createrole --createdb --pwprompt srmdcache

SRM will use the database dcache for storing its state information:

[root] # createdb -U srmdcache dcache