Unable to increase shared buffer above 8GB in postgresql 12 DB where we have enough memory on OS and we tried to tune SHMALL and SHMMAX on OS but no luck!
Please suggest .
2023-11-03 13:58:00.159 IST  FATAL: could not map anonymous shared memory: Cannot allocate memory
2023-11-03 13:58:00.159 IST  HINT: This error usually means that PostgreSQL’s request for a shared memory segment exceeded available memory, swap space, or huge pages. To reduce the request size (currently 35214278656 bytes), reduce PostgreSQL’s shared memory usage, perhaps by reducing shared_buffers or max_connections.
2023-11-03 13:58:00.159 IST  LOG: database system is shut down