On Tue, Mar 15, 2011 at 06:03, sanjay verma <sanjayiisc@yahoo.com> wrote:
> Hi,
>
> I have installed PostgreSQL 8.4 on Windows 2008 R2 64 bit server. However,
> the PostgreSQL service stops intermittently.
>
> Is PostgreSQL 8.4 supported on Windows 2008 R2?
Yes.
> Does PostgreSQL 8.4 have any known issue on Windows 2008 R2?
No.
> The following is pg log when the service stopped:
>
> 2011-03-14 07:50:04 PDTWARNING: there is no transaction in progress
> 2011-03-14 07:54:15 PDTFATAL: password authentication failed for user
> "postgres"
> 2011-03-14 07:55:58 PDTERROR: could not open relation base/16395/17170:
> Permission denied
> 2011-03-14 07:55:58 PDTCONTEXT: writing block 0 of relation
> base/16395/17170
That right there is your problem. PostgreSQL is attempting to open one
of it's files, and is not getting permission to do so.
The most common reason for this (other than not actually having
permissions) some some sort of antivirus or antispyware software
installed. If you have that, try removing it and see if the problem
goes away. You may also need to reset the permissions on the
directories, if they are broken at that level. Note that just
disabling the antivirus for specific files/directories/processes is
often not enough, you have to actually uninstall it in most cases.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/