Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a7Kld-00088Z-2o for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Dec 2015 10:17:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a7Klc-0004y0-IJ for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Dec 2015 10:17:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a7KkJ-0003U1-4n for pgsql-hackers@postgresql.org; Fri, 11 Dec 2015 10:16:15 +0000 Received: from mail.anarazel.de ([217.115.131.40]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1a7KkG-00025K-Qd for pgsql-hackers@postgresql.org; Fri, 11 Dec 2015 10:16:14 +0000 Received: by mail.anarazel.de (Postfix, from userid 108) id 44FE8860005; Fri, 11 Dec 2015 11:16:12 +0100 (CET) X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on mail X-Spam-Level: X-Spam-Status: No, score=-5.3 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00, FS_REPLICA autolearn=no version=3.2.5 Received: from anarazel.de (p57B4EF2E.dip0.t-ipconnect.de [87.180.239.46]) (Authenticated sender: andres@anarazel.de) by mail.anarazel.de (Postfix) with ESMTPSA id 9057A860002; Fri, 11 Dec 2015 11:16:08 +0100 (CET) Received: by anarazel.de (Postfix, from userid 1000) id 24C141062FF; Fri, 11 Dec 2015 11:16:08 +0100 (CET) Date: Fri, 11 Dec 2015 11:16:08 +0100 From: Andres Freund To: Craig Ringer Cc: Robert Haas , Simon Riggs , Konstantin Knizhnik , pgsql-hackers Subject: Re: Logical replication and multimaster Message-ID: <20151211101608.GN14789@awork2.anarazel.de> References: <565C7756.9070604@postgrespro.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Pg-Spam-Score: -4.2 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 2015-12-11 18:12:55 +0800, Craig Ringer wrote: > On 10 December 2015 at 03:19, Robert Haas wrote: > > On Sun, Dec 6, 2015 at 10:24 PM, Craig Ringer > > wrote: > > > * A way to securely make a libpq connection from a bgworker without > > messing > > > with passwords etc. Generate one-time cookies, sometihng like that. > > > > Why would you have the bgworker connect to the database via TCP > > instead of just doing whatever it wants to do directly? > pg_dump and pg_restore, mainly, for copying the initial database state. Well, you don't want to necessarily directly connect from the bgworker, but from processes started from a bgworker. I guess that's where a good bit of the Robert's confusion originated. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers