Postgresql – How to configure PostgreSQL 9.0 to start automatically under Windows XP, Part II

postgresqlwindows

Two weeks ago I asked "How do I configure Windows XP to start the postgresql demon after each boot/reboot?", and BenV helped me out with his answer:

Make sure the service is set to start automatically.

  • Start->Control Panel->Administrative Tools->Services
  • Find the service (should be named something like postgresql-9.0)
  • Make sure the Startup Type is set to Automatic

Additionally there was a problem with the password for the user postgres that I had to correct, and everything worked fine – until the 2nd reboot (I installed PostgreSQL on my developer PC, which I switch off every night). I had to correct the password again, and have to redo it ever since after every 2nd reboot.

What can I do?

Best Answer

There's also one more setting to be noted... On the same window where we set Automatic/Manual start up, there's a "Recovery" tab in which we can force the service to restart when a failure occurs.

But this might not be a good idea to use, especially on development environments, since it may help slip some possible problems past the developer's and/or administrator's eyes.

Related Question