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