Re: pgadmin4 with nginx - Mailing list pgadmin-support

From Dave Page
Subject Re: pgadmin4 with nginx
Date
Msg-id CA+OCxowd2bz_iyrcqJ-jy3eLqJ7JyOQ_JWo6UHHV-ZztrrVfTQ@mail.gmail.com
Whole thread Raw
In response to pgadmin4 with nginx  ("Bartosz Dmytrak" <bdmytrak@gmail.com>)
List pgadmin-support
On Tue, Oct 4, 2016 at 9:57 PM, Bartosz Dmytrak <bdmytrak@gmail.com> wrote:
> Dear all,
>
> First of all  thanks for great job you’ve done !!

You're welcome.

> I’d like to use pgadmin4 with nginx, is there any config tutorial, help or
> any clue how to configure both?
>
> I’m using nginx as ssl proxy for other tomcat applications and I’d like to
> use it for pgadmin4 too.

I've never tried with nginx. It should be possible to get it working
though, provided that it can support a single process, multi-thread
WSGI application. Using more than one process will not work as there's
no way to maintain affinity between a client session and a backend
worker process, which is required because of the connection manager in
pgAdmin which ensures that database connections are reused by the
right sessions and tools. If you have multiple processes, then you
also have multiple connection managers, so there's no way to ensure
that a Query Tool or Debugger session (for example) will get the
correct connection each time it does something.

In Apache we'd typically suggest starting with 1 process and 25
threads in the worker. Increase the number of threads if needed.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgadmin-support by date:

Previous
From: "曾广宇"
Date:
Subject: pgadmin4 command keep running and process watcher won't go away
Next
From: "曾广宇"
Date:
Subject: =?gb18030?B?u9i4tKO6IFtwZ2FkbWluLXN1cHBvcnRdIHBnYWRt?= =?gb18030?B?aW40IGNvbW1hbmQga2VlcCBydW5uaW5nIGFuZCBw?= =?gb18030?B?cm9jZXNzd2F0Y2hlciB3b24ndCBnbyBhd2F5?=