The database is hosted on a fixed number of servers within the internal trust boundary in a failover configuration. The database in question is a PostgreSQL installation running on a Linux(RHEL) system which is networked to the backend system via a gateway which utilizes NAT rules to direct traffic from internal systems specifically. The backend system is provided with database authentication by default, without the standard username and password required as it is within the...
The database is hosted on a fixed number of servers within the internal trust boundary in a failover configuration. The database in question is a PostgreSQL installation running on a Linux(RHEL) system which is networked to the backend system via a gateway which utilizes NAT rules to direct traffic from internal systems specifically. The backend system is provided with database authentication by default, without the standard username and password required as it is within the internal trust boundary. This authentication is provided by allowing all internal traffic by specifying the internal IP ranges within the PG_HBA configuration file within the PostgreSQL data directory. System failover is introduced by including a floating address which moves between systems based on necessity, and the database is regularly backed up via an automated cronjob.