thanks much Ben. On Tue, Sep 20, 2016 at 6:34 PM, Ben Trewern <ben.trew...@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, > > Ben > > On 20 Sep 2016, at 13:54, PHANIKUMAR G <phanikumar...@gmail.com> wrote: > > hi Ben, > > I am getting the following message bydefault " The author (PHANIKUMAR > G <phanikumar...@gmail.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...@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 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.trew...@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...@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 >>> >>> >> > >