pg.ddx.io  pgsql-pkg-docker@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: pgsql-pkg-docker@postgresql.org
Subject: SSH-free PostgreSQL
Date: Tue, 29 Jul 2014 11:17:30 -0700
Message-ID: <53D7E53A.5080505@agliodbs.com> (raw)
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-pkg-docker>

All,

As I've started work on the Docker images for PostgreSQL, I've ended up
with the goal of trying to design a PostgreSQL system which doesn't
require SSHing into the server, to support the goal of one container =
one service.  I think this is also a good goal for PostgreSQL because a
server which can be run without SSHing in is more manageable at scale.

Actually, it turns out that our set of things which need shell access
for 9.4 for most users are fairly limited:

(1) start/stop/restart
(2) pg_hba.conf changes
(3) pg_basebackup
(4) replica promotion
(5) log access

For Docker at least, (1) could be handled with a container restart.
Does that make sense?

(2) I think is doable by installing the pgAdmin adminpack.  This will
also provide a postgresql.conf solution for 9.3.

(3) I'm thinking of doing this via parameterized (ENV for now) startup
of a Postgres container.  That is, you start up the container, and set
$ROLE=replica and $MASTER="connection string", and on startup it does a
basebackup and starts replication.  Make sense?

(4) I think the most sensible way to do this is via a pl/sh script, or
similar.

(5) For now we'll just make the logs output to Docker's stderr.  In
time, we'll want to figure out a way to make this work with CSVlog, but
that's a problem to solve later.

So, comments?  Ideas?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


-- 
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



view thread (9+ messages)  latest in thread

Message-ID: <53D7E53A.5080505@agliodbs.com>
Permalink:  ../53D7E53A.5080505@agliodbs.com/
Also on:    postgresql.org/message-id/53D7E53A.5080505@agliodbs.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-pkg-docker@postgresql.org
  Cc: josh@agliodbs.com
  Subject: Re: SSH-free PostgreSQL
  In-Reply-To: <53D7E53A.5080505@agliodbs.com>
  References: <53D7E53A.5080505@agliodbs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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