|
Hello team, I'm getting below error while accessing postgres11 database. Please suggest the solution for this issue. Cause: org.postgresql.util.PSQLException: ERROR: could not resize shared memory segment "/PostgreSQL.1946998112" to 8388608 bytes: No space left on device at com.caucho.el.ArrayResolverExpr.invoke(ArrayResolverExpr.java:260) Details from docker : bash-4.4$ mount | grep /dev/shm shm on /dev/shm type tmpfs (rw,context="system_u:object_r:container_file_t:s0:c127,c569",nosuid,nodev,noexec,relatime,size=65536k) bash-4.4$ free && ipcs -l && echo "page size:" && getconf PAGE_SIZE total used free shared buffers cached Mem: 32779840 24612300 8167540 0 52 23735916 -/+ buffers/cache: 876332 31903508 Swap: 4063228 91136 3972092 ------ Messages: Limits -------- max queues system wide = 16384 max size of message (bytes) = 8192 default max size of queue (bytes) = 16384 ------ Shared Memory Limits -------- max number of segments = 4096 max seg size (kbytes) = 18014398509465599 max total shared memory (pages) = 18446744073692774399 min seg size (bytes) = 1 ------ Semaphore Limits -------- max number of arrays = 128 max semaphores per array = 250 max semaphores system wide = 32000 max ops per semop call = 32 semaphore max value = 32767 page size: 4096 bash-4.4$ bash-4.4$ psql psql (11.2) Type "help" for help. postgres=# show max_parallel_workers_per_gather; max_parallel_workers_per_gather --------------------------------- 2 (1 row) postgres=# show max_parallel_workers_per_gather; max_parallel_workers_per_gather --------------------------------- 2 (1 row) postgres=# Thanks, |
