Postgres Pro
Downloads
Home   >   mailing lists

Re: Shared memory error - Mailing list pgsql-general

From Naresh g
Subject Re: Shared memory error
Date
Msg-id CABXEXoOG-vYsgZSN+zjvqcFv_3D=K7STSe2_SVor-rgoYniyog@mail.gmail.com
Whole thread Raw
In response to Re: Shared memory error  (Sonam Sharma <sonams1209@gmail.com>)
List pgsql-general
Tree view
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@gmail.com> wrote:
Can someone please help on this

On Wed, Jun 3, 2020, 11:27 PM Sonam Sharma <sonams1209@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 <sonams1209@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 

pgsql-general by date:

Previous
From: Paul Bonaud
Date:
Subject: Re: Fine grained permissions on User Mapping
Next
From: Thomas Munro
Date:
Subject: Re: Shared memory error