Re: Shared memory error

Hi,

If the dynamic shared memory segment type is POSIX then *dynamic shared
memory control segment in your case it is **PostgreSQL.1511679208* is
stored in */dev/shm*

The file you mentioned will be created at the time of PostgreSQL startup
and cleared automatically on successful shutdown.

Complete case study depicted your error is found here
<https://postgreshelp.com/postgresql-dynamic-shared-memory-posix-vs-mmap/>

https://postgreshelp.com/postgresql-dynamic-shared-memory-posix-vs-mmap/

Regards

On Thu, Jun 4, 2020 at 12:39 PM Sonam Sharma <sonams1209(at)gmail(dot)com> wrote:

> Can someone please help on this
>
> On Wed, Jun 3, 2020, 11:27 PM Sonam Sharma <sonams1209(at)gmail(dot)com> wrote:
>
>> I have set the dynamic_shared_memory_type to none which was set as POSIX.
>> For now we are not seeing the error... Can someone please explain what is
>> the impact of setting it as none .
>>
>> On Wed, Jun 3, 2020, 8:28 PM Sonam Sharma <sonams1209(at)gmail(dot)com> wrote:
>>
>>> Hi Team,
>>>
>>> Getting below error when any query is running from jdbc side :
>>>
>>> Error : could not open memory segment "/PostgreSQL.1511679208" : No such
>>> file or directory
>>>
>>> Yesterday I have extended the /dev/shm filesystem and the query ran. But
>>> today again the issue is repeating.
>>>
>>> Can someone please help
>>>
>>