Re: pgadmin4 running behind nginx
От | jbiskofski |
---|---|
Тема | Re: pgadmin4 running behind nginx |
Дата | |
Msg-id | CAHpPzY4G+bwgjkR2NBRtf-2AFt4gks6_Fxnd3He2nQtTMnjwEg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: pgadmin4 running behind nginx (Dave Page <dpage@pgadmin.org>) |
Список | pgadmin-support |
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://pgadmin-backend;
proxy_next_upstream error timeout http_500 http_502;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $remote_addr;
proxy_set_header Host $host;
proxy_redirect http:// https://;
}
}
IN ANOTHER FILE ( in my case its called backends.conf )
============================================
upstream pgadmin-backend {
server 127.0.0.1:8080;
server 127.0.0.1:8080 backup;
server 127.0.0.1:8080 backup;
server 127.0.0.1:8080 backup;
}
=========================================
I dont know why but pgadmin sometimes fails in retrieving static content ( css, js, etc ) that it serves from python somehow. If one of these files fails to load the whole application becomes unresponsive.
I basically set it up so if it failes it retries again 3 times ( thats why I have 127.0.0.1 as a backup backend 3 times ). I know its ugly and its hacky, but it works.
Hope this helps.
- Jose
On Tue, Apr 4, 2017 at 12:19 AM, rhuddbiz <rhuddbiz@gmail.com> 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/config/. unfortunately, it looks like
> pgAdmin4.py does not make use of / pass that param. this appears to be the
> relevant content of pgAdmin4.py that would include that param.
> app.run(
> host=config.DEFAULT_SERVER,
> port=server_port,
> use_reloader=((not PGADMIN_RUNTIME) and app.debug),
> threaded=config.THREADED_MODE
> )
> . so i guess the default pgAdmin4.py is a no go . i'll have to go through
> the process of setting up a uWSGI server.
Flask has access to the entire config (it'll ignore the pgAdmin
specific parts). This is handled in web/pgadmin/__init__.py, around
line 144:
app.config.from_object(config)
app.config.update(dict(PROPAGATE_EXCEPTIONS=True))
I don't know why it's ignoring it - but as I said upthread, I've never
had to use it. It just works with Apache HTTPD (as intended).
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
В списке pgadmin-support по дате отправления:
Предыдущее
От: Pierre RacineДата:
Сообщение: pgAdmin III Total query runtime back in microseconds (repost)