On Tue, Mar 15, 2011 at 06:03, sanjay verma <sanjayi...@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/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers