Can't increase shared_buffers for PostgreSQL on openSUSE 12.3

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
Date: 2013-06-14 18:55:00
Message-ID: 51BB6704.1060805@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi

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

Then I installed postgresql 9.2.4 from their repository.
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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Geoghegan 2013-06-14 18:55:53 Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
Previous Message Michael Kussmaul 2013-06-14 17:04:19 VACUUM FULL into another tablespace?

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2013-06-14 18:55:53 Re: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3
Previous Message Joshua D. Drake 2013-06-14 16:16:24 Re: PSA: If you are running Precise/12.04 upgrade your kernel.