MIME-Version: 1.0
In-Reply-To: 
 <CA+OCxoyE0M1zmw+AxQqLB2FffR8i1rkLeztcTrd2yUNQEA73nw@mail.gmail.com>
References: <b458454b-e147-2caa-f22a-326c261085ce@berkus.org>
 <CA+OCxoyE0M1zmw+AxQqLB2FffR8i1rkLeztcTrd2yUNQEA73nw@mail.gmail.com>
From: Magnus Hagander <magnus@hagander.net>
Date: Thu, 12 Jan 2017 06:50:32 +0100
Message-ID: 
 <CABUevEx3TRwEQCQbgOhEmP_1=tq+LfZGv7XBK3YhvjYmXNH1nQ@mail.gmail.com>
Subject: Re: Building server without Apache
To: Dave Page <dpage@pgadmin.org>
Cc: Josh Berkus <josh@berkus.org>,
 pgadmin-hackers <pgadmin-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary=001a11466622b3b9990545df4b23
Precedence: bulk
Sender: pgadmin-hackers-owner@postgresql.org

--001a11466622b3b9990545df4b23
Content-Type: text/plain; charset=UTF-8

On Jan 12, 2017 4:56 AM, "Dave Page" <dpage@pgadmin.org> wrote:

On Thu, Jan 12, 2017 at 7:42 AM, Josh Berkus <josh@berkus.org> wrote:
> Pgadmin gurus:
>
> I'm trying to create a canonical container image for pgAdmin4 Server.
> However, using Apache is kind of heavyweight for a container.  Has
> anyone run pgAdmin4 against something lighter weight?

If memory serves, the reason why we recommend Apache is that at the
time I last tested, it was the only one of Apache, Lighttpd and Nginx
which would support single-process, multi-thread WSGI apps.

Having a single process is essential, due to the global connection
manager used by pgAdmin - it's the only way we can guarantee affinity
between the user session and the database session. If you can make
that work with servers other than Apache (someone recently suggested
Gunicorn might be able to help), then I'd love to hear about it. There
are no other special requirements of pgAdmin, so really that's all
that stands in your way.


Uwsgi might also be worth investigating. It's pretty light and supports an
hybrid model where ISTM it would work if you just set number of processes
to 1 (but I haven't tried it with pgadmin specifically.

/Magnus

--001a11466622b3b9990545df4b23
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><br><div class=3D"gmail_extra"><br><div class=3D"gma=
il_quote">On Jan 12, 2017 4:56 AM, &quot;Dave Page&quot; &lt;<a href=3D"mai=
lto:dpage@pgadmin.org">dpage@pgadmin.org</a>&gt; wrote:<br type=3D"attribut=
ion"><blockquote class=3D"quote" style=3D"margin:0 0 0 .8ex;border-left:1px=
 #ccc solid;padding-left:1ex"><div class=3D"quoted-text">On Thu, Jan 12, 20=
17 at 7:42 AM, Josh Berkus &lt;<a href=3D"mailto:josh@berkus.org">josh@berk=
us.org</a>&gt; wrote:<br>
&gt; Pgadmin gurus:<br>
&gt;<br>
&gt; I&#39;m trying to create a canonical container image for pgAdmin4 Serv=
er.<br>
&gt; However, using Apache is kind of heavyweight for a container.=C2=A0 Ha=
s<br>
&gt; anyone run pgAdmin4 against something lighter weight?<br>
<br>
</div>If memory serves, the reason why we recommend Apache is that at the<b=
r>
time I last tested, it was the only one of Apache, Lighttpd and Nginx<br>
which would support single-process, multi-thread WSGI apps.<br>
<br>
Having a single process is essential, due to the global connection<br>
manager used by pgAdmin - it&#39;s the only way we can guarantee affinity<b=
r>
between the user session and the database session. If you can make<br>
that work with servers other than Apache (someone recently suggested<br>
Gunicorn might be able to help), then I&#39;d love to hear about it. There<=
br>
are no other special requirements of pgAdmin, so really that&#39;s all<br>
that stands in your way.</blockquote></div></div></div><div dir=3D"auto"><b=
r></div><div dir=3D"auto"><br></div><div dir=3D"auto">Uwsgi might also be w=
orth investigating. It&#39;s pretty light and supports an hybrid model wher=
e ISTM it would work if you just set number of processes to 1 (but I haven&=
#39;t tried it with pgadmin specifically.=C2=A0</div><div dir=3D"auto"><br>=
</div><div dir=3D"auto">/Magnus</div><div dir=3D"auto"><br></div></div>

--001a11466622b3b9990545df4b23--