Thread: Pgsql beta 8 on windows starts and stops automatically.

Pgsql beta 8 on windows starts and stops automatically.

From
Terry Yapt
Date:
Hello all,

I am testing PostgreSQL 8.0 beta on a windows xp professional.  In the
time when I did the install I have been working with pgadmin and so
on...

But after a few days, when I tried to continue with my tests.  I
cannot start the postgresql service.  I always get this message
windown when I try to start the service:

"The postgresql service on the local computer started
and stopped. some services stop automatically if they
have no work to do, for example the performance logs
and alerts services"

The service starts and stops automatically and I cannot to work with
pgsql.

PS: I have translated (get from internet) the text message window
because I have my system in spanish language.


Re: Pgsql beta 8 on windows starts and stops automatically.

From
"Magnus Hagander"
Date:
> Hello all,
>
> I am testing PostgreSQL 8.0 beta on a windows xp
> professional.  In the time when I did the install I have been
> working with pgadmin and so on...
>
> But after a few days, when I tried to continue with my tests.
>  I cannot start the postgresql service.  I always get this
> message windown when I try to start the service:
>
> "The postgresql service on the local computer started and
> stopped. some services stop automatically if they have no
> work to do, for example the performance logs and alerts services"
>
> The service starts and stops automatically and I cannot to
> work with pgsql.
>
> PS: I have translated (get from internet) the text message
> window because I have my system in spanish language.

This looks a lot like the postmaster.pid issue. Look in your DATA
directory, and remove that file if it exists.

If not, then it's a different issue. In this case, edit the
postgresql.conf file and set log_destination to include eventlog, then
look at eventlog output. (This is an issue with the installer that will
be fixed in the next beta release)

//Magnus

Re: Pgsql beta 8 on windows starts and stops automatically.

From
Terry Yapt
Date:
That's right..!!!!

I have deleted postmaster.pid and all was ok now..

Thanks..

On Mon, 23 Aug 2004 10:35:00 +0200, mha@sollentuna.net ("Magnus
Hagander") wrote:

>> Hello all,
>>
>> I am testing PostgreSQL 8.0 beta on a windows xp
>> professional.  In the time when I did the install I have been
>> working with pgadmin and so on...
>>
>> But after a few days, when I tried to continue with my tests.
>>  I cannot start the postgresql service.  I always get this
>> message windown when I try to start the service:
>>
>> "The postgresql service on the local computer started and
>> stopped. some services stop automatically if they have no
>> work to do, for example the performance logs and alerts services"
>>
>> The service starts and stops automatically and I cannot to
>> work with pgsql.
>>
>> PS: I have translated (get from internet) the text message
>> window because I have my system in spanish language.
>
>This looks a lot like the postmaster.pid issue. Look in your DATA
>directory, and remove that file if it exists.
>
>If not, then it's a different issue. In this case, edit the
>postgresql.conf file and set log_destination to include eventlog, then
>look at eventlog output. (This is an issue with the installer that will
>be fixed in the next beta release)
>
>//Magnus
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org