Postgres Pro
Downloads
Home   >   mailing lists

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

From Chris Hoover
Subject Re: New PG14 server won't start with >2GB shared_buffers
Date
Msg-id 4D0088DC-C22D-4459-A793-72FC7402DC94@aweber.com
Whole thread Raw
In response to Re: New PG14 server won't start with >2GB shared_buffers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
This is bare metal.

Thanks,

Chris Hoover

Sent from my iPhone

> On Feb 24, 2023, at 21:19, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Chris Hoover <chrish@aweber.com> writes:
>> I have a new server that has 1TB ram (not a typo).  I have been fighting with this evening to start up with a
shared_buffersetting over 2GB.  When the memory allocation  breaks 2GB, the database won’t start.  I’ve dropped it down
to500M to get the database online.  We’ve tried both SysV memory and mmap memory. 
>
> Are you running inside a VM, or cgroup, or something else that might
> be imposing a memory limit?
>
>            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: New PG14 server won't start with >2GB shared_buffers
Next
From: Ron
Date:
Subject: Re: New PG14 server won't start with >2GB shared_buffers