PostgreSQL Database Installation
The PostgreSQL database is where the MAPS, Argos, and MAPS auditing data is stored. The PostgreSQL database should be located on a server that is separate from the individual MAPS nodes, but is on the same network and is accessible from each node. All MAPS server nodes will connect to this database.
Refer to www.postgresql.org to download and install PostgreSQL on your database server. The installation instructions are provided in their documentation.
For information on SSL (Secure Socket Layer) authentication, see Data Connections.
The database schemas and required users will be created during the MAPS installation.
For production environments, you will need to make arrangements for the PostgreSQL server to be backed up periodically, such as every evening when usage is expected to be low. Note that MAPS is not able to perform database backups automatically as it does with standalone installations, since the database is no longer local to the MAPS server.
If you are installing your MAPS servers in a hosted environment, the PostgreSQL database server should also be hosted in that environment. Installing MAPS in other configurations may cause performance issues due to network delay between the database server and the MAPS nodes.