Re: [pgadmin-support] PGAgent Question

2017-04-04 Thread Dave Barter
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

2017-04-04 Thread Basques, Bob (CI-StPaul)
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

2017-04-04 Thread Dave Barter
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 question

2010-12-16 Thread Dave Page
On Thu, Dec 16, 2010 at 11:35 AM, Dmitry Mordovin wrote: > On 12/16/2010 01:32 PM, Dave Page wrote: > > On Thu, Dec 16, 2010 at 11:29 AM, Dmitry Mordovin > wrote: > > Hello! > > Excuse me, I'm not sure this pgadmin list allow pgagent question. > > Yes, it does. > > Is there any way to execute sch

Re: [pgadmin-support] pgAgent question

2010-12-16 Thread Dmitry Mordovin
On 12/16/2010 01:32 PM, Dave Page wrote: On Thu, Dec 16, 2010 at 11:29 AM, Dmitry Mordovin wrote: Hello! Excuse me, I'm not sure this pgadmin list allow pgagent question. Yes, it does. Is there any way to execute scheduled job often than every 1-2 minutes? No. Hi Dave! How about to add

Re: [pgadmin-support] pgAgent question

2010-12-16 Thread Dave Page
On Thu, Dec 16, 2010 at 11:29 AM, Dmitry Mordovin wrote: > Hello! > > Excuse me, I'm not sure this pgadmin list allow pgagent question. Yes, it does. > Is there any way to execute scheduled job often than every 1-2 minutes? No. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake

[pgadmin-support] pgAgent question

2010-12-16 Thread Dmitry Mordovin
Hello! Excuse me, I'm not sure this pgadmin list allow pgagent question. Is there any way to execute scheduled job often than every 1-2 minutes? Regards Dmitry Mordovin

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Dave Page
Title: RE: pgAgent question   From: Benjamin Krajmalnik [mailto:[EMAIL PROTECTED] Sent: 20 April 2006 20:50To: Dave Page; pgadmin-support@postgresql.orgSubject: RE: [pgadmin-support] pgAgent question It takes about the same time. Since I do not need statistics on

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Benjamin Krajmalnik
Message-From: Dave Page [mailto:[EMAIL PROTECTED]Sent: Thursday, April 20, 2006 1:10 PMTo: Benjamin Krajmalnik; pgadmin-support@postgresql.orgSubject: RE: [pgadmin-support] pgAgent question   That looks straightforward enough - how quickly does it run in psql? That uses PQexec like pgAgent

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Dave Page
Title: RE: pgAgent question   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Benjamin KrajmalnikSent: 20 April 2006 17:53To: pgadmin-support@postgresql.orgSubject: Re: [pgadmin-support] pgAgent question The job has a single execution step

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Benjamin Krajmalnik
.orgSubject: RE: [pgadmin-support] pgAgent question   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Benjamin KrajmalnikSent: 20 April 2006 15:02To: pgadmin-support@postgresql.orgCc: Dave PageSubject: Re: [pgadmin-support] pgAgent question Yes. PgAdmin/

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Dave Page
Title: RE: pgAgent question   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Benjamin KrajmalnikSent: 20 April 2006 15:02To: pgadmin-support@postgresql.orgCc: Dave PageSubject: Re: [pgadmin-support] pgAgent question Yes. PgAdmin/pgAgent and

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Benjamin Krajmalnik
Title: RE: pgAgent question Yes. PgAdmin/pgAgent and PostgreSQL ar running on the same box. RUnning the stored procedure even from a remote pgAdmin at the console results in the same 16 second performance.   From: Dave Page [mailto:[EMAIL PROTECTED]Sent: Thu 4/20/2006 1:17 AMTo: Benjam

Re: [pgadmin-support] pgAgent question

2006-04-20 Thread Dave Page
> -Original Message- > From: Benjamin Krajmalnik [mailto:[EMAIL PROTECTED] > Sent: 19 April 2006 20:23 > To: Dave Page > Subject: pgAgent question > > Hi Dave, > > I have a quick question. > I have a stored procedure which we use to calculate > statistics against each test for the pa