MIME-Version: 1.0
References: 
 <CAFhqqtwVxtoO09_Ggj0cHaF0CiZJZ1j+Oao4_SWPcnSXX9UTWQ@mail.gmail.com>
In-Reply-To: 
 <CAFhqqtwVxtoO09_Ggj0cHaF0CiZJZ1j+Oao4_SWPcnSXX9UTWQ@mail.gmail.com>
From: Imran Khan <imran.k.23@gmail.com>
Date: Sat, 18 Jan 2025 14:52:24 +0300
Message-ID: 
 <CAC4eXDhas8vybPbUvamuzw+c64dhYf-7eLRr-jJw_EyNqZb7Wg@mail.gmail.com>
Subject: Re: Error in production postgresql database
To: jayesh thakare <thakarejayesh700@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d95781062bf9a924"
Archived-At: 
 <https://www.postgresql.org/message-id/CAC4eXDhas8vybPbUvamuzw%2Bc64dhYf-7eLRr-jJw_EyNqZb7Wg%40mail.gmail.com>
Precedence: bulk

--000000000000d95781062bf9a924
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Jayesh,

 How much is the total memory allocated on the server? How much you
allocated to shared_buffers? Is this server shared with any other instance
or there is only one instance?

Thanks,
Imran

On Sat, Jan 18, 2025, 8:13=E2=80=AFAM jayesh thakare <thakarejayesh700@gmai=
l.com>
wrote:

> Hi ,
>
> We are getting below error.
>
> psql: error: connection to server on socket "/tmp/.s.PGSQL.5444" failed:
> FATAL:   could not open shared memory segment "/PostgreSQL.4163887167": N=
o
> such file or directory...
>
>
> What is the cause of above error and solution ?
>
>
>
>
>
> Regards,
> Jayesh
>

--000000000000d95781062bf9a924
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hi Jayesh,<div dir=3D"auto"><br></div><div dir=3D"auto">=
=C2=A0How much is the total memory allocated on the server? How much you al=
located to shared_buffers? Is this server shared with any other instance or=
 there is only one instance?=C2=A0</div><div dir=3D"auto"><br></div><div di=
r=3D"auto">Thanks,</div><div dir=3D"auto">Imran</div></div><br><div class=
=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr=
">On Sat, Jan 18, 2025, 8:13=E2=80=AFAM jayesh thakare &lt;<a href=3D"mailt=
o:thakarejayesh700@gmail.com">thakarejayesh700@gmail.com</a>&gt; wrote:<br>=
</div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-l=
eft:1px #ccc solid;padding-left:1ex"><div dir=3D"auto">Hi ,<div dir=3D"auto=
"><br></div><div dir=3D"auto">We are getting below error.</div><div dir=3D"=
auto"><br></div><div dir=3D"auto">psql: error: connection to server on sock=
et &quot;/tmp/.s.PGSQL.5444&quot; failed: FATAL:=C2=A0 =C2=A0could not open=
 shared memory segment &quot;/PostgreSQL.4163887167&quot;: No such file or =
directory...</div><div dir=3D"auto"><br></div><div dir=3D"auto"><br></div><=
div dir=3D"auto">What is the cause of above error and solution ?</div><div =
dir=3D"auto"><br></div><div dir=3D"auto"><br></div><div dir=3D"auto"><br></=
div><div dir=3D"auto"><br></div><div dir=3D"auto"><br></div><div dir=3D"aut=
o">Regards,</div><div dir=3D"auto">Jayesh</div></div>
</blockquote></div>

--000000000000d95781062bf9a924--