Get the default configuration file 30-postgresql-shm.conf for PostgreSQL, optimized for Debian GNU/Linux 10 (buster). 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/debian10/etc/sysctl.d/30-postgresql-shm.conf
curl https://exampleconfig.com/static/raw/postgresql/debian10/etc/sysctl.d/30-postgresql-shm.conf > 30-postgresql-shm.conf.example
Other config files you might find useful