Re: New PG14 server won't start with >2GB shared_buffers

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: MichaelDBA <MichaelDBA(at)sqlexec(dot)com>
Cc: Chris Hoover <chrish(at)aweber(dot)com>, Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: New PG14 server won't start with >2GB shared_buffers
Date: 2023-02-25 14:49:30
Message-ID: 20230225144930.GS9791@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> 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(at)aweber(dot)com

Hi Chris,

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

Regards,
Ken

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2023-02-25 14:51:09 Re: New PG14 server won't start with >2GB shared_buffers
Previous Message MichaelDBA 2023-02-25 14:05:44 Re: New PG14 server won't start with >2GB shared_buffers