Hey guys,
I had two running threads here:
Both have not come to a succesful conclusion.
In very short (but you better read the threads):
During installation it stops at the point of starting service (not able to start it), so I have to use ctrl+alt+del to close msiexec.
When I install it again it completes fine, because no initdb is needed after first time (but still service is not starting after installation.
When I tried starting service via Administrative Tools it gives the following error:
"The PostgreSQL Database Server 8.3-service on Local Computer has been started and stopped. Some services stop automatically when they have nothing to do, like Performance Logs and Alerts-service" (translated from dutch).
This was in the postgresql log:
FATAL: could not reattach to shared memory (key=1804, addr=01700000): 487
2009-02-19 15:51:01 CET LOG: database system was shut down at 2009-02-19 05:22:30 CET
2009-02-19 15:51:02 CET LOG: database system is ready to accept connections
2009-02-19 15:51:02 CET LOG: autovacuum launcher started
FATAL: could not reattach to shared memory (key=1804, addr=01700000): 487
Then I tried the following:
- uninstall all anti-virus/firewall progs
- change the service running under ./postgress to local system
- lowering shared_memory in postgresql.conf
- deleted postmaster.pid
- sfc /scannow
During this I reinstalled the prog every time and rebooted, nothing worked, though the last on the list changed the error in Administrative Tools (Services) to:
Can not start the PostgreSQL Database 8.3-service on Local computer.
Error 1053: The service did not respond correctly to the start- or sendcommand.
(translated from Dutch)
And the postgresql log says this:
FATAL: could not reattach to shared memory (key=1764, addr=01650000): 487
2009-02-20 02:15:48 CET LOG: database system was interrupted; last known up at 2009-02-20 00:04:52 CET
2009-02-20 02:15:49 CET LOG: database system was not properly shut down; automatic recovery in progress
2009-02-20 02:15:49 CET LOG: record with zero length at 0/496398
2009-02-20 02:15:49 CET LOG: redo is not required
2009-02-20 02:15:49 CET LOG: database system is ready to accept connections
2009-02-20 02:15:49 CET LOG: autovacuum launcher started
FATAL: could not reattach to shared memory (key=1764, addr=01650000): 487
Hoping you can help me,
Kind regards, Frank.
PS: I use Windows XP Service Pack 3 (formerly SP2, same error, does not matter). Pentium Dual Core 2.8gHz, 1GB DDR2, nuff GB free.