Обсуждение: BUG #7558: Postgres service not starting.

Поиск
Список
Период
Сортировка

BUG #7558: Postgres service not starting.

От
pathak.anurag@gmail.com
Дата:
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.

Please help me out.

Re: BUG #7558: Postgres service not starting.

От
Craig Ringer
Дата:
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