Unable to (re) start PostgreSQL 8.4.4/WinXP

From: kunalashar <kunalashar(at)aol(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Unable to (re) start PostgreSQL 8.4.4/WinXP
Date: 2010-06-14 04:33:53
Message-ID: 28875697.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.
--
View this message in context: http://old.nabble.com/Unable-to-%28re%29-start-PostgreSQL-8.4.4-WinXP-tp28875697p28875697.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-06-14 04:52:15 Re: Unable to (re) start PostgreSQL 8.4.4/WinXP
Previous Message John T. Dow 2010-06-14 03:17:56 Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied