Re: Problem in starting PGSQL8.1 service. - Mailing list pgsql-admin

From Magnus Hagander
Subject Re: Problem in starting PGSQL8.1 service.
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCEA3553A@algol.sollentuna.se
Whole thread Raw
In response to Problem in starting PGSQL8.1 service.  (RPK <rohitprakash123@indiatimes.com>)
List pgsql-admin
> I modified one of the .CONF files located in the Postgresql\Data
> Folder. I just changed the amout of shared_Buffer from 1000 to 100
> and Max_Connections from 100 to 2.
>
> But after that the PGSQL service stopped working. It stopped
> listening to the local host. I have installed PostgreSQL on my
> desktop stand-alone machine (as a service).
>
> I changed the .CONF files to their default values, but still it
> stopped working. Later I had to re-install it to get things work
> properly.
>
> Please let me know why it happened and how to get rid of this
> problem.

You need to check your logfiles - both the ones in pg_log, and the
application eventlog. They should contain a hint about what's wrong.

//Magnus



pgsql-admin by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: running PostGres without installing it
Next
From: "Magnus Hagander"
Date:
Subject: Re: Starting PostgreSQL from a windows application