Eric Smith <eric_h_smith@xxxxxxx> writes: > Following the queue on the postgres web page, I created /etc/ > sysctl.conf and added the following five entries: > kern.sysv.shmmax=4194304 > kern.sysv.shmmin=1 > kern.sysv.shmmni=32 > kern.sysv.shmseg=8 > kern.sysv.shmall=1024 > But when I try to start two servers, I get the same error. Should I > be bumping these numbers up? Yes, substantially. That's 4MB of shmem per server (SHMMAX) and also 4MB system-wide (SHMALL, which for some reason is measured in 4KB pages not bytes). The *minimum* recommendation for decent performance is 32MB per server, so you'd want shmmax = 32MB and shmall = at least 64MB, maybe more to allow for some other apps trying to use some shmem. It appeared from your log dumps that initdb has set up the parameters to fit into 4MB of shmem, which is what it's supposed to do when faced with draconian shmmax settings, but you really want to bump up shared_buffers and perhaps max_connections once you get this fixed. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
