Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XCBy5-0000QV-NS for pgsql-pkg-docker@arkaria.postgresql.org; Tue, 29 Jul 2014 18:17:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XCBy5-0003K8-3m for pgsql-pkg-docker@arkaria.postgresql.org; Tue, 29 Jul 2014 18:17:45 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XCBy4-0003K1-6m for pgsql-pkg-docker@postgresql.org; Tue, 29 Jul 2014 18:17:44 +0000 Received: from mx-out.zmailcloud.com ([192.198.85.98] helo=mx-out-1.zmailcloud.com) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XCBxw-0000UO-8z for pgsql-pkg-docker@postgresql.org; Tue, 29 Jul 2014 18:17:42 +0000 Received: from smtp.01.com (smtp.01.com [10.10.0.43]) by mx-out-1.zmailcloud.com (Postfix) with ESMTP id 6D223565790 for ; Tue, 29 Jul 2014 13:17:32 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id 67B596034D for ; Tue, 29 Jul 2014 13:17:32 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-2.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-2.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id P_X6tl7s_qRI for ; Tue, 29 Jul 2014 13:17:32 -0500 (CDT) Received: from smtp.01.com (localhost [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id 3CB0560350 for ; Tue, 29 Jul 2014 13:17:32 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by smtp-out-2.01.com (Postfix) with ESMTP id 26EEE6034D for ; Tue, 29 Jul 2014 13:17:32 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-2.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-2.01.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id cHifeXNZxriv for ; Tue, 29 Jul 2014 13:17:32 -0500 (CDT) Received: from [172.47.23.104] (50-0-190-100.dsl.dynamic.sonic.net [50.0.190.100]) by smtp-out-2.01.com (Postfix) with ESMTPSA id C5A186034C for ; Tue, 29 Jul 2014 13:17:31 -0500 (CDT) Message-ID: <53D7E53A.5080505@agliodbs.com> Date: Tue, 29 Jul 2014 11:17:30 -0700 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.5.0 MIME-Version: 1.0 To: pgsql-pkg-docker@postgresql.org Subject: SSH-free PostgreSQL X-Enigmail-Version: 1.6 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-pkg-docker Precedence: bulk Sender: pgsql-pkg-docker-owner@postgresql.org 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