How to start postgres database service in windows 7

Posted on 2011-10-13
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
    LVL 14

    Accepted Solution

    LVL 3

    Assisted Solution

    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
    LVL 3

    Author Closing Comment

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

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    First some basics on Windows 7 Backup.  It has 2 components one is a file based backup which is stored in .zip files each zip is split at around 200 Megabytes and there is the Image Backup which is as the name implies a total image of the partition …
    The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
    In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
    This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now