Обсуждение: Error in production postgresql database
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": No such file or directory...
What is the cause of above error and solution ?
Regards,
Jayesh
A 30 second Google found me the answer:
On Sat, Jan 18, 2025 at 12:13 AM jayesh thakare <thakarejayesh700@gmail.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": No such file or directory...What is the cause of above error and solution ?Regards,Jayesh
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
Check your shared buffer setting. You may need to increase it
Sent via the Samsung Galaxy S22+ 5G, an AT&T 5G smartphone
-------- Original message --------
From: jayesh thakare <thakarejayesh700@gmail.com>
Date: 1/18/25 1:13 AM (GMT-04:00)
To: pgsql-admin@postgresql.org
Subject: Error in production postgresql database
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": No such file or directory...
What is the cause of above error and solution ?
Regards,
Jayesh
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 AM jayesh thakare <thakarejayesh700@gmail.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": No such file or directory...What is the cause of above error and solution ?Regards,Jayesh