HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How can I configure PostgreSQL 9.0 to start automatically under Windows XP?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
postgresqlcanhowautomaticallyunderwindowsstartconfigure

Problem

Yesterday I installed PostgreSQL 9.0 on Windows XP, and after the installation the DB was running. After booting the system this morning, the data base server did not start automatically.

How do I configure Windows XP to start the postgresql demon after each boot/reboot? (I'm a Unix guy, and guess that's easy for someone knowing Windows.)

Solution

Here's a couple things to check:

-
I believe the Windows PostgreSQL installer has an option you have to check saying you want to run PostgreSQL as a service. Make sure you used this option when you did your install.

-
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

Context

StackExchange Database Administrators Q#580, answer score: 9

Revisions (0)

No revisions yet.