Re: pgAgent error on Installation

> On 13 Jan 2025, at 20:11, Fakarai, Edgar wrote: > I am encountering a Certification verification error whenever I want to > install pgAgent from stackbuilder on Windows OS. I have attached the > screenshot of the error message. > Thank you. If I take yes it gives me another error check the se

Re: pgagent download link missing

On 10/20/23 04:04, B Liu wrote: Hi there, I tried to download latest pgagent for windows, but there is no link on this page, https://www.pgadmin.org/download/pgagent-windows/ Did I miss anything? Yes the below from the link you posted: "p

Re: pgagent download link missing

> On 20 Oct 2023, at 13:04, B Liu wrote: > I tried to download latest pgagent for windows, but there is no link on this > page, https://www.pgadmin.org/download/pgagent-windows/ This list is for general questions around postgres and the PostgreSQL project, and might not be monitored by pgadmin

Re: pgAgent for multiple databases in same instance

Hi Adam , Thank you for the such a good explaination , actually in same instance dba's are looking to create multiple QA databases and we had jobs in oracle for archiving and some business functionality so I created pgagent extension in multiple databases ,in our application end users can submit j

Re: pgAgent for multiple databases in same instance

So my experience isn't with pgagent directly, because I have been using my re-written version of it for ~5 years (but at least at one point I had a pretty darn good understanding from doing that rewrite)...please take this with a grain of salt if I am incorrect on anything. So the agent is only ab

Re: pgagent

My bad ! I didn't read the documentation too well ... and completed the 'Host agent' with the IP instead of the hostname ! The job it's running now. Thank you for help ! Regards, Gabriel On Sat, Nov 7, 2020 at 1:29 PM Gabi Draghici wrote: > > I don't think that most of them are related to

Re: pgagent

I don't think that most of them are related to pgagent, since they are coming anyway (I suppose it's about pgadmin's Dashboard). There is just one that I think it's about "Run now" : ... EET postgres postgres [2104]LOG: statement: UPDATE pgagent.pga_job SET jobnextrun=now()::timestamptz WHERE jo

Re: pgagent

On 11/6/20 8:12 AM, Gabi Draghici wrote: It't not a daemon yet (I started manually) but yes, it's running : postgres@dbdocs:~> ps aux | grep postgresql postgres  2093  0.0  0.3 8720088 218280 ?      Ss   17:54   0:00 /usr/lib/postgresql12/bin/postgres -D /opt/postgresql/database postgres  2315

Re: pgagent

It't not a daemon yet (I started manually) but yes, it's running : postgres@dbdocs:~> ps aux | grep postgresql postgres 2093 0.0 0.3 8720088 218280 ? Ss 17:54 0:00 /usr/lib/postgresql12/bin/postgres -D /opt/postgresql/database postgres 2315 0.0 0.0 64664 5708 pts/2S17:57

Re: pgagent

On 11/6/20 4:26 AM, Gabi Draghici wrote: Hi, 1. The job it's a simple call to one stored function like that : BEGIN  CALL other_user_name.get_function(); END; Problem is that despite the fact that it's long passed by the scheduled running time and I tried the "Run now" option (from pgadmin) a

Re: pgagent

Hi, 1. The job it's a simple call to one stored function like that : BEGIN CALL other_user_name.get_function(); END; Problem is that despite the fact that it's long passed by the scheduled running time and I tried the "Run now" option (from pgadmin) a couple of times, there is no evidence that th

Re: pgagent

On 11/5/20 1:07 PM, Gabi Draghici wrote: Hi, I have installed postgresql 12 on sles 15 for some tests. Now I'm interested in some sort of scheduler and from what I've read so far, pgagent should do the job. So I've installed pgagent 4.0. I've added a job (which I can see in pgagent.pga_job)

Re: PgAgent on Windows

Thank´s Stéphane, My pg_pass.conf in database_name parameter was postgres, but when I change for *, then run successful. Thank´s again, Márcio. [image: Mailtrack] Remetente notificado por Mailtrack

Re: PgAgent on Windows

Le 06/11/2018 à 14:36, Marcio Meneguzzi a écrit : Hello, I´m trying use pgAgent on windows 10 and Windows Server 2012 R2. My version of PostgreSQL is 9.5.1.14 Install and configure pgAgent with sucess, but, when I try run a Job, status is Failed with a message bellow: *"Couldn't create the prim

Re: PgAgent on Windows

Run a Job is: In PgAdminit´s right click over the name of job and select option "Run Now". After, when i open windows log aplication´s, a message like this "*"Couldn't create the primary connection (attempt 1): fe_sendauth: no password supplied" is generated.* *Thank´s.* [image: Mailtrack]

Re: PgAgent on Windows

On 11/06/2018 07:36 AM, Marcio Meneguzzi wrote: Hello, I´m trying use pgAgent on windows 10 and Windows Server 2012 R2. My version of PostgreSQL is 9.5.1.14 Install and configure pgAgent with sucess, but, when I try run a Job, status is Failed with a message bellow: *"Couldn't create the primar

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On 06/05/2018 07:53 AM, nageswara Bandla wrote: Adrian, I think, it's not problem with pg_hba.conf.  /etc/hosts is configured correctly. psql works fine and is inline with libpq, where as pgagent is not. pgagent still fails when we use hostaddr and host. usr/bin/pgagent_96 -f -l 2 hostaddr=1

Re: Pgagent is not reading pgpass file either in Windows or Linux.

Adrian, I think, it's not problem with pg_hba.conf. /etc/hosts is configured correctly. psql works fine and is inline with libpq, where as pgagent is not. pgagent still fails when we use hostaddr and host. usr/bin/pgagent_96 -f -l 2 hostaddr=127.0.0.1 host=localhost dbname=linuxpostgresdb user=

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On 06/04/2018 03:31 PM, nageswara Bandla wrote: I have figured out the issue with pgAgent both in Windows and Linux. PgAgent seems to ignore pgpass.conf/.pgpass whenever it has 127.0.0.1 (127.0.0.1:5432:*:postgres:postgres) throws an error: Could it be that hosts is not set up for?: 127.0.0.

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On 6/4/2018 6:31 PM, nageswara Bandla wrote: I have figured out the issue with pgAgent both in Windows and Linux. PgAgent seems to ignore pgpass.conf/.pgpass whenever it has 127.0.0.1 (127.0.0.1:5432:*:postgres:postgres) throws an error: *DEBUG: Creating DB connection: user=postgres port=543

Re: Pgagent is not reading pgpass file either in Windows or Linux.

I've noticed that .pgpass is case sensitive, so am not surprised that it also wouldn't note the difference between 127.0.0.1 and localhost. On 06/04/2018 05:31 PM, nageswara Bandla wrote: I have figured out the issue with pgAgent both in Windows and Linux. PgAgent seems to ignore pgpass.conf/.

Re: Pgagent is not reading pgpass file either in Windows or Linux.

I have figured out the issue with pgAgent both in Windows and Linux. PgAgent seems to ignore pgpass.conf/.pgpass whenever it has 127.0.0.1 (127.0.0.1:5432:*:postgres:postgres) throws an error: *DEBUG: Creating DB connection: user=postgres port=5432 hostaddr=127.0.0.1 dbname=linuxpostgresdb*

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On Thu, May 31, 2018 at 5:16 PM, George Neuner wrote: > On Thu, 31 May 2018 15:40:21 -0500, nageswara Bandla > wrote: > > >On Thu, May 31, 2018 at 12:57 PM, George Neuner > >wrote: > > > >> It just occurred to me that you said PGPASSFILE was set to > >> > >> %APPDATA%/postgresql/pgpass.conf

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On Thu, 31 May 2018 15:40:21 -0500, nageswara Bandla wrote: >On Thu, May 31, 2018 at 12:57 PM, George Neuner >wrote: > >> It just occurred to me that you said PGPASSFILE was set to >> >> %APPDATA%/postgresql/pgpass.conf >> >> >> The problem may be that when LocalSystem expands %APPDATA%, it

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On Thu, May 31, 2018 at 12:57 PM, George Neuner wrote: > On Thu, 31 May 2018 11:24:18 -0500, nageswara Bandla > wrote: > > >On Wed, May 30, 2018 at 7:45 PM, George Neuner > wrote: > > > >> LocalSystem has administrator permissions to virtually everything. > >> https://msdn.microsoft.com/en-us/l

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On Thu, 31 May 2018 11:24:18 -0500, nageswara Bandla wrote: >On Wed, May 30, 2018 at 7:45 PM, George Neuner wrote: > >> LocalSystem has administrator permissions to virtually everything. >> https://msdn.microsoft.com/en-us/library/windows/desktop/ >> ms684190(v=vs.85).aspx >> >> It should be abl

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On Wed, May 30, 2018 at 7:45 PM, George Neuner wrote: > On Tue, 29 May 2018 13:32:46 -0700, Adrian Klaver > wrote: > > >On 05/29/2018 12:14 PM, nageswara Bandla wrote: > > > >> As per the link- > >> (https://www.postgresql.org/docs/9.6/static/libpq-pgpass.html) I set > >> PGPASSFILE environment

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On Tue, 29 May 2018 13:32:46 -0700, Adrian Klaver wrote: >On 05/29/2018 12:14 PM, nageswara Bandla wrote: > >> As per the link- >> (https://www.postgresql.org/docs/9.6/static/libpq-pgpass.html) I set >> PGPASSFILE environment variable to point to pgpass.conf location. Even >> then, it’s throwi

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On 05/30/2018 08:48 AM, nageswara Bandla wrote: On Tue, May 29, 2018 at 6:15 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 05/29/2018 03:57 PM, nageswara Bandla wrote: #1. Windows: My guess because the LocalSystem user does not have permissions

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On Wed, May 30, 2018 at 5:11 AM, Stéphane Dunand wrote: > > Le 29/05/2018 à 21:14, nageswara Bandla a écrit : > > > > The intention of this post is to find out ways to run pgagent without > passing password in its connection string. > > > > *Windows:* > > I have installed pgagent on windows and c

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On Tue, May 29, 2018 at 6:15 PM, Adrian Klaver wrote: > On 05/29/2018 03:57 PM, nageswara Bandla wrote: > >> #1. Windows: >> >> My guess because the LocalSystem user does not have permissions on your: >> %APPDATA%/postgresql/pgpass.co nf >> file. This seems to be confirmed by it

Re: Pgagent is not reading pgpass file either in Windows or Linux.

Le 29/05/2018 à 21:14, nageswara Bandla a écrit : The intention of this post is to find out ways to run pgagent without passing password in its connection string. *Windows:* I have installed pgagent on windows and configured to run under Local System account. Command:- C:\PostgreSQL\big

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On 05/29/2018 03:57 PM, nageswara Bandla wrote: #1. Windows: My guess because the LocalSystem user does not have permissions on your: %APPDATA%/postgresql/pgpass.co nf file. This seems to be confirmed by it working when you run pgagent as the login user. Also: passfile     S

Re: Pgagent is not reading pgpass file either in Windows or Linux.

#1. Windows: My guess because the LocalSystem user does not have permissions on your: %APPDATA%/postgresql/pgpass.conf file. This seems to be confirmed by it working when you run pgagent as the login user. Also: passfile Specifies the name of the file used to store passwords (see Section 33.15

Re: Pgagent is not reading pgpass file either in Windows or Linux.

On 05/29/2018 12:14 PM, nageswara Bandla wrote: The intention of this post is to find out ways to run pgagent without passing password in its connection string. *Windows:* I have installed pgagent on windows and configured to run under Local System account. Command:- C:\PostgreSQL\bigsql\p