From: | Frank Featherlight <dirtydude(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Service not starting: Error 1053 |
Date: | 2009-02-21 13:26:39 |
Message-ID: | 463114950902210526w680bdab7ge7416c784dc6de16@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hey guys,
I had two running threads here:
http://archives.postgresql.org/pgsql-general/2009-02/msg00859.php
http://www.postgresqlforums.com/forums/viewtopic.php?f=41&t=1574
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-02-21 18:46:07 | Okay to change TypeCreate() signature in back branches? |
Previous Message | Robert Haas | 2009-02-21 02:15:16 | Re: The science of optimization in practical terms? |