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
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/