Re: BUG #5278: Postgres hangs / crashes every day

Tom and Kevin,

Thank you for your quick reply.

I am not allowed to uninstall anti virus software on this system but can configure the required exclusions. Anti Virus software being used is Symantec.

Do any of the problems I am facing are fixed in a recent release so that I can upgrade to that release?

Yesterday night while I was working on this system, I discovered that a Windows Junction Point was configured. Are there any known issues when a windows junction point is configured to the Postgres folder?

Thanks,

Murali

> To: nmmreddy11(at)hotmail(dot)com
> CC: pgsql-bugs(at)postgresql(dot)org
> Subject: Re: [BUGS] BUG #5278: Postgres hangs / crashes every day
> Date: Thu, 14 Jan 2010 18:11:24 -0500
> From: tgl(at)sss(dot)pgh(dot)pa(dot)us
>
> "Murali" <nmmreddy11(at)hotmail(dot)com> writes:
> > Postgres hangs / crashes every day (gets corrupted?). It neither serves any
> > requests from connected applications nor accepts new connections. I can’t
> > connect to the data base through PG Admin also. Below given is the log
> > snippet at the time of failure.
>
> > Log Snippet1:
> > 2009-12-16 10:59:11 FATAL: could not open relation 17253/33902/16729: No
> > such file or directory
>
> > Log Snippet2:
> > 2009-12-16 09:44:50 ERROR: could not open relation 17253/33902/16691:
> > Permission denied
>
> Given that last, I'd bet that most of your problems come from broken
> antivirus software. Remove it. Do not trust that excluding PG's data
> folder is sufficient. In fact, don't trust that turning the AV code off
> is sufficient. Uninstall it.
>
> There's some information about AV compatibility here:
> http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#What_Anti-Virus_software_is_compatible.3F
> but unexpected permissions errors are a smoking gun that should trump
> anything at all anyone may claim about particular AV code being okay.
>
> It's fairly likely that the AV code's interference has created
> corruption in your database, if Postgres was able to write some files
> but was prevented from making other parts of the same logical update.
> Once you're rid of the unexpected permissions errors, a dump and reload
> would be a good idea to try to get back to a clean state.
>
> The other thing you ought to consider is moving onto a supported version
> of Postgres. 8.0.6 is very old and has got numerous known bugs,
> particularly when running on Windows. You need at least
> 8.2.something-recent.
>
> regards, tom lane
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

_________________________________________________________________
New Windows 7: Find the right PC for you. Learn more.
http://windows.microsoft.com/shop