Hi Stefan,
On Thu, Feb 15, 2018 at 01:06:39PM +0100, Stefan Kaltenbrunner wrote:
> On 02/13/2018 10:58 PM, Mark Wong wrote:
> > Hi everyone,
>
> Hi Mark!
>
> >
> > I've been making some progress on some perf farm stuff and I just wanted
> > to make sure I understand how to best work with the pg infrastructure
> > when (if) we get far along to deploy something.
>
> good to hear that progress is made on that front!
>
> >
> > We're planning on having a django application for distributed clients to
> > be able to upload results, and for users to review results. Plus a
> > supporting postgres database. Similar to how the build farm is
> > structured.
>
> ok
>
> >
> > So I'm wondering things like, should we stick to a particular django or
> > python version, proof things on a particular linux distro (debian
> > stretch?) and what not. And anything else we should be mindful of.
> > Thanks!
>
> Well the postgresql.org infrastructure is running debian stretch and all
> our current django applications are on django 1.8.18 in a custom (but
> internally packaged) virtualenv - we have not yet decided on what
> version we will move to next (because 1.8 will be EoS'd in April) but it
> will likely be an LTS version.
>
> In general we very heavily rely on packaged software for maintainability
> so I would advise to stay away from versions of software that are not
> packaged in stretch (or debian in general) - for postgresql itself we
> use apt.postgresql.org so any version that is available there should be
> fine.
>
> Also note that you application should be designed to not require any
> root-user interaction because we usually do not hand out that kind of
> privilege.
Ok, all sounds good. I'll try to follow suit. Thanks!
Regards,
Mark
--
Mark Wong http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services