Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h0lxc-0001iV-Hj for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Mar 2019 11:40:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h0lxa-0005pG-7p for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Mar 2019 11:40:42 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1h0lxa-0005p2-0A for pgsql-hackers@lists.postgresql.org; Mon, 04 Mar 2019 11:40:42 +0000 Received: from mail-pg1-x544.google.com ([2607:f8b0:4864:20::544]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h0lxT-00032y-39 for pgsql-hackers@postgresql.org; Mon, 04 Mar 2019 11:40:41 +0000 Received: by mail-pg1-x544.google.com with SMTP id i130so2937800pgd.1 for ; Mon, 04 Mar 2019 03:40:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=subject:from:to:cc:references:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=QECPQzs5omUtCwSO2yBU9hcKIukteervKKmvmFoBCRU=; b=U2FJv5si7w/TkoZ6ASpBE7DM/DTab6NA+J12ExS9c2xvO5TyDzqaezWYl8sIQyWLbx Hm61bUoIxh6Y0hbNu0QzHUKpX9aUk/hu25IJg8XqGDutimn1wHfP5RdXQ4T6vPp0DjJm mfh/0I4wOHo8KBZCwHG7NGlho9lsHarzTBylmpBGuTFlB0ctnHdl2mqpCD1y2MqxSNsy jGxZXrR0xnNZJNd48xcrGAz4iRqHVHFiV284IcowDHd5nJ8Cr1LEEm3SdYM0L8WKGkex TIzoTxrC7C6QlMUfOjcHvBVPNkmroJ/ZCMPcE0kHlUh47/8st+0Ya3bmuSGv4ocIz3zR /k+Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:from:to:cc:references:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=QECPQzs5omUtCwSO2yBU9hcKIukteervKKmvmFoBCRU=; b=cpIgSs6p2ix4sfzrNTrm2WtDNplQpZDYRlLDdn0bm6Wu66VgXGdqOlL548qMDoLkwJ FOEKEADy7k/VQxJ5GuEHYvo1n48UiwpVCFnLxyIeflmZ5pF6SRXI49TjjxeMPOdfhWsv zxMTXUJL8iCXn04xGDVCeHLXLTI124ydxSKh65tarFP478cXgQUgCrlJazhoj82s2/zP 1xfNhMfyuglbdL6EOQrAQhHHOBkvgbU96jvzZylXw5DuI8eYLGrJWtGxeqp7xJ3rvsJK /qhLlgLzc4zuhgrNHTAo4m/K4cGwplcekPX89dEhhHrJgiRsACo7dyZK/7UfDICRxgir QmjA== X-Gm-Message-State: APjAAAWSi6lpXIW6hghFqgqrpujQODj8jsAPvMd/D8efGhCO3z7j4JCg JDmEXfIJwCERS//Jc3oubQsvMoYu1Ejz4Up6hI6hlOgQzswtQ1V+P0inRPzMaxjaDpqBG1PY0co HDXI+lqQ5j6SibSiLr3smaFFb1rfjYIb11DG8n/DWrUpM8/DBHnUxVHuWOw556C8PhPEua4H+QK 0pqLBfKA9R7g== X-Google-Smtp-Source: APXvYqwndTXVn/3MnH0fZ9d2UovhqOFdW5wc1Ys+fDC2LdbSBvMeUWANCHOOcxznFV7BEYXmIzxLdg== X-Received: by 2002:a65:624c:: with SMTP id q12mr17602494pgv.75.1551699632716; Mon, 04 Mar 2019 03:40:32 -0800 (PST) Received: from localhost.localdomain ([114.143.109.178]) by smtp.gmail.com with ESMTPSA id p6sm10578236pgd.69.2019.03.04.03.40.30 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 04 Mar 2019 03:40:31 -0800 (PST) Subject: Re: Minimal logical decoding on standbys From: tushar To: Andres Freund Cc: Petr Jelinek , Robert Haas , Craig Ringer , Petr Jelinek , pgsql-hackers@postgresql.org References: <20181212204154.nsxf3gzqv3gesl32@alap3.anarazel.de> <7e905539-7fdc-6b29-5a56-ba48d180fef8@2ndquadrant.com> <20190301174628.rjzoi7arvci5ldcm@alap3.anarazel.de> Message-ID: <731c0de7-252e-619c-93c0-ca32ea415dff@enterprisedb.com> Date: Mon, 4 Mar 2019 17:10:25 +0530 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 03/04/2019 04:54 PM, tushar wrote: > .)Perform pg_basebackup using --slot=decoding_standby  with option -R > . modify port=5555 , start the server set primary_slot_name = 'decoding_standby'  in the postgresql.conf file of slave. -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company