Database server role requirements

This page contains the functional requirements for the Database Server role - that is, the things the role is expected to do when it's working properly. If Database Server is a Featured Role, then according to the Fedora_Release_Criteria, these requirements must be met to some extent for each Fedora Server pre-release and release: refer to the criteria pages for the exact details of which requirements must be met at each milestone.

Unless otherwise stated, it is always assumed that the role has been correctly deployed and configured by the system administrator.

Core requirements

1. A deployed Database Server must provide a PostgreSQL instance which will serve requests from the local system on port 5432.
2. The core command line utilities for PostgreSQL must be available and correctly handle:

   Basic configuration of the PostgreSQL instance itself.

   Basic SQL interactions, including creation, modification, deletion, and simple querying of users, tables, columns, and rows.

3. Multiple clients must be able to connect simultaneously to the PostgreSQL instance.

Requirements

1. The Database Server must serve requests from remote systems on port 5432 by default, but it must also be possible to disallow remote access using the role mechanism.
2. The server must be capable of hosting multiple separate databases.
3. The server must allow external software to edit the database.

Test cases

1. QA:Testcase_database_server_remote_client