Please print the "out of shared memory error" or you need to make a provision for printing detailed error.
Deepak
Deepak
"The greatness of a nation can be judged by the way its animals are treated - Mahatma Gandhi"
+91 73500 12833
deicool@xxxxxxxxx
Facebook: https://www.facebook.com/deicool
LinkedIn: www.linkedin.com/in/deicool
deicool@xxxxxxxxx
Facebook: https://www.facebook.com/deicool
LinkedIn: www.linkedin.com/in/deicool
"Plant a Tree, Go Green"
Make In India : http://www.makeinindia.com/home
On Thu, Sep 28, 2023 at 4:55 PM Deo Felix <deofelix9@xxxxxxxxx> wrote:
The problem occurred when refreshing materialized views, out of shared memory error occurOn Thu, 28 Sept 2023 at 08:51, Deepak Goel <deicool@xxxxxxxxx> wrote:The error posted by you ( WARNING: terminating connection because of crash of another server process) is at a very high level. Can you drill down for a detailed error?
Deepak"The greatness of a nation can be judged by the way its animals are treated - Mahatma Gandhi"+91 73500 12833
deicool@xxxxxxxxx
Facebook: https://www.facebook.com/deicool
LinkedIn: www.linkedin.com/in/deicool"Plant a Tree, Go Green"Make In India : http://www.makeinindia.com/homeOn Thu, Sep 28, 2023 at 8:13 AM Deo Felix <deofelix9@xxxxxxxxx> wrote:Okay, basically I have installed this extension
pgaudit, repmgr, pgagent And I will audit them as you have advicedOn Wed, 27 Sept 2023 at 22:13, Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:> On Sep 27, 2023, at 1:07 PM, Deo Felix <deofelix9@xxxxxxxxx> wrote:
>
> Okay thank you, I have not installed the mentioned extensions
That's not the point. The point is that buggy extensions are one cause of this kind of instability, and you need to audit for *any* 3rd-party extensions in *YOUR* installation.
