From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: pgagent-pg16 could not start: Error 1053
Date: Mon, 13 Nov 2023 08:22:35 -0600
Message-ID: <f54a2f7d-a0b7-4896-8511-35ddb9a930d7@gmail.com> (raw)
In-Reply-To: <CAL+0+Hbn7FC27=-GY2PahN1+TT4ahoUB1CE8-YTWDQdDJ9iwJw@mail.gmail.com>
References: <CAL+0+HZBdTxGUjY9uYJgS55EcLqKOpD5m+VYaqy9q04iQE_KMQ@mail.gmail.com>
<CA+dvXXukt-ArFrpfQP132En4Jok6ohV8v7UQkhA6cGTmqhZTKw@mail.gmail.com>
<CAL+0+HY+CYZgRJZiP+426HwUDaWpTw+wO4VfZJuBAo6=kTjdrQ@mail.gmail.com>
<CAL+0+HZS8+sJMouot1r38hicORMT76Obq_yNY8_C8dTx3cyCCw@mail.gmail.com>
<CA+dvXXtZ+ieT-zPmOaQhTdaa4Aw5B3V8VB6Uu+AkMWc=1htW=Q@mail.gmail.com>
<CAL+0+Hbn7FC27=-GY2PahN1+TT4ahoUB1CE8-YTWDQdDJ9iwJw@mail.gmail.com>
They might not know. Especially since pgsql-admin is not the pgadmin
mailing list.
https://github.com/pgadmin-org/pgadmin4/issueshttps://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
> */
> /* 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: pgagent-pg16 could not start: Error 1053
In-Reply-To: <f54a2f7d-a0b7-4896-8511-35ddb9a930d7@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox