PostgreSQL#
Managed instance of the PostgreSQL database server.
Components#
PostgreSQL server
Configuration#
Managed PostgreSQL instances already have a good basis configuration with
reasonable sized memory parameters (for example, shared_buffers
, work_mem
).
Project-specific configuration goes into
/etc/postgresql-VERSION/postgresql-local.conf
.
Interaction#
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 /etc/init.d/postgresql-${VERSION} restart
to restart the PostgreSQL server after configuration changes (replace $VERSION with the installed PostgreSQL version).
Monitoring#
The default monitoring setup checks that the PostgreSQL server process is running and that it responds to connection attempts to the standard PostgreSQL port.
Miscellaneous#
Our PostgreSQL installations have the autoexplain feature enabled by default.