> Minimum shared mem: 140731400 bytes = 135.0 MB > Maximum shared mem: 268435456 bytes = 256.0 MB > > kern.ipc.shmmin="140731400" > kern.ipc.shmmax="268435456" > > Nov 13 20:46:19 neptunus postgres[669]: [1-2] DETAIL: Failed system > call was shmget(key=5432001, size=21725184, 03600).
The shared memory request, according to the error message, was for ~20 MB, far less than the 135 MB minimum limit you put in the kernel. You'll need to lower the limit or raise your request size, probably with regards to shared_buffers, as I think you're only allocating 2 MB to shared_buffers. You'll want to raise that on a production machine. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster