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 ?