Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UnZ3f-00060v-T9 for pgsql-admin@arkaria.postgresql.org; Fri, 14 Jun 2013 18:49:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UnZ3f-0002KI-8a for pgsql-admin@arkaria.postgresql.org; Fri, 14 Jun 2013 18:49:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UnZ3e-0002KD-D6 for pgsql-admin@postgresql.org; Fri, 14 Jun 2013 18:49:10 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UnZ3b-0007hu-2q for pgsql-admin@postgresql.org; Fri, 14 Jun 2013 18:49:09 +0000 Received: from mailout-de.gmx.net ([10.1.76.31]) by mrigmx.server.lan (mrigmx002) with ESMTP (Nemesis) id 0M6yV9-1USTH21mL7-00woAE for ; Fri, 14 Jun 2013 20:49:05 +0200 Received: (qmail invoked by alias); 14 Jun 2013 18:49:05 -0000 Received: from mue-88-130-52-138.dsl.tropolys.de (EHLO [192.168.1.113]) [88.130.52.138] by mail.gmx.net (mp031) with SMTP; 14 Jun 2013 20:49:05 +0200 X-Authenticated: #14269776 X-Provags-ID: V01U2FsdGVkX1/C9noUtD7CLhFZoSB2ZKB/mHy8f3Hs+NOgj40xWQ OCEvR8VocoTV3I Message-ID: <51BB6704.1060805@gmx.net> Date: Fri, 14 Jun 2013 20:55:00 +0200 From: Andreas User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20130509 Thunderbird/17.0.6 MIME-Version: 1.0 To: PostgreSQL , "pgsql-admin@postgresql.org" Subject: Can't increase shared_buffers for PostgreSQL on openSUSE 12.3 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Pg-Spam-Score: -2.2 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin