Re: Shared memory error

Поиск
Список
Период
Сортировка
От Naresh g
Тема Re: Shared memory error
Дата
Msg-id CABXEXoOG-vYsgZSN+zjvqcFv_3D=K7STSe2_SVor-rgoYniyog@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Shared memory error  (Sonam Sharma <sonams1209@gmail.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Paul Bonaud
Дата:
Сообщение: Re: Fine grained permissions on User Mapping
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Shared memory error