Postgres Pro
Downloads
Home   >   mailing lists

Re: New PG14 server won't start with >2GB shared_buffers - Mailing list pgsql-admin

From Kenneth Marshall
Subject Re: New PG14 server won't start with >2GB shared_buffers
Date
Msg-id 20230225144930.GS9791@aart.rice.edu
Whole thread Raw
In response to Re: New PG14 server won't start with >2GB shared_buffers  (MichaelDBA <MichaelDBA@sqlexec.com>)
Responses Re: New PG14 server won't start with >2GB shared_buffers  (Chris Hoover <chrish@aweber.com>)
List pgsql-admin
Tree view 
> 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

pgsql-admin by date:

Previous
From: MichaelDBA
Date:
Subject: Re: New PG14 server won't start with >2GB shared_buffers
Next
From: Chris Hoover
Date:
Subject: Re: New PG14 server won't start with >2GB shared_buffers