Get the default configuration file 30-postgresql-shm.conf for PostgreSQL, optimized for Debian GNU/Linux 9 (stretch). This example configuration ensures optimal compatibility and performance for PostgreSQL, making it easy to set up and adjust to meet your needs.
Find and download the configuration file here: /etc/sysctl.d/30-postgresql-shm.conf.
For more configurations and setup guides, visit our related files section to further customize your system.
# Shared memory settings for PostgreSQL on Linux
# The settings here are upper limits; performance is not affected if the
# settings are larger than necessary. If other programs use shared memory as
# well, you will have to coordinate the size settings between them.
# Maximum size of a single shared memory segment in bytes
#kernel.shmmax = 33554432
# Maximum total size of all shared memory segments in pages (normally 4096 bytes)
#kernel.shmall = 2097152
Download the raw file with wget or curl
wget -O 30-postgresql-shm.conf.example https://exampleconfig.com/static/raw/postgresql/debian9/etc/sysctl.d/30-postgresql-shm.conf
curl https://exampleconfig.com/static/raw/postgresql/debian9/etc/sysctl.d/30-postgresql-shm.conf > 30-postgresql-shm.conf.example
Other config files you might find useful