On 06/14/2013 11:34 AM, Andreas wrote:

Hi

I just installed an openSUSE 12.3 64Bit on an i5 box with 32GB RAM.

Then I installed postgresql 9.2.4. The pg service starts with default config.

As default it has only 24 MB shared_buffers. I need it way higher like 4 or even 8 GB. As soon I change those 24 MB to something higher PG won't start anymore.

I had the same issue back with openSUSE 12.1 and it was solved when I switched from systemd back to sysvinit.

How can I get more memory for PG on openSUSE 12.3 ?

Regards Andreas

See also http://www.postgresql.org/docs/9.1/static/kernel-resources.html Scroll down a bit and you will see:

Linux The default maximum segment size is 32 MB, which is only adequate for very small PostgreSQL installations. The default maximum total size is 2097152 pages. A page is almost always 4096 bytes except in unusual kernel configurations with "huge pages" (use getconf PAGE_SIZE to verify). That makes a default limit of 8 GB, which is often enough, but not always.

The shared memory size settings can be changed via the sysctl interface. For example, to allow 16 GB:

$ sysctl -w kernel.shmmax=17179869184 $ sysctl -w kernel.shmall=4194304 In addition these settings can be preserved between reboots in the file /etc/sysctl.conf. Doing that is highly recommended.

Ancient distributions might not have the sysctl program, but equivalent changes can be made by manipulating the /proc file system:

$ echo 17179869184 >/proc/sys/kernel/shmmax $ echo 4194304 >/proc/sys/kernel/shmall The remaining defaults are quite generously sized, and usually do not require changes.

-- Explain again the part about rm -rf / -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org