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.