Thread: PostgreSQL 8.4 support on Windows 2008 R2
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?
Does PostgreSQL 8.4 have any known issue on Windows 2008 R2?
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
2011-03-14 07:55:59 PDTLOG: received fast shutdown request
2011-03-14 07:55:59 PDTLOG: aborting any active transactions
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTLOG: autovacuum launcher shutting down
2011-03-14 07:55:59 PDTLOG: shutting down
2011-03-14 07:55:59 PDTLOG: database system is shut down
TIA,
Sanjay
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?
Does PostgreSQL 8.4 have any known issue on Windows 2008 R2?
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
2011-03-14 07:55:59 PDTLOG: received fast shutdown request
2011-03-14 07:55:59 PDTLOG: aborting any active transactions
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTFATAL: terminating connection due to administrator command
2011-03-14 07:55:59 PDTLOG: autovacuum launcher shutting down
2011-03-14 07:55:59 PDTLOG: shutting down
2011-03-14 07:55:59 PDTLOG: database system is shut down
TIA,
Sanjay
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/