I could finish the install without starting the service by closing down msiexec with ctrl+alt+del.
I looked up the log from postgresql and it says this: 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 FATAL: could not reattach to shared memory (key=1804, addr=01700000): 487 FATAL: could not reattach to shared memory (key=1804, addr=01700000): 487 etcetc. Also when I remove the program and I don't start initdb it will finish installation normally (since then it won't try and start the service I'm guessing). But it still won't start the service. The installation .zip you mentioned is only 20MB? It's postgresql v 8.3 which was provided by the program the database is used for: Holdem Manager. Thanks for the reply and I hope hearing from you soon -------------------------------------------------------------------------------------------------------------------------------------------------------------------- Frank Featherlight wrote: > I could finish the install without starting the service by closing down > msiexec with ctrl+alt+del. Hmm - wonder if the installation was complete? > I looked up the log from postgresql and it says this: > FATAL: could not reattach to shared memory (key=1804, addr=01700000): 487 Well, a bit of googling suggests 487 means "invalid address" http://archives.postgresql.org/pgsql-general/2008-06/msg00833.php Shared memory is how the various bits of PostgreSQL communicate with each other. On a linux/unix system the only error you're likely to see is because you've tried to allocate more memory than the system will allow. Since you've not finished installing yet it can't be that. However, Windows doesn't always give useful error messages, so it's worth considering other issues. Have a look for a postmaster.pid (or perhaps postgresql.pid) file somewhere in the installation - that should be created once PostgreSQL is running, and removed when it stops, so if you find one you can delete it. > Also when I remove the program and I don't start initdb it will finish > installation normally (since then it won't try and start the service I'm > guessing). But it still won't start the service. The error message is related to starting the database, so I think you're right. > > The installation .zip you mentioned is only 20MB? It's postgresql v 8.3 > which was provided by the program the database is used for: Holdem Manager. Hmm - don't know why they didn't just point you to the main website http://www.postgresql.org. Oh, that's the right size too - includes manuals too. It's all the fancy animated icon stuff that helps make apps so big. I don't see anything in the release notes for recent releases mentioning this error: http://www.postgresql.org/docs/8.3/static/release-8-3-6.html You say you've disabled your antivirus, but if it's working on the other PC, I'd still suspect it's up to something. Particularly as you mention the word that strikes terror into the heart of everyone who has to support a Windows machine: "Norton". How do you feel about uninstalling all your antivirus, reinstalling PostgreSQL and seeing if it works then? Obviously you'll reinstall your a-v after, but that will let us see if that's the problem. Oh - Windows firewall shouldn't cause a problem (unless you try to access the db from another machine), you can leave that on. -------------------------------------------------------------------------------------------------------------------------------------------------------------------- The installation was complete when I reinstalled it without having to start a initdb. I deleted the postmaster.pid file but it still does not start. I have disabled all norton services and kaspersky anti-hacker etc, PC has been rebooted couple of times and nothing is running anymore. On the other PC where it worked fine; Norton was running there aswell. Any other suggestions? I'll delete norton now but I don't think it will help :( Hoping we can fix this because I really need it to work. Hey there again, uninstalled postgresql, norton and kaspersky. deleted postgresql folder in program files. rebooted. installed postgresql again (first time same error during installation, had to use ctrl+alt+del) then installed it again (no need for initdb this time) and the installation finished. deleted the postmaster.pid file, changed the service running under ./postgress to local machine. rebooted. service still did not start. (it did create a new postmaster.pid file while trying to start service, deleted it again now) Any ideas now? Kind regards, FF.
