Re: New PG14 server won't start with >2GB shared_buffers
| От | Chris Hoover |
|---|---|
| Тема | Re: New PG14 server won't start with >2GB shared_buffers |
| Дата | |
| Msg-id | B6A7F0D1-D06E-43F1-8787-BE90ADB3D05D@aweber.com обсуждение исходный текст |
| Ответ на | Re: New PG14 server won't start with >2GB shared_buffers (Kenneth Marshall <ktm@rice.edu>) |
| Ответы |
Re: New PG14 server won't start with >2GB shared_buffers
|
| Список | pgsql-admin |
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@aweber.com
On Feb 25, 2023, at 9:49 AM, Kenneth Marshall <ktm@rice.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@aweber.com
Hi Chris,
What are your limits set to for the account that the database runs as?
Regards,
Ken
В списке pgsql-admin по дате отправления: