Operations_Database

Database

TalentMAP uses PostgreSQL 9.6 as it's data store.

There are two specific files that require configuration.

pg_hba.conf - this file is where user access is configured

postgres.sql - the core configuration for there server. The IP binding is for listening is defined here.

service postgres-9.6 status

service postgres-9.6 restart

service postgres-9.6 stop

It is a good practice to periodically rotate passwords. This is can be completed by,

ALTER ROLE app_user WITH PASSWORD 'password';

where app_user is the account. PostgreSQL documentation