Re: postgres crashes - could not reattach to shared memory

On 02/05/10 12:57 PM, Sofer, Yuval wrote: <blockquote
cite="mid:2C0926ABD16BB641A8E2F11A5492004227832AFF88@PHXCCRPRD01.adprod.bmc.com"type="cite"><style>
 
<!--/* Font Definitions */@font-face{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face{font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}/* Style Definitions */p.MsoNormal, li.MsoNormal,
div.MsoNormal{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink{mso-style-priority:99;color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed{mso-style-priority:99;color:purple;text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText{mso-style-priority:99;mso-style-link:"Plain Text
Char";margin:0in;margin-bottom:.0001pt;font-size:10.5pt;font-family:Consolas;}
span.EmailStyle17{mso-style-type:personal-compose;font-family:"Calibri","sans-serif";color:windowtext;}
span.PlainTextChar{mso-style-name:"Plain Text Char";mso-style-priority:99;mso-style-link:"Plain
Text";font-family:Consolas;}
.MsoChpDefault{mso-style-type:export-only;}
@page Section1{size:8.5in 11.0in;margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1{page:Section1;}
--> </style><div class="Section1"><br /><p class="MsoPlainText">PG "FATAL:  could not reattach to shared memory
(key=5432001,addr=02100000): Invalid argument.<p class="MsoPlainText"> <br /></div></blockquote><font face="Courier
New,Courier, monospace">On windows this kind of issue, generally happens due to Firewall/Antivirus Software.<br /><br
/>Please try with disabling the firewall/antivirus software and restart the PostgreSQL.<br /><br /> Following is a
thread,which has good discussion on it:<br /><a class="moz-txt-link-freetext"
href="http://www.mail-archive.com/pgsql-general@postgresql.org/msg132613.html">http://www.mail-archive.com/pgsql-general@postgresql.org/msg132613.html</a><br
/><br/></font><br /> -- <br /><pre class="moz-signature" cols="72">Thanks & Regards,
 
Vibhor Kumar.

</pre>