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 <sonams1...@gmail.com> wrote: > Can someone please help on this > > On Wed, Jun 3, 2020, 11:27 PM Sonam Sharma <sonams1...@gmail.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 <sonams1...@gmail.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 >>> >>
