Обсуждение: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3

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

On Fri, Jun 14, 2013 at 11:55 AM, Andreas <maps.on@gmx.net> wrote:
> How can I get more memory for PG on openSUSE 12.3 ?

http://www.postgresql.org/docs/9.2/static/kernel-resources.html


--
Regards,
Peter Geoghegan

Am 14.06.2013 20:55, schrieb Peter Geoghegan:
> On Fri, Jun 14, 2013 at 11:55 AM, Andreas <maps.on@gmx.net> wrote:
>> How can I get more memory for PG on openSUSE 12.3 ?
> http://www.postgresql.org/docs/9.2/static/kernel-resources.html
>
>

OK I think that did it   :)

I'm just wondering what point it could be to set the default limits so
low in the first place as plenty of memory is so common these days.


regards
Andreas

On 06/14/2013 01:47 PM, Andreas wrote:
>
> Am 14.06.2013 20:55, schrieb Peter Geoghegan:
>> On Fri, Jun 14, 2013 at 11:55 AM, Andreas <maps.on@gmx.net> wrote:
>>> How can I get more memory for PG on openSUSE 12.3 ?
>> http://www.postgresql.org/docs/9.2/static/kernel-resources.html
>>
>>
>
> OK I think that did it   :)
>
> I'm just wondering what point it could be to set the default limits so
> low in the first place as plenty of memory is so common these days.

The type of shared memory postgresql uses is rarely used by other
systems. However, as I recall 9.3 resolves the shmmax issue as a whole
so it won't be a problem.

jD

>
>
> regards
> Andreas
>
>


--
Command Prompt, Inc. - http://www.commandprompt.com/  509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms
    a rose in the deeps of my heart. - W.B. Yeats