<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Menlo;
panose-1:2 11 6 9 3 8 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
p.p2, li.p2, div.p2
{mso-style-name:p2;
margin:0cm;
font-size:8.5pt;
font-family:Menlo;
color:black;}
span.s3
{mso-style-name:s3;
color:#400BD9;}
span.s4
{mso-style-name:s4;
color:#2FB41D;}
span.s1
{mso-style-name:s1;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-IN" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hello Bucardo Team,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Am getting below error, couldn’t able to solve. Please assist<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Ubuntu version: 20.04<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Postgres 14<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">And latest bucardo <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I have update the hba_conf<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:#400BD9;mso-fareast-language:EN-GB"># Database administrative login by Unix domain socket<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">local all postgres trust<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">local all all ident map=app<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:#400BD9;mso-fareast-language:EN-GB"># TYPE DATABASE USER ADDRESS METHOD<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:#400BD9;mso-fareast-language:EN-GB"># "local" is for Unix domain socket connections only<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">local all all trust<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:#400BD9;mso-fareast-language:EN-GB"># IPv4 local connections:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">host all all 127.0.0.1/32 scram-sha-256<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">host all all 0.0.0.0/0 md5<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:#400BD9;mso-fareast-language:EN-GB"># IPv6 local connections:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">host all all ::1/128 scram-sha-256<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">host all all 0.0.0.0/0 md5<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">host all bucardo 0.0.0.0/0 trust<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:#400BD9;mso-fareast-language:EN-GB"># Allow replication connections from localhost, by a user with the<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:#400BD9;mso-fareast-language:EN-GB"># replication privilege.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">local replication all trust<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">host replication all 127.0.0.1/32 scram-sha-256<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">host replication all ::1/128 scram-sha-256<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">and </span><span style="mso-fareast-language:EN-GB">/etc/postgresql/14/main/pg_ident.conf'<span style="color:black"> </span><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:#400BD9;mso-fareast-language:EN-GB"># Put your actual configuration here<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:#400BD9;mso-fareast-language:EN-GB"># ----------------------------------<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:#400BD9;mso-fareast-language:EN-GB"># MAPNAME SYSTEM-USERNAME PG-USERNAME<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">app root postgres<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">app root bucardo<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:Menlo;color:black;mso-fareast-language:EN-GB">app {username} bucardo<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="p2"><span class="s4"><b>ubuntu@ip-172-31-32-191</b></span><span class="s1">:</span><span class="s3"><b>~</b></span><span class="s1">$ sudo bucardo show all</span><o:p></o:p></p>
<p class="p2"><span class="s1">DBI connect('dbname=bucardo;host=localhost;port=5432','bucardo',...) failed: connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:</span><span class="apple-converted-space">
</span><span class="s1">password authentication failed for user "bucardo"</span><o:p></o:p></p>
<p class="p2"><span class="s1">connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:</span><span class="apple-converted-space">
</span><span class="s1">password authentication failed for user "bucardo" at /usr/bin/bucardo line 310.</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Kotresh<o:p></o:p></span></p>
</div>
</body>
</html>