Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jgwjT-0004pW-MS for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Jun 2020 20:44:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jgwjS-0004Vm-Jp for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Jun 2020 20:44:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jgwjS-0004Un-CQ for pgsql-hackers@lists.postgresql.org; Thu, 04 Jun 2020 20:44:58 +0000 Received: from mail-qk1-x744.google.com ([2607:f8b0:4864:20::744]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jgwjQ-0003yh-61 for pgsql-hackers@postgresql.org; Thu, 04 Jun 2020 20:44:57 +0000 Received: by mail-qk1-x744.google.com with SMTP id n11so7614695qkn.8 for ; Thu, 04 Jun 2020 13:44:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=6tUfvbQW/w41gaJD1g5Td+2X9EtoNlCXDQSCivSZhvc=; b=aLN1MpPbhqkYCNxPYPTkd2ih4SP883tPQKQivfomDI5UmxyK9lUjXLooOlshQL0gcu xXgZ3Qsbp2E+KELkte1zPLr23ZenH7Ek6n0tQkn3mM9DUXzgkNZFKH1esCHF6VRI317m NxT4MPPDT7DlTzH7IBwu7bAE/zsF01oN70jKMTo+QhKdaLUPIcmAYAVAkO9+PEF4I0vD O1W9YbWVAoAPJL0gESVYmSLwvbPtHrltLhoas0iVzDNTZEknF1nGWYBccScRDvlE391u vxSQCFmtGo5uQGsyWYrrzjLcgK8TNjguLEkKJaYnjgVCfhQz++lwzE6YwNFkNqnkPq8T fxbA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=6tUfvbQW/w41gaJD1g5Td+2X9EtoNlCXDQSCivSZhvc=; b=jOPKExDZ7QLKYjE1PpbvifC0q5LFmbkwEUyJpJckpkzZftxlIO0mY0gwhaWJbj+M2Q uCy5F5DK1+4vIK9BJVRQ6RMgeB0sl6qxUhUZXSoRFFAmZuOIVT4D4P6y2durera28l+X epAUj8ZJ1ndsfvxIZVyE3+upQF5KmtFWjj5z4cBNh6o0eT0cRCOi+itdT03uyCU3F5oi GuSHlBwHLBl9kJ3RuYcnJ5DylXZ/ba94uhaEgUbHkPNgwrNATOFiLp4xGdg3HpIn//Ug 6zDJIvXhrBOMR4PBpM1O7MaSb+pb5CGvciwDvnCPPsh21D/F3FWPYhba3vyULp2jogvx eDNw== X-Gm-Message-State: AOAM532hC8z26F2KOsCeTjUDCoV+btjY+tK2hiPlyYpaikW2mq4cgcNQ x7TsHr8ZJLtjfcKeu8W+xMDhOet+uQxcWZXj X-Google-Smtp-Source: ABdhPJxUtaE+VudXGcnzF10vB7hj424egwhcKmTDvhFcmweo2Eq/w2nh6sVZAQuRJUQ2TTXPKnm/4A== X-Received: by 2002:a37:a511:: with SMTP id o17mr6843295qke.141.1591303495311; Thu, 04 Jun 2020 13:44:55 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([190.95.18.252]) by smtp.gmail.com with ESMTPSA id z77sm4657501qka.59.2020.06.04.13.44.54 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 04 Jun 2020 13:44:54 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 0DC3B300727; Thu, 4 Jun 2020 16:44:53 -0400 (-04) Date: Thu, 4 Jun 2020 16:44:53 -0400 From: Alvaro Herrera To: Michael Paquier Cc: Andres Freund , Fujii Masao , Masahiko Sawada , Kyotaro Horiguchi , sitnikov.vladimir@gmail.com, PostgreSQL-development Subject: Re: SIGSEGV from START_REPLICATION 0/XXXXXXX in XLogSendPhysical () at walsender.c:2762 Message-ID: <20200604204453.GA32388@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20200604020729.GN89559@paquier.xyz> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-Jun-04, Michael Paquier wrote: > On Wed, Jun 03, 2020 at 06:33:11PM -0700, Andres Freund wrote: > >> I don't think having a physical replication connection access catalog > >> data directly is a great idea. We already have gadgets like > >> IDENTIFY_SYSTEM for physical replication that can do that, and if you > >> need particular settings you can use SHOW (commit d1ecd539477). If > >> there was a strong need for even more than that, we can add something to > >> the grammar. > > > > Those special case things are a bad idea, and we shouldn't introduce > > more. It's unrealistic that we can ever make that support everything, > > and since we already have to support the database connected thing, I > > don't see the point. > > Let's continue discussing this part as well. A logical replication connection cannot run SQL anyway, can it? it's limited to the replication grammar. So it's not like you can run arbitrary queries to access catalog data. So even if we do need to access the catalogs, we'd have to add stuff to the replication grammar in order to support that. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services