Managed instance of the PostgreSQL database server.
- PostgreSQL server (9.6, 10, 11, or 12)
Managed PostgreSQL instances already have a production-grade configuration with reasonable sized memory parameters (for example, shared_buffers, work_mem).
Project-specific configuration can be placed in into
Service users can use sudo -u postgres -i to access the PostgreSQL super user account to perform administrative commands like createdb and createuser.
Both service users and the postgres DB super user may invoke sudo fc-manage --build to apply configuration changes and restart the PostgreSQL server (if necessary).
The default monitoring setup checks that the PostgreSQL server process is running and that it responds to connection attempts to the standard PostgreSQL port.
Our PostgreSQL installations have the autoexplain feature enabled by default.