How to start postgres database service in windows 7

Posted on 2011-10-13
Medium Priority
Last Modified: 2012-06-21
I have installed PostgreSQL 8.4 in my Windows 7 System. Installation have created new user "postgres" and give service access to that user. After complete the installation I have restart the system and login using my id. But Postgres Service not started and couldn't start that service manually.
I want to set that service should start automatically when any user login my system using their id. Please let me know how to do this
Question by:gajmp
  • 2
LVL 14

Accepted Solution

Dhiraj Mutha earned 400 total points
ID: 36967038

Assisted Solution

gajmp earned 0 total points
ID: 36983051
Thanks for your reply. I have solved this by installing Postgres superuser as LocalSystem.
postgres,exe --superuser LocalSystem

Now any authenticated user of the system can login and access Postgres

Author Closing Comment

ID: 37010597
Expert comment help me to think in that way got the solution.

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

OfficeMate Freezes on login or does not load after login credentials are input.
When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses
Course of the Month16 days, 7 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question