From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unable to (re) start PostgreSQL 8.4.4/WinXP |
Date: | 2010-06-14 04:52:15 |
Message-ID: | 4C15B57F.7040406@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
kunalashar wrote:
> 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 errors in the latest file in pg_log ?
From | Date | Subject | |
---|---|---|---|
Next Message | kunalashar | 2010-06-14 05:10:03 | Re: Unable to (re) start PostgreSQL 8.4.4/WinXP |
Previous Message | kunalashar | 2010-06-14 04:33:53 | Unable to (re) start PostgreSQL 8.4.4/WinXP |