public inbox for [email protected]  
help / color / mirror / Atom feed
Building server without Apache
3+ messages / 3 participants
[nested] [flat]

* Building server without Apache
@ 2017-01-12 02:12 Josh Berkus <[email protected]>
  2017-01-12 03:55 ` Re: Building server without Apache Dave Page <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Josh Berkus @ 2017-01-12 02:12 UTC (permalink / raw)
  To: pgadmin-hackers

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?

-- 
Josh Berkus
Containers & Databases Oh My!


-- 
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Building server without Apache
  2017-01-12 02:12 Building server without Apache Josh Berkus <[email protected]>
@ 2017-01-12 03:55 ` Dave Page <[email protected]>
  2017-01-12 05:50   ` Re: Building server without Apache Magnus Hagander <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Dave Page @ 2017-01-12 03:55 UTC (permalink / raw)
  To: Josh Berkus <[email protected]>; +Cc: pgadmin-hackers

On Thu, Jan 12, 2017 at 7:42 AM, Josh Berkus <[email protected]> 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.

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

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


-- 
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Building server without Apache
  2017-01-12 02:12 Building server without Apache Josh Berkus <[email protected]>
  2017-01-12 03:55 ` Re: Building server without Apache Dave Page <[email protected]>
@ 2017-01-12 05:50   ` Magnus Hagander <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Magnus Hagander @ 2017-01-12 05:50 UTC (permalink / raw)
  To: Dave Page <[email protected]>; +Cc: Josh Berkus <[email protected]>; pgadmin-hackers

On Jan 12, 2017 4:56 AM, "Dave Page" <[email protected]> wrote:

On Thu, Jan 12, 2017 at 7:42 AM, Josh Berkus <[email protected]> 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


^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2017-01-12 05:50 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-01-12 02:12 Building server without Apache Josh Berkus <[email protected]>
2017-01-12 03:55 ` Dave Page <[email protected]>
2017-01-12 05:50   ` Magnus Hagander <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox