Re: postgres failed to start from services manager on windows 2008 r2

thanks much Ben.

On Tue, Sep 20, 2016 at 6:34 PM, Ben Trewern <ben(dot)trewern(at)gmail(dot)com> wrote:

> Hi,
>
> I think you’ll have to subscribe to pgsql-admin or pgsql-general to send
> messages to them.
>
> See here: https://www.postgresql.org/list/
>
> Regards,
>
> Ben
>
> On 20 Sep 2016, at 13:54, PHANIKUMAR G <phanikumar(dot)gm(at)gmail(dot)com> wrote:
>
> hi Ben,
>
> I am getting the following message bydefault " The author (PHANIKUMAR
> G <phanikumar(dot)gm(at)gmail(dot)com>)
> is not a member of any of the restrict_post groups."
>
> when members of pgadmin-support group see my message, will they accept me
> or do I need to register anywhere, if so could you please provide em the
> link and redirect me to the page.
>
>
> thanks in adnvace.
>
>
> On Tue, Sep 20, 2016 at 4:49 PM, PHANIKUMAR G <phanikumar(dot)gm(at)gmail(dot)com>
> wrote:
>
>> Thanks Ben for your quick turn around and CCing required group.
>>
>>
>> hi pgadmin-support
>>
>> Could you please help me on this issue. It is happening only in customer
>> site and not reproducible in my environment, it is requirement that
>> postgres should be registered as windows service , this is the reason we
>> are registering it as windows service as explained below.
>>
>> I am providing my previous mail content once again here:
>>
>>
>> We are able to start the postgres from command line without any issue,
>> if postgres is registered as windows
>>
>> service and tried to start it, we are facing an issue .
>>
>> Problem:
>>
>> We have registered postgres(version 9.3.4) as windows service on windows
>> 2008 R2 and registration got succeeded.
>>
>> we are performing below 2 commands to register postgres as windows service
>>
>> <fullpath>pg_ctl.exe register -N "prostgresService" -D
>> "fullpath_to_data_directory" -W
>>
>> >sc description prostgresService "prostgresService Applicatio
>> n Server Database Service"
>>
>> when we try to start the service from services manager(services.msc) it
>> is failing and popping up below message
>>
>> "The prostgres service on Local Computer started and then stopped. Some
>> services stop automatically if they are not
>>
>> in use by other services or programs "
>>
>> postgres does not even create log and its directory pg_log in pgsql\data
>> directory.
>>
>> windows event log has a message
>>
>> The description for Event ID 0 from source PostgreSQL cannot be found.
>> Either the component that raises this event
>>
>> is not installed on your local computer or the installation is corrupted.
>> You can install or repair the component
>>
>> on the local computer.
>>
>> If the event originated on another computer, the display information had
>> to be saved with the event.
>>
>> The following information was included with the event:
>>
>> Timed out waiting for server startup
>>
>>
>> could you please help us how to start, we are clueless since postgres is
>> not creating log except windows event log.
>>
>>
>>
>>
>> On Tue, Sep 20, 2016 at 4:15 PM, Ben Trewern <ben(dot)trewern(at)gmail(dot)com>
>> wrote:
>>
>>> Hi,
>>>
>>> FYI: You would be better off posting this message to the pgsql-admin or
>>> pgsql-general lists as this one is specific to PgAdmin.
>>>
>>> I can’t help you much with your question as I haven’t used postgres on
>>> windows for some time but I’d try the following:
>>>
>>> C:\> <Path to postgres bin folder>\pg_ctl.exe start -D <Path to postgres
>>> data folder>
>>>
>>> This will try to start your postgres server without using windows
>>> service mechanism. Then see what error messages you get, this should give
>>> you some idea what the problem is.
>>>
>>> Regards,
>>>
>>> Ben
>>> > On 20 Sep 2016, at 09:31, PHANIKUMAR G <phanikumar(dot)gm(at)gmail(dot)com>
>>> wrote:
>>> >
>>> > hi,
>>> >
>>> > We are able to start the postgres from command line without any
>>> issue, if postgres is registered as windows
>>> >
>>> > service and tried to start it, we are facing an issue .
>>> >
>>> > Problem:
>>> >
>>> > We have registered postgres(version 9.3.4) as windows service on
>>> windows 2008 R2 and registration got succeeded.
>>> >
>>> > we are performing below 2 commands to register postgres as windows
>>> service
>>> >
>>> > <fullpath>pg_ctl.exe register -N "prostgresService" -D
>>> "fullpath_to_data_directory" -W
>>> >
>>> > >sc description prostgresService "prostgresService Applicatio
>>> > n Server Database Service"
>>> >
>>> > when we try to start the service from services manager(services.msc)
>>> it is failing and popping up below message
>>> >
>>> > "The prostgres service on Local Computer started and then stopped.
>>> Some services stop automatically if they are not
>>> >
>>> > in use by other services or programs "
>>> >
>>> > postgres does not even create log and its directory pg_log in
>>> pgsql\data directory.
>>> >
>>> > windows event log has a message
>>> >
>>> > The description for Event ID 0 from source PostgreSQL cannot be found.
>>> Either the component that raises this event
>>> >
>>> > is not installed on your local computer or the installation is
>>> corrupted. You can install or repair the component
>>> >
>>> > on the local computer.
>>> >
>>> > If the event originated on another computer, the display information
>>> had to be saved with the event.
>>> >
>>> > The following information was included with the event:
>>> >
>>> > Timed out waiting for server startup
>>> >
>>> >
>>> > could you please help us how to start, we are clueless since postgres
>>> is not creating log except windows event log.
>>> >
>>> >
>>> > thanks in advance
>>> > Phani Kumar
>>>
>>>
>>
>
>