Thread: postgres failed to start from services manager on windows 2008 r2
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
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.gm@gmail.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
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.trewern@gmail.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.gm@gmail.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
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.gm@gmail.com> wrote:hi Ben,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.gm@gmail.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 windowsservice 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 Application 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 notin 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 messageThe description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this eventis not installed on your local computer or the installation is corrupted. You can install or repair the componenton 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 startupcould 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.trewern@gmail.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.gm@gmail.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
thanks much Ben.
On Tue, Sep 20, 2016 at 6:34 PM, Ben Trewern <ben.trewern@gmail.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,BenOn 20 Sep 2016, at 13:54, PHANIKUMAR G <phanikumar.gm@gmail.com> wrote:hi Ben,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.gm@gmail.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 windowsservice 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 Application 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 notin 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 messageThe description for Event ID 0 from source PostgreSQL cannot be found. Either the component that raises this eventis not installed on your local computer or the installation is corrupted. You can install or repair the componenton 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 startupcould 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.trewern@gmail.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.gm@gmail.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