From: | Petr Jelinek <petr(at)2ndquadrant(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de> |
Cc: | Craig Ringer <craig(at)2ndquadrant(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Logical replication and multimaster |
Date: | 2015-12-11 19:45:26 |
Message-ID: | 566B27D6.8040709@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2015-12-11 19:24, Robert Haas wrote:
> On Fri, Dec 11, 2015 at 5:16 AM, Andres Freund <andres(at)anarazel(dot)de> wrote:
>> On 2015-12-11 18:12:55 +0800, Craig Ringer wrote:
>>> On 10 December 2015 at 03:19, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>>>> On Sun, Dec 6, 2015 at 10:24 PM, Craig Ringer <craig(at)2ndquadrant(dot)com>
>>>> 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.
>
> That's part of it, yeah. I'm a little scared of this design. I mean,
> I understand now why Craig wants to do this (thanks for explaining,
> Craig!), but it seems like it's going to have a lot of the same
> reliability problems that pg_upgrade does. I'm not saying there's a
> better way to get the functionality, but it's pretty obvious that
> depending on tools other than the server itself, and in particular
> pg_dump, vastly increases the failure surface area.
>
Well, it's better than trying to write completely new catalogs dump tool
for this. As Craig said, it would be best if pg_dump functionality was
moved to functions in a backend, but that's probably not gonna happen
tomorrow.
--
Petr Jelinek http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2015-12-11 20:49:20 | Re: [sqlsmith] Failed to generate plan on lateral subqueries |
Previous Message | Alvaro Herrera | 2015-12-11 19:43:17 | Re: Bootstrap DATA is a pita |