pg.ddx.io pgsql-pkg-docker@postgresql.org mailing list archivehelp / 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