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