Обсуждение: 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?
daylight savings time?? (CDT vs CEN time?)
"Things may come to those who wait, but only the things left by those who hustle.”
On Apr 4, 2017, at 4:27 PM, Dave Barter <dave@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 correctly.
SELECT now(); also gives me the date I expect?
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
"Things may come to those who wait, but only the things left by those who hustle.”
- Abraham Lincoln
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) <bob.basques@ci.stpaul.mn.us> wrote:daylight savings time?? (CDT vs CEN time?)On Apr 4, 2017, at 4:27 PM, Dave Barter <dave@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 correctly.
SELECT now(); also gives me the date I expect?
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
"Things may come to those who wait, but only the things left by those who hustle.”- Abraham Lincoln