pg.ddx.io  pgsql-pkg-docker@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Tianon Gravi <admwiggin@gmail.com>
Cc: Joe Ferguson <joe@infosiftr.com>
Cc: Postgres-Docker Mailing List <pgsql-pkg-docker@postgresql.org>
Subject: Re: SSH-free PostgreSQL
Date: Wed, 30 Jul 2014 12:52:20 -0700
Message-ID: <53D94CF4.8090000@agliodbs.com> (raw)
In-Reply-To: <WM!3e81a53b47e4223a63045ca3f8c388d7009bf5743e99c3d7868631a95214a553fae39b2e4252bb8eb41b7c2d2054e0e3!@asav-2.01.com>
References: <53D7E53A.5080505@agliodbs.com>
	<CAF3-kPERXGQ2im3EUcKv-4AnzBZiccCEN2s=bYMCZe2GbcPkbg@mail.gmail.com>
	<WM!a9d3e2665ded72dfb911b812d6f979055c0d7b1484a11d3f99418973008e542fac8ee870cff410b2054c79dd2985eac7!@asav-2.01.com>
	<53D9319A.7080708@agliodbs.com>
	<CAF3-kPGSDf++7iEs37+cf_9TmGSaW9nO1088N7XK9mz=k4qqgw@mail.gmail.com>
	<WM!63dd7ad73de32a27ad3d8eba07bc46cf029cd321a35cd6b9cac74e36fbb21936acfae0835a8bc69599bd65203ea87ad2!@asav-1.01.com>
	<53D94A0E.5070103@agliodbs.com>
	<CAHnKnK28FKTbT-nCNDt_4t0bbFjNoU++hqTT5WO2zY0=PUgrLg@mail.gmail.com>
	<WM!3e81a53b47e4223a63045ca3f8c388d7009bf5743e99c3d7868631a95214a553fae39b2e4252bb8eb41b7c2d2054e0e3!@asav-2.01.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-pkg-docker>

On 07/30/2014 12:42 PM, Tianon Gravi wrote:
> On 30 Jul 2014 13:40, "Josh Berkus" <josh@agliodbs.com
> <mailto:josh@agliodbs.com>> wrote:
>>
>> On 07/30/2014 12:34 PM, Joseph Ferguson wrote:
>> > On Wed, Jul 30, 2014 at 11:55 AM, Josh Berkus <josh@agliodbs.com
> <mailto:josh@agliodbs.com>> wrote:
>> >>
>> >> Question: how does --link work if the two dockers are on different
> machines?
>> >
>> > Currently it does not work at all. The local docker daemon knows
>> > nothing of other docker daemons.  I think expanding --link or
>> > something similar is planned for the future.
>> >
>> > Regardless, the --link could still be emulated by setting the correct
>> > env vars (POSTGRES_PORT_5432_TCP_ADDR POSTGRES_PORT_5432_TCP_PORT) on
>> > the linked-from host and setting the proper routing and possible port
>> > mapping to the container on the other machine.
>>
>> Those settings aren't *enough* though.  We also need to know user and
>> application name.
> 
> Well, you're not going to get that from just --link either, so I don't
> see a way for those to not be specified by the user.

Yeah, so I think having a MASTER_CONNECT_STRING ENV specified by the
user is the way to go.  If it's populated, it's a replica.

This brings up another issue with using the Ubuntu packages.  Those
packages initdb a database directory.  Increasingly, I'm thinking that
we *don't* want the generic initdb'd directory; we want to populate it
with something more sensible (whether master or replica).  Is there a
more elegant way to do this than scripting an rm -rf?

-- 
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: <53D94CF4.8090000@agliodbs.com>
Permalink:  ../53D94CF4.8090000@agliodbs.com/
Also on:    postgresql.org/message-id/53D94CF4.8090000@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, admwiggin@gmail.com, joe@infosiftr.com
  Subject: Re: SSH-free PostgreSQL
  In-Reply-To: <53D94CF4.8090000@agliodbs.com>
  References: <53D7E53A.5080505@agliodbs.com> <CAF3-kPERXGQ2im3EUcKv-4AnzBZiccCEN2s=bYMCZe2GbcPkbg@mail.gmail.com> <WM!a9d3e2665ded72dfb911b812d6f979055c0d7b1484a11d3f99418973008e542fac8ee870cff410b2054c79dd2985eac7!@asav-2.01.com> <53D9319A.7080708@agliodbs.com> <CAF3-kPGSDf++7iEs37+cf_9TmGSaW9nO1088N7XK9mz=k4qqgw@mail.gmail.com> <WM!63dd7ad73de32a27ad3d8eba07bc46cf029cd321a35cd6b9cac74e36fbb21936acfae0835a8bc69599bd65203ea87ad2!@asav-1.01.com> <53D94A0E.5070103@agliodbs.com> <CAHnKnK28FKTbT-nCNDt_4t0bbFjNoU++hqTT5WO2zY0=PUgrLg@mail.gmail.com> <WM!3e81a53b47e4223a63045ca3f8c388d7009bf5743e99c3d7868631a95214a553fae39b2e4252bb8eb41b7c2d2054e0e3!@asav-2.01.com> <53D94CF4.8090000@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