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 1kFBwz-0004l4-H0 for pgsql-admin@arkaria.postgresql.org; Mon, 07 Sep 2020 07:52:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kFBwy-00017F-EQ for pgsql-admin@arkaria.postgresql.org; Mon, 07 Sep 2020 07:52:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kFBwy-000177-2a for pgsql-admin@lists.postgresql.org; Mon, 07 Sep 2020 07:52:28 +0000 Received: from mail-pl1-x642.google.com ([2607:f8b0:4864:20::642]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kFBwv-0004be-7X for pgsql-admin@lists.postgresql.org; Mon, 07 Sep 2020 07:52:27 +0000 Received: by mail-pl1-x642.google.com with SMTP id y6so4104230plk.10 for ; Mon, 07 Sep 2020 00:52:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language:content-transfer-encoding; bh=COG4aanvOeKZ8uQ4KkiZcRKOVRV4fOFG4DP50gX0XU8=; b=QKrYec7A55GRvwvMJhYrclvIUcg7TyNkPAfgeH7zsrRRBmbbPE5QGM/UH8O1tDSgfo a/gWNDLRTdFsDs1dW3YMe0daBqAuXLwCu/nBguz0nvL/CZbqT8xhaah4S3YQwH3FZ/pU OCrAdNhQ5xDIgfb14GkM3Df6oQqKaDWepi2WPISxLBgbxyrmRkl28vDw27Dwx663Ex2j 0d2RGCbVUZHozXSd8H2BCW+ZFaMMbG4ABdZmezhfcD22jd9qALR5J0UUXnkJOmHUCL8b hewH2yeMa9vXEebuBDthGT5qBJRNc87G+cIXm/dM0wXhEKzuIloZ+yE8cnAl6u5NdYwv fxng== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=COG4aanvOeKZ8uQ4KkiZcRKOVRV4fOFG4DP50gX0XU8=; b=c4ff0LEKqLl8MwnV+6VBnHa3VzO8XMj8Mk+vnYtmK37ibAyDboYJTcWB4ZRbQYx1aa OYYyvoKX1gWLV5U/DDuUjWHB/5TVxYgXELF1XCNzaz/EFxihsTDVgyvCYNC64VkhqYzV M1k9IFAWr9xZO0pMR2vQvqTo4I0Q1MnVC4imHNvaeJZvtkMjAjlWrtFH2DjOuYRhdUxt ZWiuRNFC8R6zZZ7lPtvX7SRPMZJLyTVSHka4dmxmyKZxOjMDj9w0NwI8etGgiM5COKen fh91PY6ndGjoVSpiCx7apKRHFfKi4BdLEl8/Xhrsta9k271WlwOrj8LKPEE9/h1RqNf0 E+tA== X-Gm-Message-State: AOAM530IDyXmKvKH84/JQvdprvlUrwDG+UL1sIOvpR7Ho3GvBPin3mg7 s2j50YCZzQF5IwOGjLRDrs4i7TC6PPT0ZjL/k8wEeHO+vsNI7208thTizFReT4Q4OhRaTPNh4xj HYiAEOosGkMGIo6sKX8pfDZp3+q6Lo0JYe2eGxzcMlugNlFEbn3DjYtEyMdp2HMuancxPvygslC Cium1qx0bQCONMN0xRZvzr X-Google-Smtp-Source: ABdhPJy93bTuTikQYBZ8j8JdxLQfZK8YXJ0pKi+/BBWIdozjTZUjJzxGVEqJgwK6jl+0gYslIov3bg== X-Received: by 2002:a17:90b:889:: with SMTP id bj9mr19804855pjb.101.1599465142783; Mon, 07 Sep 2020 00:52:22 -0700 (PDT) Received: from osaka.octopusnet (p4375216-ipngn23601marunouchi.tokyo.ocn.ne.jp. [118.6.208.216]) by smtp.gmail.com with ESMTPSA id k4sm15240749pfp.189.2020.09.07.00.52.21 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 07 Sep 2020 00:52:22 -0700 (PDT) Subject: Re: is it mandatory to have ssh port 22 open for WAL replication To: Sanjib Mohanty , pgsql-admin@lists.postgresql.org References: From: Ian Barwick Message-ID: <9b0c0215-35fe-66ca-74f6-52fcf0512b00@2ndquadrant.com> Date: Mon, 7 Sep 2020 16:52:20 +0900 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.11.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020/09/07 16:47, Sanjib Mohanty wrote: > Hi Experts, > > Is it mandatory to have ssh port 22 open between the master and slave for wal replication? > > I believe this is done on 5432 port , rirht? Correct, all replication is handled via the port PostgreSQL itself listens on, default 5432. PostgreSQL itself does not require or use SSH. Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services