pg.ddx.io  pgsql-pkg-docker@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Introduction + noob question -- where can I see the latest effort?
2+ messages / 2 participants
[nested] [flat]

* Introduction + noob question -- where can I see the latest effort?
@ 2014-08-01 12:30  Harry Percival <harry@pythonanywhere.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Harry Percival @ 2014-08-01 12:30 UTC (permalink / raw)
  To: pgsql-pkg-docker; Developers <developers@pythonanywhere.com>

Hi All,

I'm Harry, I work at PythonAnywhere, a Python PaaS thing.  We want to 
provide Postgres as an option for our users, and we've decided to go for 
a container-based model, so each user can have their "own" postgres 
server.  Multi-tenancy didn't really work.

I met Josh at OSCON, he suggested we subscribe to the list.  So, hello 
everyone!

My noob question is:  where can we see the latest progress?  Is there a 
dockerfile or a github repo or is it already on the public docker 
container repository thing?

Here's what we've got so far:
https://gist.github.com/hjwp/56972b110c969ee70628

That's a Dockerfile, a postgresql.conf and a pg_hba.conf.   We are very 
much "accidental DBAs", so any and all feedback would be received with 
almost inexpressible gratitude.

One thing that may be of interest is that we've decided to try and use 
9.4.  As you'll see from the Dockerfile, that involves a fair bit of 
compiling from source (if you want Postgis).

I hope we'll be able to make some sort of useful contribution!

rgds,
Harry

-- 
Harry Percival
Developer
harry@pythonanywhere.com

PythonAnywhere - a fully browser-based Python development and hosting environment
<http://www.pythonanywhere.com/;

PythonAnywhere LLP
17a Clerkenwell Road, London EC1M 5RD, UK
VAT No.: GB 893 5643 79
Registered in England and Wales as company number OC378414.
Registered address: 28 Ely Place, 3rd Floor, London EC1N 6TD, UK



-- 
Sent via pgsql-pkg-docker mailing list (pgsql-pkg-docker@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-pkg-docker



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

* Re: Introduction + noob question -- where can I see the latest effort?
@ 2014-08-01 16:59  Joseph Ferguson <joe@infosiftr.com>
  parent: Harry Percival <harry@pythonanywhere.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Joseph Ferguson @ 2014-08-01 16:59 UTC (permalink / raw)
  To: Harry Percival <harry@pythonanywhere.com>; +Cc: pgsql-pkg-docker; Developers <developers@pythonanywhere.com>

Hi and welcome.

On Fri, Aug 1, 2014 at 6:30 AM, Harry Percival <harry@pythonanywhere.com> wrote:
> My noob question is:  where can we see the latest progress?  Is there a
> dockerfile or a github repo or is it already on the public docker container
> repository thing?

https://github.com/docker-library/postgres/ is where the official
postgres images are managed.  Previously we were compiling from
source, but now it uses the packages from postgresql.org, which makes
it simpler to have all the current versions.  It is available on the
hub as postgres.

> Here's what we've got so far:
> https://gist.github.com/hjwp/56972b110c969ee70628

A few minor suggestions:
 (1) RUN apt-get update && apt-get install -y package package; That
way you get a natural cache bust if you change the list of packages.
It could be formatted as follows:

RUN apt-get update \
    && apt-get install -y -q postgresql-9.4 postgresql-client-9.4
postgresql-contrib-9.4 \
    && apt-get install -y -q postgresql-plpython-9.4 \
    && ...
or
RUN apt-get update && apt-get install ...
RUN apt-get update && apt-get install ...
or
RUN apt-get update && apt-get install -y -q \
    autoconf \
    build-essential \
    postgresql-9.4 \
    postgresql-client-9.4 \
   ...

 (2) Combine multiple RUN lines so that you can clean up unnecessary
files. I would change `RUN wget RUN tar RUN ./configure...` to `RUN
wget | tar && cd && ./configure && make && make install` with some new
lines and backslashes for readability.  That way the tar does not get
permanently saved into a layer of the image. Even a `RUN rm ...tar.gz`
would just add another layer and the tar would still take space in the
layer stack.

> One thing that may be of interest is that we've decided to try and use 9.4.
> As you'll see from the Dockerfile, that involves a fair bit of compiling
> from source (if you want Postgis).

I would suggest sticking with a stable version of postgres rather than
the beta.  And it should make things simpler for you.

- Joe Ferguson :: joe@infosiftr.com
  InfoSiftr :: Vice President of Programming


-- 
Sent via pgsql-pkg-docker mailing list (pgsql-pkg-docker@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-pkg-docker



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


end of thread, other threads:[~2014-08-01 16:59 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-08-01 12:30 Introduction + noob question -- where can I see the latest effort? Harry Percival <harry@pythonanywhere.com>
2014-08-01 16:59 ` Joseph Ferguson <joe@infosiftr.com>

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