Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1pVvrk-0003Nq-Rg
	for pgsql-admin@arkaria.postgresql.org; Sat, 25 Feb 2023 14:49:36 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1pVvrj-0006f1-OF
	for pgsql-admin@arkaria.postgresql.org; Sat, 25 Feb 2023 14:49:35 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <ktm@aart.rice.edu>)
	id 1pVvrj-0006eh-CG
	for pgsql-admin@lists.postgresql.org; Sat, 25 Feb 2023 14:49:35 +0000
Received: from aart.rice.edu ([168.7.56.48])
	by magus.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <ktm@aart.rice.edu>)
	id 1pVvrg-0007oL-72
	for pgsql-admin@lists.postgresql.org; Sat, 25 Feb 2023 14:49:34 +0000
Received: by aart.rice.edu (Postfix, from userid 18612)
	id 57D0140D3630; Sat, 25 Feb 2023 08:49:30 -0600 (CST)
Date: Sat, 25 Feb 2023 08:49:30 -0600
From: Kenneth Marshall <ktm@rice.edu>
To: MichaelDBA <MichaelDBA@sqlexec.com>
Cc: Chris Hoover <chrish@aweber.com>, Ron <ronljohnsonjr@gmail.com>,
	pgsql-admin@lists.postgresql.org
Subject: Re: New PG14 server won't start with >2GB shared_buffers
Message-ID: <20230225144930.GS9791@aart.rice.edu>
References: <A446608A-42A3-4CBB-BD45-47BE009B0029@aweber.com>
 <4b583c4a-022f-f452-c0c8-0a932a6ee411@gmail.com>
 <C6285AA6-5195-4C8B-A599-401845EFD174@aweber.com>
 <4a41387e-516e-0782-6110-89c05a99d020@sqlexec.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <4a41387e-516e-0782-6110-89c05a99d020@sqlexec.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/20230225144930.GS9791%40aart.rice.edu>
Precedence: bulk

> Chris Hoover wrote on 2/25/2023 8:07 AM:
> >Ron,
> >
> >Honestly, I grabbed 500MB to get the database up, by this time I
> >was very frustrated and just wanted it up.  :)  I think I was at
> >1500MB and it still would not start.  So to save what was left of
> >my evening out, I just picked 500.
> >
> >Here is shmall:
> >kernel.shmall = 17179869184
> >
> >Thanks,
> >
> >
> >Chris Hoover
> >Senior DBA
> >AWeber.com
> >Cell: (803) 528-2269
> >Email: chrish@aweber.com

Hi Chris,

What are your limits set to for the account that the database runs as?

Regards,
Ken