[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: pgagent-pg16 could not start: Error 1053
From:       B Liu <binliucam () gmail ! com>
Date:       2023-11-14 8:41:47
Message-ID: CAL+0+Hb0V5O18X5RUCejn6+mzgXSthkRH7BPgY8jpizGtrp5-A () mail ! gmail ! com
[Download RAW message or body]

Thanks, I reported it as a bug issue ....
All the best
Bin

On Mon, Nov 13, 2023 at 2:22 PM Ron <ronljohnsonjr@gmail.com> wrote:

>
> They might not know.  Especially since pgsql-admin is not the pgadmin
> mailing list.
>
> https://github.com/pgadmin-org/pgadmin4/issues
> https://www.pgadmin.org/support/list/
>
>
> On 11/13/23 03:46, B Liu wrote:
>
> Hi Erik,
>
> I installed postgresql 12 and its pgagent on my laptop, which works for
> windows server 2012, unfortunately the pgagent is not working, like the
> pgagent 16 version, it is in the starting stage forever. So it looks like
> the pgagent doesn't work for windows 10 and windows server 2019 then. Is
> there any plan that the admin team will provide a working version for the
> latest windows server?
>
> Kind Regards
>
> Bin
>
> On Fri, Nov 10, 2023 at 12:54 PM Erik Serrano <eserranos@gmail.com> wrote:
>
>> Dear B. Liu
>>
>> What you say makes sense to me that the file you are installing is
>> defective or incompatible. I suggest you look for another distribution and
>> reinstall it.
>> I hope it helps you and greetings
>>
>>
>>
>> *Erik R. Serrano Saavedra*
>> *Ingeniero de Sistemas Informáticos*
>> *      Data Base Administrator*
>>
>>
>>
>> El vie, 10 nov 2023 a las 5:43, B Liu (<binliucam@gmail.com>) escribió:
>>
>>> Dear Erik,
>>> Many thanks for your help.
>>> Regarding the windows server 2019, it probably is a virtual machine.
>>> After I increased the low time value, there is no error code 1053 any more,
>>> but the pgagent service is on starting status forever. To test if the
>>> pgagent works, I installed the same pgagent on my laptop, it gave the same
>>> service starting status forever, but not into any running stage.
>>> I am pretty sure that the latest pgagent is not working for windows 10
>>> or windows server 2019! I have one postgres-pg12 working on windows server
>>> 2012 though.
>>> Kind Regards
>>> Bin
>>>
>>> On Thu, Nov 9, 2023 at 2:14 PM B Liu <binliucam@gmail.com> wrote:
>>>
>>>> Dear Erik,
>>>>
>>>> Many thanks for your email.
>>>>
>>>> The pgagent was installed on a brand new windows server 2019, it
>>>> shouldn't have any file corrupted files, and it was installed via the
>>>> pgagent installer, which I don't think there is any permission issue,  the
>>>> local firewall has opened the postgresql port 5432 unless there is another
>>>> port need to be opened, when I installed the pgagent, I chose the port 5432
>>>> anyway.
>>>>
>>>> It narrows down to the low time value, I followed some advice and
>>>> increased it. When I started pgagent service, it states it is starting, but
>>>> doesn't go to the running stage, this time no error message, nothing in the
>>>> postgresql log file.
>>>>
>>>> I wonder if there is a working version of pgagent exist? This could
>>>> explain why there is no official pgagent downloadable file on the official
>>>> web site anymore!
>>>>
>>>> Could anybody from the admin team kindly give some update?
>>>>
>>>> Kind Regards
>>>>
>>>> Bin
>>>>
>>>> On Thu, Nov 9, 2023 at 1:06 PM Erik Serrano <eserranos@gmail.com>
>>>> wrote:
>>>>
>>>>> Dear,
>>>>>
>>>>> The postgresql error indicates that common reasons for this error
>>>>> include:
>>>>>
>>>>> * Low timeout value
>>>>> * Firewall restrictions
>>>>> * Corrupt files
>>>>> * file permissions
>>>>>
>>>>> Check that out in the meantime, I hope it helps you.
>>>>> Greetings
>>>>>
>>>>>
>>>>> *Erik R. Serrano Saavedra*
>>>>> *Ingeniero de Sistemas Informáticos*
>>>>> *      Data Base Administrator*
>>>>>
>>>>> *        eserranos@gmail.com <eserranos@gmail.com> *
>>>>> *                 998596691*
>>>>>
>>>>>
>>>>> El jue, 9 nov 2023 a las 9:51, B Liu (<binliucam@gmail.com>) escribió:
>>>>>
>>>>>> Hi there,
>>>>>>
>>>>>> I finally downloaded pgagent from EDB installer, when I tried to
>>>>>> start pgagent-pg16 service for the first time, it couldn't start, the error
>>>>>> message saying: Windows could not start postgres-pg16 service on local
>>>>>> computer, error code 1053.
>>>>>>
>>>>>> Local server is windows server 2019. Could anybody from the admin
>>>>>> team advise on this?
>>>>>>
>>>>>> Kind Regards
>>>>>>
>>>>>> Bin
>>>>>>
>>>>>
> --
> Born in Arizona, moved to Babylonia.
>

[Attachment #3 (text/html)]

<div dir="ltr">Thanks, I reported it as a bug issue ....<div>All the \
best</div><div>Bin</div></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Mon, Nov 13, 2023 at 2:22 PM Ron &lt;<a \
href="mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u>

  
    
  
  <div>
    <br>
    They might not know.   Especially since pgsql-admin is not the
    pgadmin mailing list.<br>
    <br>
    <a href="https://github.com/pgadmin-org/pgadmin4/issues" \
target="_blank">https://github.com/pgadmin-org/pgadmin4/issues</a><br>  <a \
href="https://www.pgadmin.org/support/list/" \
target="_blank">https://www.pgadmin.org/support/list/</a><br>  <br>
    <br>
    <div>On 11/13/23 03:46, B Liu wrote:<br>
    </div>
    <blockquote type="cite">
      
      <div dir="ltr">Hi Erik,
        <div><br>
        </div>
        <div>I installed postgresql 12 and its pgagent on my laptop,
          which works  for windows server 2012, unfortunately  the pgagent
          is not working, like the pgagent 16 version, it is in the
          starting stage forever. So it looks like the pgagent doesn&#39;t
          work for windows 10 and windows server 2019 then. Is there any
          plan that the admin team will provide a working version for
          the latest windows server?</div>
        <div><br>
        </div>
        <div>Kind Regards</div>
        <div><br>
        </div>
        <div>Bin</div>
      </div>
      <br>
      <div class="gmail_quote">
        <div dir="ltr" class="gmail_attr">On Fri, Nov 10, 2023 at
          12:54 PM Erik Serrano &lt;<a href="mailto:eserranos@gmail.com" \
target="_blank">eserranos@gmail.com</a>&gt;  wrote:<br>
        </div>
        <blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">  <div dir="ltr">
            <div>Dear B. Liu</div>
            <div><br>
            </div>
            What you say makes sense to me that the file you are
            installing is defective or incompatible. I suggest you look
            for another distribution and reinstall it.<br>
            I hope it helps you and greetings<br clear="all">
            <div>
              <div dir="ltr" class="gmail_signature">
                <div dir="ltr">
                  <div>
                    <div dir="ltr">
                      <div>
                        <div dir="ltr">
                          <div><br>
                            <i><b><br>
                              </b></i></div>
                          <div><i><b><br>
                              </b></i></div>
                          <div><i><b><font size="4">Erik R. Serrano
                                  Saavedra</font></b></i></div>
                          <div><i style="font-size:12.8px"><b>Ingeniero
                                de Sistemas Informáticos</b></i></div>
                          <div><i style="font-size:12.8px"><b>         Data
                                Base Administrator</b></i></div>
                          <div><br>
                          </div>
                          <div><i><font style="font-size:12pt" size="3" face="Times \
New Roman"><b>  </b></font></i></div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>
            <br>
          </div>
          <br>
          <div class="gmail_quote">
            <div dir="ltr" class="gmail_attr">El vie, 10 nov 2023 a las
              5:43, B Liu (&lt;<a href="mailto:binliucam@gmail.com" \
target="_blank">binliucam@gmail.com</a>&gt;)  escribió:<br>
            </div>
            <blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">  <div dir="ltr">Dear \
Erik,  <div>Many thanks for your help.</div>
                <div>Regarding the windows server 2019, it probably is a
                  virtual  machine. After I increased the low time value,
                  there is no error code 1053 any more, but the pgagent
                  service is on starting status forever. To test if the
                  pgagent works, I installed the same pgagent on my
                  laptop, it gave the same service starting status
                  forever, but not into any running stage.  </div>
                <div>I am pretty sure that the latest pgagent is not
                  working for  windows 10 or windows  server 2019! I have
                  one postgres-pg12 working on windows server 2012
                  though.</div>
                <div>Kind Regards</div>
                <div>Bin</div>
              </div>
              <br>
              <div class="gmail_quote">
                <div dir="ltr" class="gmail_attr">On Thu, Nov 9, 2023 at
                  2:14 PM B Liu &lt;<a href="mailto:binliucam@gmail.com" \
target="_blank">binliucam@gmail.com</a>&gt;  wrote:<br>
                </div>
                <blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">  <div dir="ltr">
                    <div dir="ltr">Dear Erik,
                      <div><br>
                      </div>
                      <div>Many thanks for your email.</div>
                      <div><br>
                      </div>
                      <div>The pgagent was installed on a brand new
                        windows server 2019, it shouldn&#39;t have any file
                        corrupted files, and it was installed via the
                        pgagent installer, which I don&#39;t think there is
                        any permission issue,   the local firewall has
                        opened the postgresql port 5432 unless there is
                        another port need to be opened, when I installed
                        the pgagent, I chose the port 5432 anyway.  </div>
                      <div><br>
                      </div>
                      <div>It narrows down to the low time value, I
                        followed some advice and increased it. When I
                        started pgagent service, it states it is
                        starting, but doesn&#39;t go to the running stage,
                        this time no error message, nothing in the
                        postgresql log file.  </div>
                      <div><br>
                      </div>
                      <div>I wonder if there is a working version of
                        pgagent exist? This could explain why there is
                        no official pgagent downloadable file on the
                        official web site anymore!</div>
                      <div><br>
                      </div>
                      <div>Could anybody from the admin team kindly give
                        some update?</div>
                      <div><br>
                      </div>
                      <div>Kind Regards</div>
                      <div><br>
                      </div>
                      <div>Bin</div>
                    </div>
                    <br>
                    <div class="gmail_quote">
                      <div dir="ltr" class="gmail_attr">On Thu, Nov 9,
                        2023 at 1:06 PM Erik Serrano &lt;<a \
href="mailto:eserranos@gmail.com" target="_blank">eserranos@gmail.com</a>&gt;  \
wrote:<br>  </div>
                      <blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">  <div \
dir="ltr">Dear,<br>  <br>
                          The postgresql error indicates that common
                          reasons for this error include:<br>
                          <br>
                          * Low timeout value<br>
                          * Firewall restrictions<br>
                          * Corrupt files<br>
                          * file permissions<br>
                          <br>
                          Check that out in the meantime, I hope it
                          helps you.<br>
                          Greetings<br clear="all">
                          <div>
                            <div dir="ltr" class="gmail_signature">
                              <div dir="ltr">
                                <div>
                                  <div dir="ltr">
                                    <div>
                                      <div dir="ltr">
                                        <div><br>
                                          <i><b><br>
                                            </b></i></div>
                                        <div><i><b><font size="4">Erik
                                                R. Serrano \
                Saavedra</font></b></i></div>
                                        <div><i style="font-size:12.8px"><b>Ingeniero
                                              de Sistemas Informáticos</b></i></div>
                                        <div><i style="font-size:12.8px"><b>  
                                                    Data Base
                                              Administrator</b></i></div>
                                        <div><i><b>             <a \
href="mailto:eserranos@gmail.com" target="_blank">eserranos@gmail.com</a><br>  \
</b></i></div>  <div><i><b>                       
                                                998596691</b></i><br>
                                        </div>
                                        <div><i><font style="font-size:12pt" size="3" \
face="Times New Roman"><b>  </b></font></i></div>
                                      </div>
                                    </div>
                                  </div>
                                </div>
                              </div>
                            </div>
                          </div>
                          <br>
                        </div>
                        <br>
                        <div class="gmail_quote">
                          <div dir="ltr" class="gmail_attr">El jue, 9
                            nov 2023 a las 9:51, B Liu (&lt;<a \
href="mailto:binliucam@gmail.com" target="_blank">binliucam@gmail.com</a>&gt;)  \
escribió:<br>  </div>
                          <blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">  <div dir="ltr">Hi \
there,  <div><br>
                              </div>
                              <div>I finally downloaded pgagent from EDB
                                installer, when I tried to start
                                pgagent-pg16 service for the first time,
                                it couldn&#39;t start, the error message
                                saying: Windows could not start
                                postgres-pg16 service on local computer,
                                error code 1053.</div>
                              <div><br>
                              </div>
                              <div>Local server is windows server 2019.
                                Could anybody from the admin team advise
                                on this?</div>
                              <div><br>
                              </div>
                              <div>Kind Regards</div>
                              <div><br>
                              </div>
                              <div>Bin</div>
                            </div>
                          </blockquote>
                        </div>
                      </blockquote>
                    </div>
                  </div>
                </blockquote>
              </div>
            </blockquote>
          </div>
        </blockquote>
      </div>
    </blockquote>
    <br>
    <div>-- <br>
      Born in Arizona, moved to Babylonia.</div>
  </div>

</blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic