Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    5

    Red face Unanswered: Unable to (re) start PostgreSQL 8.4.4/WinXP

    I have PostgreSQL 8.4.4 on Windows XP. I cannot get the service to (re) start.

    At first installation, the service started up fine, but I couldn't access the DB remotely. So I changed the pg_hba.conf file and the postgresql.conf file as suggested.

    Now, the service seems to take forever to start up (appears to hang), then "dies" with the message: "The postgresql-8.4-PostgreSQL Server 8.4 service on Local Computer started and then stopped. Some services start automatically if they have no work to do, for example, the Performance Logs and Alerts service."

    My pg_hba.conf file has the following line:
    host all all 192.168.0.1/24 trust

    If I remove the line, the server starts up instantly. If I restore the line, the server takes for ever to start-up and ends up with the same error in this thread.

    My listen_addresses value is set to '*'.

    The postgres user already has full permissions on all the folders, including data and pg_log.

    Any suggestions?
    Thanks in advance.

  2. #2
    Join Date
    Jun 2010
    Posts
    17
    For analyzing your issue, Could you please share the pg_hba.conf file located under the data directory.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •