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
Regards
On Thu, Jun 4, 2020 at 12:39 PM Sonam Sharma <sonams1209@xxxxxxxxx> wrote:
Can someone please help on thisOn Wed, Jun 3, 2020, 11:27 PM Sonam Sharma <sonams1209@xxxxxxxxx> 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@xxxxxxxxx> 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 directoryYesterday I have extended the /dev/shm filesystem and the query ran. But today again the issue is repeating.Can someone please help
