Re: BUG #7558: Postgres service not starting. - Mailing list pgsql-bugs

From Craig Ringer
Subject Re: BUG #7558: Postgres service not starting.
Date
Msg-id 505A7DE5.5020707@ringerc.id.au
Whole thread Raw
In response to BUG #7558: Postgres service not starting.  (pathak.anurag@gmail.com)
List pgsql-bugs
On 09/19/2012 09:21 PM, pathak.anurag@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      7558
> Logged by:          Anurag
> Email address:      pathak.anurag@gmail.com
> PostgreSQL version: 8.4.13
> Operating system:   Microsoft 2008 Server
> Description:
>
> Hello,
>
> I installed Postgres and tried by populating SHP files form PostGIS pulgin.
> When I tried to update pg_hba.conf for adding a CIDR addrs. When I connected
> again It shows following error-
> ERROR  : Error connecting to the server: FATAL:  could not load pg_hba.conf
>
> after that when I am trying to connect the database by double clicking, it
> is showing service is not present, start the service first.

There is no sign that this is a bug. Try asking on the pgsql-general
mailing list or Stack Overflow. Include more detail, in particular check
your `pg_log` folder and get the most recent log messages. Also check
the Windows event viewer for service messages related to PostgreSQL.

Guesses:

- Your text editor still has pg_hba.conf open. In Windows that locks the
file so PostgreSQL can't open it.

- You changed the file permissions when you replaced/edited pg_hba.conf,
so PostgreSQL can't open it now.

- You edited pg_hba.conf incorrectly, creating syntax errors.

Please do not reply to me, post on -general or SO.

--
Craig Ringer

pgsql-bugs by date:

Previous
From: Reinhard Max
Date:
Subject: Re: BUG #7559: syslogger doesn't close stdout and stderr
Next
From: Craig Ringer
Date:
Subject: Re: BUG #7556: "select not in sub query" plan very poor vs "not exists"