I am trying to install postgreSQL 8.0 on a windows server 2008 R2 machine. After the installation, the service does not start. When I try to start it manually, I get a message saying that the service started and stopped automatically. I tried running the service on a postgres account and as a local system account (in the service properties).

I don't know if this is relevant, but during the installation, I got a few alert messages about "procedural languages" and "contrib files" being installed but not activated on the database.

Every log file in pg_log is empty.

Does anyone know what's going on here?

Any suggestions would be much appreciated

  • 3
    Are you sure you're really using 8.0? That seems awfully unlikely on Windows. If you are, that's horrible; once you get this sorted out plan an upgrade ASAP. To track this down you'll need to look at the Event Viewer logs, see what service start messages are produced. – Craig Ringer Aug 9 '13 at 1:38
  • 2
    Also, you seem to have posted this to stackoverflow.com/q/18138511/398670 too. Please don't cross-post like that, especially without linking between the two. It wastes everyone's time and splits up useful answers. I suggest deleting the other post. – Craig Ringer Aug 9 '13 at 1:39
  • 3
    You really shouldn't be using Postgres 8.0 any more - especially on windows. (Actually you shouldn't be using any version that starts with 8 on a new install - 8.4 will be taken out of support next July) – a_horse_with_no_name Aug 9 '13 at 7:38
  • I am installing software for a client and Postgres 8.0 is the only service that has been tested with the program. We are currently upgrading to Postgres 9.2.4, but the upgrade will not be ready for a while and in the meantime, we need to install 8 on this client's windows 2008 R2 server – user2437443 Aug 9 '13 at 17:35

Try uninstalling postgres, install this:

Reinstall postgres and see if it works then.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.