questions <questions.612@xxxxxxxxx> writes: > I have few other applications running on my machine but they all don't use > more than 60MB. I checked and SHMALL is in pages. I also reduced > shared_buffers and max_connections but that didn't help. Also I did ipcs > after I got the error and following is what I got - > [ lots of pre-existing segments ] Well, there's your problem. You need to clean those up. See "ipcrm", or it might be easier just to reboot the machine. > Postgres did create, attach, detach shared segments but did'nt delete them. So it would seem. What Postgres version is this, on what platform *exactly* (a kernel version number would be good)? regards, tom lane