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 1lAgmC-0004xW-1O for pgsql-admin@arkaria.postgresql.org; Fri, 12 Feb 2021 22:19:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lAglf-0004id-6j for pgsql-admin@arkaria.postgresql.org; Fri, 12 Feb 2021 22:18:27 +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 1lAgle-0004iW-NS for pgsql-admin@lists.postgresql.org; Fri, 12 Feb 2021 22:18:26 +0000 Received: from sonic306-3.consmr.mail.bf2.yahoo.com ([74.6.132.42]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lAgla-00022I-O6 for pgsql-admin@postgresql.org; Fri, 12 Feb 2021 22:18:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1613168299; bh=fwF8OfhclYqdlLm66haIlBh5Nq/iTNZGtX6J0w+hNGU=; h=Date:From:Reply-To:To:Subject:References:From:Subject:Reply-To; b=D8lRc+TujYIbDkINWSgLfA4h21GX6lyHXBPyXRkcUgzLYkkxF3hYY6YMnK5VHwg+Nj3hJIRHXDuPZzUmNiZw2L3FhvIhkz7AzFoa3n0lOBt90+C17GZCYvkPegJD+7W9f6jI+u1EVdsa9CXcFa5K2ikcOZFUTK01Qlgp1X9XObUvQz8vM1IKWz+BSbLVObr3SgwGJghEbQCXsyk6vIDL54yLDAJW+QFU+zjk2ZiSvUa9qvkYNyykk6YER7R/3DTBay14d0hMkuKj9ppvlvo4C6Wz5+scZ2xizh++I7G1wpxCR4M2LZE5BILXpkZmU/MTQZjL7FbMGUC2S6c/FDQ8Xg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1613168299; bh=JqSayt9mjnsCyhIRqCkRurjHUAvVOj3F5QXhJeCz7SD=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=s8rGsQ1qZD1hl2ORAwGTfqBJuS/qN/7gN9ElJGREJ5xY1qn+FNZjjtkyrs76DXfojoPig5hAqnnWh6TWy/ZYO5K6oGl51i4aKW8MiQsKxoCem6Dpj3hi8n0c6ndarvRbq0E1/ssyuQ1jPdVqRGo0WhUd9Cm6cBJZKCygsOhiJ96ub7IBQ9+HvIW2b2LKAZnLUwDhCZxxTD+262MgHKe4xwzZoVhXVIcBLW5256Gyo9354cwZtvqE/zCueymBdy0wIpbITI6xxUvhsq7+XyftnxR5V38/yiOUFMANATobxP13uhEcFheL/iEGK2Q7RyoOUFvbDFdvMZtUnjJE1+PFjg== X-YMail-OSG: 9TtoYtsVM1lRSC_W2Biep50suFJB9Te4CnyXcN8marwywfJVSCJa3w2Lb1SbTxW a1FxsiwlRMxRb32xg4viqyoyTUQ9KwSEngqmc3tsAjACv1a8734uAMseG_FAPygg64Tqmk6e.ThC X4Ffb22YvfQm5Oe2aATrOf_qYuqsQw8abhq9dp3VqG4JoVNLJvBbUgf7pkF_g.g.t2PR9I_rmJVa BWEOuJZJxQwB5lIGhyCW6bnx.TFQYPxumVNNSee7LSKEqvBsbd0t73NRH7TTYPiF96h1v7LaBo_T vVmexRoqaB5PFthlV48H00cHAzb6qoRnvZ6LzT0gC.H6yMaG4Q2ns_YuNC0jZCRh5ekoUxspvqSQ tfr0TVQxyJhC3WhpcHHMEKJ6ULqh2q39OSf_6zJSgfB.yWWza6DBXi5zmNmm.5i9iLF402fsMBm8 yRMKCNCrJ9akq_Szv9ing6KwJfldHnKEm1eTx4E4S0290DG4HaiRHayIekp6YB9fsvamUftoVGYI Qjey72Msw9k8tbTEXBLOeLLovglaTkXllQctA0bP42bhbDu1hXYJvn2LnbrwtLmVTGc0y8yfEJbz 4rXX1o2x9J.0UaADk7S3MiNJLTlbg7qwIlYpLpJxm8j66B8fSYrVmf_8m4_YC6ZPle3l9witjVSz XWqnzV4to1sxjbGbL_4xMpyDPnHZyB0Q1NXwLclngZZzbWlGGbxzZH4Sn2H_CBi8FbAKCH3rn1ti CXZPU2ePxphqAJKi0fEe2YZHA7otzViME8F_bWwZJXjh3VGYxud293ZV2NDOVj6hiJop0XAroHZ5 ARIgVIb7dOACOd.mIwDP9mbBC5wPo6ELpwT6GU0DJhumMKho0lKCW.Z8TFnD6td0BDec73F9atd5 rfqIguePnREVpEue6h8v00Xz10bs2Kw5_oHzlDBFiuKwEzw1XxbUPzDisYDnV9krBoXZktMcqhtA v0xSug2KJK.gUfi.E7ix12YtjjcosoPsi3tOh9H7vrUQcJEvq0mDK3uWzWyy5Wvi1UVAGSiCeZdw 52eTl_xN2TxZCek8rXHSIA1vjI6Im_qknrP_KRtFogVS9TkvzrTxi9F8ImLMmz8C4js8fqaa2s23 .ZDkbxi3JZAKW9BOrGQpRURoINl6wxxgdH698v28zCskHBhB5xon0Q6AufUIe6M.liC3SaXq2D_P Xswf39IousKEFi3EB8B9yrNsVII75ajSW9TPq8wtpXlQQqoLDKUOA.lClspRTOUBlyzfxshbN2Cg 5.pdLrrxOLXAzlR6LO_5dD2gwFxl62W4DidB7xthNKRqlT_cR1FZX5cVviGeTt66YTeEia.CI3l3 Zm6D6DHnJykcePXpJk6fjLPDmnGFZ1yk9qzzTNBN7GsqKwQq7Ktm2alCt9YVI2oTRznnlOjPdsJg 84aZX2noYdQe3cAh5B3AsvEDMWFcrZ8_8xWYEqrxv69RCKKfC1a8JKv.LV9p_pDBf2PZqQMe4L5N 1le_IrIRP.tFkp8Z3fp8fruHUMt3EcksEaCC6OkyEzwVh1RuBvj5901zXqFczPZriEhXwpS_zDNU 0j2oJqE.A9IkBGPZJ62glmr2oo0_BO.tKmRsHR0HaOhM2Bfjf7mYCvJFTzyO34u5ZiIyKBG8yUZ2 QeW34X.OOQoJfTQzTOn.K1JbolvpYALdAcCr8.Ew1RYnmGCpZGWgWPKaCTG1QnhuHuGD9w_Tp9Cq XJrsRIXKGWBURO2IOttkmtIMtrBXX6UsZ6.dNVAdW9SR0w1Uv8RRiP2txs49dvWElr8dar5iUK40 MvbIXHH9ngLtFz_7Q9IWOI.N7vovJzzVPp9E.5T.aQOy8MGpyYZxdza1LcTTWP8SuSYXIzMi_qlv o.VkPlt0FFYlpW_KgItwIUMfCx85gKyMtx.Y0z2ZUV1h3vRO48hl44FOwy_SSXrL7n9epoisD7m1 WjUMKGKTube2vyqdgA1c0jFoeNN_n30yZR1fPPYvJJiAHO9XXfduKmJOqF6FIT5rXfq0aWF0nxLB hhfkOQVJucUZ4qRhvNQvn9FB1kss0m7a9qTPeaxa.uZ8k7RGqzRwU7PMKzYLjpQhY0xI72aIsytf AuSzzprO._yWH3VqULZADrfuoP263shRe4EARivAOtODUBGhWuatOVxRkw2u6BG5P_lvOlFq4gPP VqkIKjMsthkMF6XbrqvXpJwCTau74YzI2fjGWuAQmjA5BUwFuy4hi_CJ9Gkq4IW49lE26P9tRRDe v_1zdBpkBjMqoxiMvNzxS31jzV66QFUUGIJQaIrtS2lyObBcnODoDmUh3I8NoWxlkdyYlapGCIys vR5tysI.J2tv7ujjKUkBrz45oqm9Lmmd874K4i9Q7b7ck9JtqIT5gHshNNLpDY2Fl7l5oshXiCwx 4cybTNt0o5ULF1ZaytyM7Tl.OqBfAxPq_duLhLFMDx8cffiJXLS6yUIu762UdWfLfb7eBq_V3H3E yHy2xNcEDAL67aVMPiwzcl8qFgHwpBvF5Fh8tr6azQj_Xw_Z8KrEgDJjvnZRD5Q2u9EzbaNByqYm hAdB8mIKJ2QaaTm_h2Sd8eA-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic306.consmr.mail.bf2.yahoo.com with HTTP; Fri, 12 Feb 2021 22:18:19 +0000 Date: Fri, 12 Feb 2021 22:18:17 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "pgsql-admin@postgresql.org" Message-ID: <1983833580.900377.1613168297813@mail.yahoo.com> Subject: pg_baseback could not connect in AWS linux 2 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_900376_1649026122.1613168297811" References: <1983833580.900377.1613168297813.ref@mail.yahoo.com> X-Mailer: WebService/1.1.17712 YMailNorrin Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36 Content-Length: 15001 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_900376_1649026122.1613168297811 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello,=C2=A0=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0I got an error issue with pg_= basebackup from sql01 to sql02.=C2=A0 I Initdb on sql01 fine and created re= plicauser, set all parameters in postgresql.conf, and authenticate connecti= on in pg_hba.conf.=C2=A0 =C2=A0When I run pg_basebackup, could not connect = to server: connection time out.=C2=A0 Is the server running on host "x.x.x.= 204" and accepting TCP/IP connections on port 5432.I see the listen for por= t 5432 on sql01 but not in sql02. $netstat -nlp | grep 5432tcp=C2=A0 =C2=A0 0=C2=A0 0=C2=A0 0.0.0.0:5432=C2= =A0 0.0.0.0:*=C2=A0 LISTEN 5295/postmaster=C2=A0 /var/run/postgresql/.s.PGS= QL.5432 tcp6=C2=A0 0=C2=A0 0=C2=A0 :::5432=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= :::*=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 LISTEN 5295/postmaster=C2=A0= /tmp/.s.PGSQL.5432=C2=A0unix=C2=A0 2=C2=A0 [ACC]=C2=A0 STREAM=C2=A0 =C2=A0= LISTENING=C2=A0 =C2=A033401=C2=A0 5295/postmaster=C2=A0 =C2=A0/var/run/pos= tgresql/.s.PGSQL.5432unix=C2=A0 2=C2=A0[ACC]=C2=A0 STREAM=C2=A0 =C2=A0 LIST= ENING=C2=A0 =C2=A033940=C2=A0 5295/postmaster=C2=A0 =C2=A0/tmp/.s.PGSQL.543= 2 but netstat is not listened in sql02. pg_hba.conf in sql01:# locallocal=C2=A0 =C2=A0 all=C2=A0 =C2=A0all=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 peer# IPv4host=C2=A0 =C2=A0 =C2=A0all=C2=A0 =C2=A0= all=C2=A0 =C2=A0 127.0.0.1/32=C2=A0 =C2=A0identlocal=C2=A0 =C2=A0 =C2=A0all= =C2=A0 =C2=A0postgres=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 trust#=C2=A0 IPv6host=C2=A0 =C2=A0 =C2=A0 all=C2=A0 all=C2=A0 = =C2=A0 ::1/128=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0ident#replica= tion privilegelocal=C2=A0 =C2=A0 replication=C2=A0 =C2=A0 all=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0peer=C2=A0 =C2=A0 =C2=A0=C2=A0host=C2=A0 =C2= =A0 =C2=A0replication=C2=A0 =C2=A0 all=C2=A0 =C2=A0 127.0.0.1/32=C2=A0 =C2= =A0 =C2=A0 ident host=C2=A0 =C2=A0 =C2=A0replication=C2=A0 =C2=A0 all=C2=A0 =C2=A0 ::1/128= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0ident host=C2=A0 =C2=A0 =C2=A0replication=C2=A0 =C2=A0 all=C2=A0 =C2=A0 sql01_ip/= 32=C2=A0 =C2=A0 =C2=A0 trust host=C2=A0 =C2=A0 =C2=A0replication=C2=A0 =C2=A0 all=C2=A0 =C2=A0 sql02_ip/= 32=C2=A0 =C2=A0 =C2=A0 trust any ideas my setting wrong? v/r, Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love, and forgive more.To cal= l him a dog hardly seems to do him justice though in as much as he had four= legs, a tail, and barked, I admit he was, to all outward appearances. But = to those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success ------=_Part_900376_1649026122.1613168297811 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello,&nbs= p;
  &nb= sp;      I got an error issue with pg_basebackup from sql01 = to sql02.  I Initdb on sql01 fine and created replicauser, set all par= ameters in postgresql.conf, and authenticate connection in pg_hba.conf.&nbs= p;  When I run pg_basebackup, could not connect to server: connection = time out.  Is the server running on host "x.x.x.204" and accepting TCP= /IP connections on port 5432.
I see the listen for port 5432 on sql01 but not in s= ql02.
=
$netstat -nlp | grep 5432
tcp    0  0  0.0.0.0:5432  0.0.0= .0:*  LISTEN 5295/postmaster  /var/run/postgresql/.s.PGSQL.5432

tcp6  0  0&n= bsp; :::5432            :::*    &nb= sp;       LISTEN 5295/postmaster  /tmp/.s.PGSQL.5432&nb= sp;
unix = ; 2  [ACC]  STREAM    LISTENING   33401 = 5295/postmaster   /var/run/postgresql/.s.PGSQL.5432
unix  2 <= span style=3D"color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-se= rif; font-size: 16px;">[ACC]  STREAM    LISTENING  &nbs= p;33940  5295/postmaster   /tmp/.s.PGSQL.5432<= /div>

but netstat is not listened in sql02.

pg_hba.conf in sql01:
# local
local    all  &n= bsp;all                   = ;           peer
# IPv4
host     al= l   all    127.0.0.1/32   ident
local     a= ll   postgres              &nb= sp;   trust
#  IPv6
host      all  all    ::1/128   = ;          ident
#replication privilege
l= ocal    replication    all        &= nbsp;                    =    peer      
host     replication    all   = 127.0.0.1/32      ident
host     replication    = all    ::1/128              &n= bsp;ident
host     replication=     all    sql01_ip/32      trust=
host&nb= sp;    replication    all    sql02_ip/32 = ;     trust

any ideas my setting wrong?

v/r,


=
Bach-Nga

No one in= this world is pure and perfect.  If you avoid people for their mistak= es you will be alone. So judge less, love, and forgive more.3D"Emoji"3D"Emoji"3D"Emoji"
To call h= im a dog hardly seems to do him justice though in as much as he had four le= gs, a tail, and barked, I admit he was, to all outward appearances. But to = those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply = **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success

<= /font>

------=_Part_900376_1649026122.1613168297811--