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] pgadmin4 running behind nginx

this is how I got it to work : VHOST FILE == *server {* *listen *:443 ssl;* *server_name pg.YOURDOMAIN.com ;* * include /usr/local/nginx/conf/ssl.conf;* * include /usr/local/nginx/conf/proxies.conf;* * location / {* * proxy_pass http://pgad

[pgadmin-support] pgAdmin III Total query runtime back in microseconds (repost)

Hi, I repost this as the server seems to have hardtime with HTML mail. I have pgAdmin III 1.22.2. The total query runtime​ at the bottom right of the Query tool window is now  displayed in minutes when it's over 60 seconds. Is it possible to set it back to always show microseconds like it was i

Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load

Thanks Peter. You can adjust the log level by creating a config_local.py file alongside config.py in your installation. Add the lines in-between the === marks to the file: == from config import * import logging CONSOLE_LOG_LEVEL = logging.WARNING FILE_LOG_LEVEL = logging.WARNING == Those

Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load

Hi Dave, So far, so good. I uninstalled & removed everything from previous pgAdmin 4 and installed your new executable. Have started & stoped it 3 or 4 times, & loaded OK each time. (BTW, in my removal, I found a pgAdmin log file that was big, over 1.3GB. Not sure if that's relevant in any wa

Re: [pgadmin-support] pgadmin4 running behind nginx

On Tue, Apr 4, 2017 at 12:19 AM, rhuddbiz wrote: > well, setting APPLICATION_ROOT did not work. i know i have the > config_local.py setup correctly because i am able to configure > DEFAULT_SERVER. i think i see where you came up with APPLICATION_ROOT param, > http://flask.pocoo.org/docs/0.12/confi

Re: [pgadmin-support] pgadmin4 running behind nginx

well, setting APPLICATION_ROOT did not work. i know i have the config_local.py setup correctly because i am able to configure DEFAULT_SERVER. i think i see where you came up with APPLICATION_ROOT param, http://flask.pocoo.org/docs/0.12/config/. unfortunately, it looks like pgAdmin4.py does not mak