Re: PATCH: To fix expanding server if server inaccessible (pgAdmin4)

From: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: PATCH: To fix expanding server if server inaccessible (pgAdmin4)
Date: 2016-05-31 18:33:26
Message-ID: CAG7mmozs-gzTnnJf_Bm5=M08GDTHQum7y8HxtHiUhpw_=fCfMA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

On Tue, May 31, 2016 at 11:56 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

>
> On 31 May 2016, at 19:08, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
> wrote:
>
> On Tue, May 31, 2016 at 8:28 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
> Hi
>>
>> On Tue, May 31, 2016 at 3:43 PM, Murtuza Zabuawala
>> <murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>> > Hi,
>> >
>> > As advised by Ashesh, I have tried flask 'threaded' options for this
>> issues
>> > & it fixed the issue.
>> >
>> > PFA patches to fix long load delay when expanding server if server is
>> > inaccessible.
>> > (RM#1185).
>>
>> That'll only affect users running under Werkzeug. What about Apache?
>> Is it an issue there?
>>
> A while ago - we discussed about the connection management issue, and we
> decided to write a deployment guide about using pgAdmin 4 as WSGI
> application under HTTPD using mod_wsgi.
> And, while configuring Apache, we will need to use the WSGIDaemon option
> with mod_wsgi, which will allow us to specify the number of threads to be
> used for request handling at a time.
>
> Reference:
> http://flask.pocoo.org/docs/0.11/deploying/mod_wsgi/#configuring-apache
>
>
> Right, and I wrote that guide - it's in the docs :-)
>
:-).

Good - I was thinking - you would ask me to write.. :P

>
> I just wanted to be sure that this particular issue isn't a problem in
> such a configuration.
>

It is not.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
<http://www.enterprisedb.com/>

*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi>

>
>
> --
> Thanks & Regards,
>
> Ashesh Vashi
>
>>
>> > ------
>> > Additional patches to enhance misc validations in
>> > menu.js/schema.js/dashboard.js.
>>
>> Please detail what these are intended to fix.
>>
>>
>> > (There are no RM's for these fixes, these are just enhancements)
>> >
>> >
>> > --
>> > Regards,
>> > Murtuza Zabuawala
>> > EnterpriseDB: http://www.enterprisedb.com
>> > The Enterprise PostgreSQL Company
>> >
>> >
>> > --
>> > Sent via pgadmin-hackers mailing list (pgadmin-hackers(at)postgresql(dot)org)
>> > To make changes to your subscription:
>> > http://www.postgresql.org/mailpref/pgadmin-hackers
>> >
>>
>>
>>
>> --
>> 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 (pgadmin-hackers(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgadmin-hackers
>>
>
>

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Harshal Dhumal 2016-05-31 19:53:08 Regarding issue 1241
Previous Message Dave Page 2016-05-31 18:26:46 Re: PATCH: To fix expanding server if server inaccessible (pgAdmin4)