Re: [pgadmin-support] PGAgent Question

Shouldn’t:- timezone = 'Europe/London’ Set this automatically? Which is what we have in postgresql.conf > On 4 Apr 2017, at 22:32, Basques, Bob (CI-StPaul) > wrote: > > daylight savings time?? (CDT vs CEN time?) > > >> On Apr 4, 2017, at 4:27 PM, Dave Barter > > w

Re: [pgadmin-support] PGAgent Question

daylight savings time?? (CDT vs CEN time?) On Apr 4, 2017, at 4:27 PM, Dave Barter mailto:d...@phased.co.uk>> wrote: All of our scheduled jobs are running 1 hour after the time being set in PGAdmin III Any idea why? The servers report the correct date and the timezone on postgres is set cor

[pgadmin-support] PGAgent Question

All of our scheduled jobs are running 1 hour after the time being set in PGAdmin III Any idea why? The servers report the correct date and the timezone on postgres is set correctly. SELECT now(); also gives me the date I expect? -- Sent via pgadmin-support mailing list (pgadmin-support@post

Re: [pgadmin-support] pgagent hangs forever in "r" state

Just chiming in quickly, We experienced exactly the same behavior with pg 9.4. It was consistent across the 18 database servers that we upgraded from 9.3 to 9.4. A job would complete successfully, and then just remain in 'running' state. We tried purging and re-installing pg and pgadmin/agent cl

Re: [pgadmin-support] pgagent hangs forever in "r" state

On 07/21/2015 11:29 PM, Ashesh Vashi wrote: > On Wed, Jul 22, 2015 at 11:56 AM, Sanket Mehta > mailto:sanket.me...@enterprisedb.com>> > wrote: > > Hi Dave, > > As per our discussion, I have tried to reproduce the issue, but it > seems jobs are running fine without any problem. > H

Re: [pgadmin-support] pgagent hangs forever in "r" state

On Wed, Jul 22, 2015 at 11:56 AM, Sanket Mehta < sanket.me...@enterprisedb.com> wrote: > Hi Dave, > > As per our discussion, I have tried to reproduce the issue, but it seems > jobs are running fine without any problem. > Hence the issue is not reproducible on my system. > Josh, As we're unable t

Re: [pgadmin-support] pgagent hangs forever in "r" state

Hi Dave, As per our discussion, I have tried to reproduce the issue, but it seems jobs are running fine without any problem. Hence the issue is not reproducible on my system. Regards, Sanket Mehta Sr Software engineer Enterprisedb On Tue, Jul 21, 2015 at 9:52 AM, Josh Berkus wrote: > On 07/20/

Re: [pgadmin-support] pgagent hangs forever in "r" state

On 07/20/2015 08:01 AM, Dave Page wrote: >> Suggestion to resolve the issue: >> >> get the max value of ID from table before insert query and run the >> sequence till we get the max(ID)+1 and then we execute the insert statement >> with this new value as ID. > > We're not doing that - it'

Re: [pgadmin-support] pgagent hangs forever in "r" state

Hi On Mon, Jul 20, 2015 at 12:49 PM, Sanket Mehta wrote: > Hi Dave, > > I have tried to reproduce the same in my system by resetting the pgagent > sequences to 1. > > Below is the results I have came across: > > the job is not getting executed and its current status is "i" (no > steps fo

Re: [pgadmin-support] pgagent hangs forever in "r" state

Hi Dave, I have tried to reproduce the same in my system by resetting the pgagent sequences to 1. Below is the results I have came across: the job is not getting executed and its current status is "i" (no steps found ) although I have specified 2 steps for that job. Below is the log en

Re: [pgadmin-support] pgagent hangs forever in "r" state

Sure Dave, I will try and let you know. Regards, Sanket Mehta Sr Software engineer Enterprisedb On Mon, Jul 13, 2015 at 7:44 PM, Dave Page wrote: > Sanket, can you reproduce this? > > On Fri, Jul 10, 2015 at 5:41 PM, Josh Berkus wrote: > > On 07/10/2015 07:16 AM, Dave Page wrote: > >> Are you

Re: [pgadmin-support] pgagent hangs forever in "r" state

Sanket, can you reproduce this? On Fri, Jul 10, 2015 at 5:41 PM, Josh Berkus wrote: > On 07/10/2015 07:16 AM, Dave Page wrote: >> Are you able to get a stacktrace from a running instance that's hung? > > Yes, but it's not doing anything, it's just polling for the next job. > >> Also, does setting

Re: [pgadmin-support] pgagent hangs forever in "r" state

On 07/10/2015 07:16 AM, Dave Page wrote: > Are you able to get a stacktrace from a running instance that's hung? Yes, but it's not doing anything, it's just polling for the next job. > Also, does setting the logging level to debug reveal anything useful > in the filesystem logs? (pgagent -l2

Re: [pgadmin-support] pgagent hangs forever in "r" state

On Tue, Jul 7, 2015 at 12:02 AM, Josh Berkus wrote: > On 07/06/2015 10:26 AM, Josh Berkus wrote: >> All, >> >> On the same server with the SQL errors (sequences are cleaned up now), >> we're having pgagent start all jobs in the "r" state, log the first step >> in each job in the "r" state, and the

Re: [pgadmin-support] pgagent errors on application_name

On Wed, Jul 8, 2015 at 7:06 AM, Josh Berkus wrote: > On 07/06/2015 08:52 PM, Ashesh Vashi wrote: > > Hi Josh, > > > > On Mon, Jul 6, 2015 at 11:55 PM, Josh Berkus > > wrote: > > > > To wit: > > > > postgres@9c7b33848038:~$ pgagent -l pgagent.log -f dbname=postgr

Re: [pgadmin-support] pgagent errors on application_name

On 07/06/2015 08:52 PM, Ashesh Vashi wrote: > Hi Josh, > > On Mon, Jul 6, 2015 at 11:55 PM, Josh Berkus > wrote: > > To wit: > > postgres@9c7b33848038:~$ pgagent -l pgagent.log -f dbname=postgres > user=postgres application_name=pgagent > ERROR: Primary

Re: [pgadmin-support] pgagent DEB packages do not support postgres 9.4

Re: Josh Berkus 2015-07-06 <559ac4ff.1040...@agliodbs.com> > On 07/05/2015 10:27 PM, Josh Berkus wrote: > > On 07/05/2015 01:38 PM, Christoph Berg wrote: > >> pgagent had not been rebuilt for quite a while which is why it didn't > >> have 9.4 (and jessie) support yet. Fixed now: > > > > Thanks! >

Re: [pgadmin-support] pgagent errors on application_name

Hi Josh, On Mon, Jul 6, 2015 at 11:55 PM, Josh Berkus wrote: > To wit: > > postgres@9c7b33848038:~$ pgagent -l pgagent.log -f dbname=postgres > user=postgres application_name=pgagent > ERROR: Primary connection string is not valid! > 18:15:15: Debug: In file ../src/unix/threadpsx.cpp at line 261

Re: [pgadmin-support] pgagent hangs forever in "r" state

On 07/06/2015 10:26 AM, Josh Berkus wrote: > All, > > On the same server with the SQL errors (sequences are cleaned up now), > we're having pgagent start all jobs in the "r" state, log the first step > in each job in the "r" state, and then hang forever (or, at least for > three days). At this po

[pgadmin-support] pgagent errors on application_name

To wit: postgres@9c7b33848038:~$ pgagent -l pgagent.log -f dbname=postgres user=postgres application_name=pgagent ERROR: Primary connection string is not valid! 18:15:15: Debug: In file ../src/unix/threadpsx.cpp at line 261: 'pthread_mutex_destroy()' failed with error 0x0010 (Device or resourc

Re: [pgadmin-support] pgagent DEB packages do not support postgres 9.4

On 07/05/2015 10:27 PM, Josh Berkus wrote: > On 07/05/2015 01:38 PM, Christoph Berg wrote: >> pgagent had not been rebuilt for quite a while which is why it didn't >> have 9.4 (and jessie) support yet. Fixed now: > > Thanks! Oh, also, tested and verified. New packages work with 9.4. -- Josh Be

[pgadmin-support] pgagent hangs forever in "r" state

All, On the same server with the SQL errors (sequences are cleaned up now), we're having pgagent start all jobs in the "r" state, log the first step in each job in the "r" state, and then hang forever (or, at least for three days). At this point, 8 different jobs are in "r" state. In pg_stat_act

Re: [pgadmin-support] pgagent DEB packages do not support postgres 9.4

On 07/05/2015 01:38 PM, Christoph Berg wrote: > pgagent had not been rebuilt for quite a while which is why it didn't > have 9.4 (and jessie) support yet. Fixed now: Thanks! -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgadmin-support mailing list (pgadmin-support@p

Re: [pgadmin-support] pgagent DEB packages do not support postgres 9.4

Re: Josh Berkus 2015-07-02 <5595a156.2070...@agliodbs.com> > Folks: > > On Ubuntu 14.04, for the database server, there is a single pgagent > meta-package which is supposed ot cover all versions of Postgres. But > it fails: Hi, pgagent had not been rebuilt for quite a while which is why it didn

Re: [pgadmin-support] pgagent DEB packages do not support postgres 9.4

On 07/03/2015 01:05 AM, Dave Page wrote: >> > ... maybe it's time we had pgagent-#.# packages instead? > I don't know who maintains these packages. It's certainly not the > pgAdmin/pgAgent team. That's why I cc'd Christoph. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent v

Re: [pgadmin-support] pgagent DEB packages do not support postgres 9.4

On Thu, Jul 2, 2015 at 9:38 PM, Josh Berkus wrote: > Folks: > > On Ubuntu 14.04, for the database server, there is a single pgagent > meta-package which is supposed ot cover all versions of Postgres. But > it fails: > > root@491cc8cbb9c2:/# apt-get install pgagent > Reading package lists... Done

[pgadmin-support] pgagent DEB packages do not support postgres 9.4

Folks: On Ubuntu 14.04, for the database server, there is a single pgagent meta-package which is supposed ot cover all versions of Postgres. But it fails: root@491cc8cbb9c2:/# apt-get install pgagent Reading package lists... Done Building dependency tree Reading state information... Done The fol

[pgadmin-support] pgAgent Installation Password Issue

Hello- I'm running several PostgreSQL Servers 9.3 running on Windows 2008 R2 Datacenter Server (VM), and I'm using version 1.18.1 of pgAdmin. I'm currently trying to install and test pgAgent on a localhost instance, and once everything works locally I plan on installing pgAgent on our dev

Re: [pgadmin-support] pgAgent build error,(Ubuntu)

El mié, 25-03-2015 a las 19:49 +0300, Beholder escribió: > Problem with building on Ubuntu: > > Linking CXX executable pgagent > /usr/bin/ld: > /usr/lib/gcc/i686-linux-gnu/4.8/../../../../lib/libpq.a(fe-auth.o): undefined > reference to symbol 'error_message' > //lib/i386-linux-gnu/libcom_err.so

Re: [pgadmin-support] pgAgent build error,(Ubuntu)

Make sure, that you install all postgresql packages (postgresql-server-dev-9.3, and libpq).  25.03.2015, 19:49, "Beholder" :Problem with building on Ubuntu: -- Best regards, Dmitry Voronin 

[pgadmin-support] Re[2]: [pgadmin-support] pgAgent build error,(Ubuntu)

tested, 100%, everything need is established, including  postgresql-server-dev-9.3 and libpq, otherwise "ccmake" will not configure sources. Четверг, 26 марта 2015, 8:30 +03:00 от Dmitry Voronin : >Make sure, that you install all postgresql packages >(postgresql-server-dev-9.3, and libpq). >

[pgadmin-support] Re[2]: [pgadmin-support] pgAgent build error,(Ubuntu)

tested, 100%, everything need is established, including  postgresql-server-dev-9.3 and libpq, otherwise "ccmake" will not configure sources. Четверг, 26 марта 2015, 8:29 +03:00 от Dmitry Voronin : >Make sure, that you install all postgresql packages >(postgresql-server-dev-9.3, and libpq).  > 

[pgadmin-support] Re[2]: [pgadmin-support] pgAgent build error,(Ubuntu)

tested, 100%, everything need is established, including  postgresql-server-dev-9.3 and libpq, otherwise "ccmake" will not configure sources. Четверг, 26 марта 2015, 8:30 +03:00 от Dmitry Voronin : >Make sure, that you install all postgresql packages >(postgresql-server-dev-9.3, and libpq). >

Re: [pgadmin-support] pgAgent build error,(Ubuntu)

Make sure, that you install all postgresql packages (postgresql-server-dev-9.3, and libpq). 25.03.2015, 19:49, "Beholder" : >  Problem with building on Ubuntu: --  Best regards, Dmitry Voronin -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your s

[pgadmin-support] pgAgent build error,(Ubuntu)

Problem with building on Ubuntu: Linking CXX executable pgagent /usr/bin/ld: /usr/lib/gcc/i686-linux-gnu/4.8/../../../../lib/libpq.a(fe-auth.o): undefined reference to symbol 'error_message' //lib/i386-linux-gnu/libcom_err.so.2: error adding symbols: DSO missing from command line collect2: err

[pgadmin-support] Re[2]: [pgadmin-support] pgAgent build error

Thank you Dmitriy, but i already found where was my mistake)It exactly was missed libpq) Вторник, 24 марта 2015, 8:37 +03:00 от Воронин Дмитрий : >Beholder, hello. > >You must install libpq - dynamic client library for postgresql. And link it to >project. > >>  All steps for building doing l

Re: [pgadmin-support] pgAgent build error

Beholder, hello. You must install libpq - dynamic client library for postgresql. And link it to project. >  All steps for building doing like described here > https://github.com/postgres/pgagent --  Best regards, Dmitry Voronin -- Sent via pgadmin-support mailing list (pgadmin-support@pos

[pgadmin-support] pgAgent build error

Hello. OS: Windows 7 x64 pgAgent sources 3.4.0 CMake 2.6 wxWidgets 2.8.12 Visual Studio 2008 Express , Version 9.0.30729.1 SP, Visual C++ Microsoft Visual Studio 2008 Microsoft .NET Framework Version 3.5 SP1 All steps for building doing like described here https://github.com/postgres/pgagent

[pgadmin-support] PgAgent Windows Version

Anyone have pgAgent windows Version .exe files. Was found difficulties in compiling the sourcecode -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] pgagent and pg_service.conf

I tested a little more and it seems that the underlying library does something with pg_service.conf, as I can startup pgAgent without a .pgpass file and with PGSERVICE set and supplying only the username. $ sed -e 's/\(password=\).*/\1***/' .pg_service.conf [oaddev] dbname=oad user=oaddev host=pg-

Re: [pgadmin-support] pgagent and pg_service.conf

On Tue, Dec 16, 2014 at 10:17 AM, Dirk-Jan Faber wrote: > > Hello, > > I am just starting with pgagent. First thing I noticed was that it does > not work with pg_service.conf. The installation documentation on > http://www.pgadmin.org/docs/dev/pgagent-install.html refers to > http://www.postgresql

[pgadmin-support] pgagent and pg_service.conf

Hello, I am just starting with pgagent. First thing I noticed was that it does not work with pg_service.conf. The installation documentation on http://www.pgadmin.org/docs/dev/pgagent-install.html refers to http://www.postgresql.org/docs/current/static/libpq.html#libpq-connect for more information

[pgadmin-support] pgAgent 3.4.0 - unhandled unknown exception

  I’m migrating a database from postgres 9.2 to 9.3, and I’m having persistent problems getting pageant (3.4.0) running. I have no problems running pgagent on my old server (pg 9.2.4, agent 3.2.1). Any assistance you can provide would be appreciated.  I’m able to start a task. However, the task

Re: [pgadmin-support] pgagent install to other than default port

Computing Services Data Base Systems Administration (507)284-8837 -Original Message- From: Dave Page [mailto:dp...@pgadmin.org] Sent: Thursday, May 08, 2014 3:14 AM To: Barry, Jon A. Cc: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] pgagent install to other than default

Re: [pgadmin-support] pgagent install to other than default port

On Wed, May 7, 2014 at 8:54 PM, Barry, Jon A. wrote: > Just installed pgagent. Postgres install was according to some 3rd party > software and it installed with a non-default port. > > > > The agent insists on using the default port(I see that in the alerts when > the windows service is started:

[pgadmin-support] pgagent install to other than default port

Just installed pgagent. Postgres install was according to some 3rd party software and it installed with a non-default port. The agent insists on using the default port(I see that in the alerts when the windows service is started: It wants port 5432). So... the agent will not connect to the dat

Re: [pgadmin-support] PgAgent 3.3.0 batch scripts on windows always get status failed

On Thu, Feb 13, 2014 at 4:45 AM, Bastiaan Olij wrote: > Hi Dave, > > I think I speak for a number of people out there, seeing that over the > past year I've received a few emails requesting for the patched version > we have, that it would be nice if a new official release with the fixes > from the

Re: [pgadmin-support] PgAgent 3.3.0 batch scripts on windows always get status failed

Hi Dave, I think I speak for a number of people out there, seeing that over the past year I've received a few emails requesting for the patched version we have, that it would be nice if a new official release with the fixes from the past year would see the light of day. Cheers, Bas On 10/02/14

Re: [pgadmin-support] PgAgent 3.3.0 batch scripts on windows always get status failed

On Mon, Feb 10, 2014 at 4:58 AM, Paragon Corporation wrote: > We're having the same issue as described in this post. > > http://www.postgresql.org/message-id/CA+OCxoxoCGc7d7tRdyC5-32dDMtXyT1m59s_Lk > 3mohtxxfm...@mail.gmail.com > > > It sounds from the post that this issue was fixed. Was this ch

Re: [pgadmin-support] PgAgent 3.3.0 batch scripts on windows always get status failed

We're having the same issue as described in this post. http://www.postgresql.org/message-id/CA+OCxoxoCGc7d7tRdyC5-32dDMtXyT1m59s_Lk 3mohtxxfm...@mail.gmail.com It sounds from the post that this issue was fixed. Was this change ever pushed to stack builder? I was thinking maybe it wasn't since

Re: [pgadmin-support] pgAgent - adding parameters to runs

Hi Bastiaan, On Wed, Dec 11, 2013 at 7:56 AM, Bastiaan Olij wrote: > Hi Dinesh, > > > On 10/12/13 5:26 PM, Dinesh Kumar wrote: > > > Does > itwork > for you. Make this script as a single job to the pgAgent. > > We already use

Re: [pgadmin-support] pgAgent - adding parameters to runs

Hi Dinesh, On 10/12/13 5:26 PM, Dinesh Kumar wrote: > > Does it > > work for you. Make this script as a single job to the pgAgent. We already use that approach but it would still require us to configure a job for each database th

Re: [pgadmin-support] pgAgent - adding parameters to runs

Hi Bastiaan Olij, On Tue, Dec 10, 2013 at 2:55 AM, Bastiaan Olij wrote: > Hi all, > > I'm just throwing this out there to see if any one has had ideas about > doing this or can suggest a workaround. It may be the final push I need > to download the source and try my hand at extending pgAgent myse

[pgadmin-support] pgAgent - adding parameters to runs

Hi all, I'm just throwing this out there to see if any one has had ideas about doing this or can suggest a workaround. It may be the final push I need to download the source and try my hand at extending pgAgent myself :) The situation we have is that we have multiple databases on our server and t

Re: [pgadmin-support] pgAgent and postgreSQL problem

Sure Dave. Hi Steve, So, you downloaded PostgreSQL (which version?) and installed it (GUI? or Unattended? With what options?) on your MacBook pro Laptop and then using StackBuilder, you installed pgAgent. At the end of installation, you observed that your account name was deleted and instead pgAg

Re: [pgadmin-support] pgAgent and postgreSQL problem

Sandeep - can you help Steve out as a matter of priority please? On Tue, Oct 1, 2013 at 3:36 AM, wrote: > Folks, I am hoping for some help as I'm a newbie to this. > > I downloaded the postgreSQL software for my mac as I am planning to learn > SQL and database use on the web for various uses. (h

[pgadmin-support] pgAgent and postgreSQL problem

Folks, I am hoping for some help as I'm a newbie to this. I downloaded the postgreSQL software for my mac as I am planning to learn SQL and database use on the web for various uses. (have used access in the past, but multiple user access is a problem!) Used stackbuild

Re: [pgadmin-support] PGAgent runs all jobs on startup

-Original Message- From: Dave Page [mailto:dp...@pgadmin.org] Sent: Tuesday, August 13, 2013 4:13 AM To: David Greco Cc: PgAdmin Support (pgadmin-support@postgresql.org) Subject: Re: [pgadmin-support] PGAgent runs all jobs on startup On Mon, Aug 12, 2013 at 7:35 PM, David Greco wrote

Re: [pgadmin-support] PGAgent runs all jobs on startup

On Mon, Aug 12, 2013 at 7:35 PM, David Greco wrote: > I have about 20 jobs scheduled via PGAgent to run at various times. Some > daily, some every X minutes, some at certain times, etc. I just started > pgagent on the server and noticed it ran all my jobs upon startup, despite > it not being a sch

[pgadmin-support] PGAgent runs all jobs on startup

I have about 20 jobs scheduled via PGAgent to run at various times. Some daily, some every X minutes, some at certain times, etc. I just started pgagent on the server and noticed it ran all my jobs upon startup, despite it not being a scheduled time. Is this an option somewhere I'm missing?

Re: [pgadmin-support] pgagent on Greenplum

On Mon, May 13, 2013 at 4:55 PM, Kurics János wrote: > > Hello all, > > Could someone make pgagent on Greenplum work? > > Env info: > Linux gp 2.6.32-358.2.1.el6.x86_64 #1 SMP Wed Mar 13 00:26:49 UTC 2013 > x86_64 x86_64 x86_64 GNU/Linux > pgAgent-3.3.0-Source.tar.gz > greenplum-db-4.2.2.4-build-1

[pgadmin-support] pgagent on Greenplum

Hello all, Could someone make pgagent on Greenplum work? Env info:Linux gp 2.6.32-358.2.1.el6.x86_64 #1 SMP Wed Mar 13 00:26:49 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux pgAgent-3.3.0-Source.tar.gz greenplum-db-4.2.2.4-build-1-CE-RHEL5-x86_64.bin pgadmin3-1.16.1.zip I could install, start daemon a

[pgadmin-support] pgAgent v3.3 job running vacuumdb command fails

Hi, We are running PostgreSQL 9.1.9 with pgAgent v3.3 on a Mac OS X server (10.7.4), and using pgAdmin 1.14.3. I've set up a job to do a batch step where I have used the command line: vacuumdb -z -a The job fails, the "Result" shows 133. Can anyone share any insight into why this fails, and

[pgadmin-support] pgAgent: Output column in statistics of a step

Heya, Just a little enhancement request I'm hoping someone could pick up some day. The output column in the statistics of a step for a pgAgent job contains the output of the script that was run. In the statistics section you can only see the first bit of this text. It would be nice if there was so

Re: [pgadmin-support] PgAgent 3.3.0 batch scripts on windows always get status failed

[re-adding the list] On Wed, Feb 6, 2013 at 10:41 PM, Bastiaan Olij wrote: > Hey Dave, > > As you've read from David's reply the job's status now comes back as > successful which solves our immediate issue. I did a little more testing > to see if I could get it to react to different exit codes an

Re: [pgadmin-support] PgAgent 3.3.0 batch scripts on windows always get status failed

Hi On Mon, Feb 4, 2013 at 11:23 PM, Bastiaan Olij wrote: > Hi Dave, > > I don't think that will work, yes it will get the proper rc value but it > still leaves succeeded set to false. It needs inclusion of a check to > see if rc==0 and if so set succeeded to true provided that a successful > scri

Re: [pgadmin-support] PgAgent 3.3.0 batch scripts on windows always get status failed

Hi Dave, I don't think that will work, yes it will get the proper rc value but it still leaves succeeded set to false. It needs inclusion of a check to see if rc==0 and if so set succeeded to true provided that a successful script indeed returns an error level of 0 (which I think it should). And

Re: [pgadmin-support] PgAgent 3.3.0 batch scripts on windows always get status failed

Hi On Thu, Jan 31, 2013 at 2:03 AM, Bastiaan Olij wrote: > Hi All, > > First post on this list so I hope I'm doing things right. > We've had a problem for awhile now that any batch script run by pgagent > on windows gets the status failed even if the batch file runs just fine. > > I downloaded th

[pgadmin-support] PgAgent 3.3.0 batch scripts on windows always get status failed

Hi All, First post on this list so I hope I'm doing things right. We've had a problem for awhile now that any batch script run by pgagent on windows gets the status failed even if the batch file runs just fine. I downloaded the latest copy of the source code to have a look and found something str

Re: [pgadmin-support] pgAgent binaries

Ok. Thanks a lot for your patience. Regards Bartek -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] pgAgent binaries

On Wed, Dec 12, 2012 at 4:17 PM, Bartosz Dmytrak wrote: > > 2012/12/12 Dave Page >> >> >> The recommended way to get packages from SB for servers without an >> internet connection is to run SB normally on a machine of the same >> architecture > > > Make sense, but again: corporate live is not so

Re: [pgadmin-support] pgAgent binaries

2012/12/12 Dave Page > > The recommended way to get packages from SB for servers without an > internet connection is to run SB normally on a machine of the same > architecture Make sense, but again: corporate live is not so easy. Client machines runs on win 7 32bit, what makes them useless in t

Re: [pgadmin-support] pgAgent binaries

The new build is going through QA at the moment - it should be out in the next week or so. The recommended way to get packages from SB for servers without an internet connection is to run SB normally on a machine of the same architecture that is connected and then when the package downloads have c

Re: [pgadmin-support] pgAgent binaries

2012/12/12 Dave Page > You can install pgAgent using StackBuilder, which comes with the > PostgreSQL installers. > Thanks. My problem is that server is without internet connection. I found workaround with applications-v2.xml file, but there is a link to version 3.2.1, according to http://www.pga

Re: [pgadmin-support] pgAgent binaries

On Wed, Dec 12, 2012 at 10:31 AM, Bartosz Dmytrak wrote: > Hi all, > are there binaries for Windows? > I cannot see them any more... only sources are available. > http://ftp.postgresql.org/pub/pgadmin3/release/pgagent/ You can install pgAgent using StackBuilder, which comes with the PostgreSQL in

[pgadmin-support] pgAgent binaries

Hi all, are there binaries for Windows? I cannot see them any more... only sources are available. http://ftp.postgresql.org/pub/pgadmin3/release/pgagent/ Regards, Bartek

Re: [pgadmin-support] pgAgent exceptions error

Thanks - I've committed a patch to fix this based on your suggestion. Regards, Dave. On Thu, Sep 20, 2012 at 4:11 AM, Bartosz Dmytrak wrote: > Hi all, > I've tried to create pgAgent exception using pgAdmin, unfortunately without > success. > > Logs: > 2012-09-20 09:49:23 STATUS : Retrieving deta

[pgadmin-support] pgAgent exceptions error

Hi all, I've tried to create pgAgent exception using pgAdmin, unfortunately without success. Logs: 2012-09-20 09:49:23 STATUS : Retrieving details on pgAgent job ETL tasks... (0.02 secs) 2012-09-20 09:49:25 STATUS : Retrieving details on pgAgent schedule EveryDay at 5:59... 2012-09-20 09:49:25 STA

Re: [pgadmin-support] pgAgent job step reporting failure when batch command succeeds

> From: osleep > To: pgadmin-support@postgresql.org, > Date: 15/08/2012 18:44> Subject: [pgadmin-support] pgAgent job step reporting failure when > batch command succeeds> Sent by: pgadmin-support-ow...@postgresql.org> > Hey there,> > I am running PostgreSQL 9.0.8 and

[pgadmin-support] pgAgent job step reporting failure when batch command succeeds

Hey there, I am running PostgreSQL 9.0.8 and the latest version of pgAgent available through the Application StackBuilder using Windows Server 2003 Service Pack 2. I have a job that has one batch command step that continually fails even though the batch command is successful. When I checked the p

Re: [pgadmin-support] pgAgent reports failure upon success

Hipgadmin-support-ow...@postgresql.org wrote on 10/07/2012 16:05:18:> From: Dave Page > To: Martin French , > Cc: pgadmin-support@postgresql.org, pgadmin-support-ow...@postgresql.org> Date: 10/07/2012 19:12> Subject: Re: [pgadmin-support] pgAgent reports failure upon success>

Re: [pgadmin-support] pgAgent reports failure upon success

On Tue, Jul 10, 2012 at 1:57 PM, Martin French wrote: > Hi > > Thanks for the feedback. I certainly won't be discouraged by it! :) :-) >> - You have member name of [Get|Set]LastResult which set/return a >> member variable called lastStatus. These should be consistent to avoid >> confusion. > > W

Re: [pgadmin-support] pgAgent reports failure upon success

HiThanks for the feedback. I certainly won't be discouraged by it! :)> - You have member name of [Get|Set]LastResult which set/return a> member variable called lastStatus. These should be consistent to avoid> confusion.Will amend accordingly.> - Rather than setting lastStatus to 0 or -1, why not se

Re: [pgadmin-support] pgAgent reports failure upon success

Hi On Mon, Jul 9, 2012 at 10:30 AM, Martin French wrote: > Apologies wrong files attached! It is Monday after all... ;o) > > > (See attached file: connection.cpp.patch)(See attached file: > connection.h.patch)(See attached file: job.cpp.patch) OK, first of all, thanks for the patch. Second; plea

Re: [pgadmin-support] pgAgent reports failure upon success

Tree Diff. diff -r pgAgent-3.2.1-Source pgAgent-3.2.2-Sourcediff -r pgAgent-3.2.1-Source/connection.cpp pgAgent-3.2.2-Source/connection.cpp28a29>       lastStatus = 0;339a341>               {340a343,344>                       conn->SetLastResult(0);>               }344a349>                       co

Re: [pgadmin-support] pgAgent reports failure upon success

resql.org, pgadmin-support-ow...@postgresql.org> Date: 09/07/2012 10:16> Subject: Re: [pgadmin-support] pgAgent reports failure upon success> > Hi> > On Mon, Jul 9, 2012 at 10:11 AM, Martin French> wrote:> > Proposed patch for this bug in attached files.> >> >

Re: [pgadmin-support] pgAgent reports failure upon success

Hi On Mon, Jul 9, 2012 at 10:11 AM, Martin French wrote: > Proposed patch for this bug in attached files. > > (See attached file: connection.cpp)(See attached file: connection.h)(See > attached file: job.cpp) > > Tested against PG 9.1.4, all seems fine, success/failure reported correctly > even w

Re: [pgadmin-support] pgAgent reports failure upon success

back.Thanks.pgadmin-support-ow...@postgresql.org wrote on 06/07/2012 12:29:56:> From: Dave Page > To: Martin French , > Cc: pgadmin-support@postgresql.org> Date: 06/07/2012 15:35> Subject: Re: [pgadmin-support] pgAgent reports failure upon success> Sent by: pgadmin-support-ow...@postgresql.org&

Re: [pgadmin-support] pgAgent reports failure upon success

On Fri, Jul 6, 2012 at 12:26 PM, Martin French wrote: > Yep, can do, and will do Dave. > > Will be after the weekend now, but should have something Monday eve. > Great. > Have a good weekend mate. > > Cheers > And you! Cheers, Dave. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pg

Re: [pgadmin-support] pgAgent reports failure upon success

@postgresql.orgDate:06/07/2012 12:22Subject:Re: [pgadmin-support] pgAgent reports failure upon successHiOn Fri, Jul 6, 2012 at 11:36 AM, Martin French <martin.fre...@romaxtech.com> wrote:Hi Dave,That seems reasonable enough to me. GetLastError only returns a wxString though, fe

Re: [pgadmin-support] pgAgent reports failure upon success

Hi On Fri, Jul 6, 2012 at 11:36 AM, Martin French wrote: > Hi Dave, > > That seems reasonable enough to me. > > GetLastError only returns a wxString though, fed from PQerrorMessage so I > guess it would be the string that would be tested for content? > > Maybe passing the ExecStatusType into a DB

Re: [pgadmin-support] pgAgent reports failure upon success

?Thoughts? :)CheersMartinDave Page ---06/07/2012 11:06:04---Hi On Fri, Jul 6, 2012 at 8:04 AM, Martin FrenchFrom:Dave Page To:Martin French , Cc:pgadmin-support@postgresql.orgDate:06/07/2012 11:06Subject:Re: [pgadmin-support] pgAgent reports failure upon successHiOn

Re: [pgadmin-support] pgAgent reports failure upon success

Hi On Fri, Jul 6, 2012 at 8:04 AM, Martin French wrote: > > I've been through the code, and the return of 1 is coming back from the > number of rows inserted after ExecuteVoid so the logic following in job.cpp > seems incorrect: > > wxString stepstatus; > if (rc ==

[pgadmin-support] pgAgent reports failure upon success

pgAgent is reporting that the job running this query:insert into dba.pg_stat_bgwriter_data(select *, now() from pg_catalog.pg_stat_bgwriter);is failing with a return code of 1, despite having completed the insert ok.When I wrap the code in a "do" statement, it report

Re: [pgadmin-support] pgAgent Steps Not Executed

On Jan 18, 2012, at 6:34 AM, Dave Page wrote: >> Realized this when *neither* step ran last night. That certainly feels like >> a bug to me: if I have the “End” field blank (NULL), it should remain blank >> unless I set it. > > Agreed - I've committed a fix for this. > >>> In any event, I woul

Re: [pgadmin-support] pgAgent Steps Not Executed

On Mon, Jan 16, 2012 at 6:16 PM, David E. Wheeler wrote: > On Jan 16, 2012, at 9:05 AM, David E. Wheeler wrote: > >> postgres=#  select * from pgagent.pga_jobsteplog where jslid = 284; >> -[ RECORD 1 ]-- >> jslid       | 284 >> jsljlgid    | 211 >> jsljstid    | 1 >> js

Re: [pgadmin-support] pgAgent Steps Not Executed

On Jan 17, 2012, at 9:17 AM, Dave Page wrote: >> It’s the standard schema, I think. Attached. > > I really wanted the data in it :-) Oh, you didn’t say that. Will send privately in a mo. David -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your s

Re: [pgadmin-support] pgAgent Steps Not Executed

On Tue, Jan 17, 2012 at 5:15 PM, David E. Wheeler wrote: > On Jan 17, 2012, at 2:47 AM, Dave Page wrote: > >> Can you get me a dump of the pgagent schema please? > > It’s the standard schema, I think. Attached. I really wanted the data in it :-) -- Dave Page Blog: http://pgsnake.blogspot.com Tw

Re: [pgadmin-support] pgAgent Steps Not Executed

On Jan 17, 2012, at 2:47 AM, Dave Page wrote: > Can you get me a dump of the pgagent schema please? It’s the standard schema, I think. Attached. Best, David pgagent.sql Description: Binary data -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to y

Re: [pgadmin-support] pgAgent Steps Not Executed

Can you get me a dump of the pgagent schema please? On Mon, Jan 16, 2012 at 6:16 PM, David E. Wheeler wrote: > On Jan 16, 2012, at 9:05 AM, David E. Wheeler wrote: > >> postgres=#  select * from pgagent.pga_jobsteplog where jslid = 284; >> -[ RECORD 1 ]-- >> jslid    

  1   2   3   4   >