From: Kenneth Marshall <ktm@rice.edu>
To: MichaelDBA <MichaelDBA@sqlexec.com>
Cc: Chris Hoover <chrish@aweber.com>
Cc: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: New PG14 server won't start with >2GB shared_buffers
Date: Sat, 25 Feb 2023 08:49:30 -0600
Message-ID: <20230225144930.GS9791@aart.rice.edu> (raw)
In-Reply-To: <4a41387e-516e-0782-6110-89c05a99d020@sqlexec.com>
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>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ktm@rice.edu, MichaelDBA@sqlexec.com, chrish@aweber.com, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: New PG14 server won't start with >2GB shared_buffers
In-Reply-To: <20230225144930.GS9791@aart.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox