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

Ken,

$ id
uid=998(postgres) gid=1003(postgres) groups=1003(postgres),115(ssl-cert)
$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 4128123
max locked memory (kbytes, -l) 65536
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 4128123
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

$ sysctl -a | grep shm
kernel.shm_next_id = -1
kernel.shm_rmid_forced = 0
kernel.shmall = 17179869184
kernel.shmmax = 274877906944
kernel.shmmni = 4096

Thanks,

Chris Hoover
Senior DBA
AWeber.com
Cell: (803) 528-2269
Email: chrish(at)aweber(dot)com

> On Feb 25, 2023, at 9:49 AM, Kenneth Marshall <ktm(at)rice(dot)edu> wrote:
>
>> 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