<div dir="ltr">Hi Rodrigo,<div>I saw some projects in which the install process is automated. <a href="https://hub.docker.com/r/plgr/bucardo/dockerfile">This</a> Dockerfile is an example of an automated installation of bucardo.</div><div><br></div><div>Gustavo.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 18, 2021 at 1:27 PM Rodrigo Rodovalho <<a href="mailto:rodrigo.rodovalho@gmail.com">rodrigo.rodovalho@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Just for completeness, here is the output from "<i><b>bucardo@localhost$</b> bucardo install -h localhost --pid-dir /var/run/bucardo --dbuser bucardo --dbname bucardo</i>", run after the creation of a local linux <i>bucardo</i> user, a database called <i>bucardo</i> and a postgres user also called <i>bucardo</i> with SUPERUSER privileges.<div><br></div><div><i>-------------------------------------------------</i></div><div><i>This will install the bucardo database into an existing Postgres cluster.<br>Postgres must have been compiled with Perl support,<br>and you must connect as a superuser<br><br>Current connection settings:<br>1. Host: localhost<br>2. Port: 5432<br>3. User: bucardo<br>4. Database: bucardo<br>5. PID directory: /var/run/bucardo<br>Enter a number to change it, P to proceed, or Q to quit: P<br><br>Password for user bucardo: <br>Password for user bucardo: <br>Attempting to create and populate the bucardo database and schema<br>Password for user bucardo: <br>Database creation is complete<br><br>DBI connect('dbname=bucardo;host=localhost;port=5432','bucardo',...) failed: fe_sendauth: no password supplied at /usr/local/bin/bucardo line 9167.</i><br></div><div><i>------------------------------------------------</i></div><div><i><br></i></div><div><i><br></i></div><div>In my pg_hba.conf:</div><div>(...)</div><div><i>local all bucardo peer<br></i></div><div><i>(...)</i></div><div><i><br></i></div><div><i><br></i></div><div>Again, thanks</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Em qui., 18 de fev. de 2021 às 12:09, Rodrigo Rodovalho <<a href="mailto:rodrigo.rodovalho@gmail.com" target="_blank">rodrigo.rodovalho@gmail.com</a>> escreveu:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi,<br><div><br></div><div>I'm trying to automate deployment of bucardo in a multi-master setup using Ansible. </div><div><br></div><div>Initially I was manually creating both bucardo's database and user, prior running "bucardo install", but after a few tries I notice that "bucardo install" can do all that if is run with a Postgres SUPERUSER credentials, as follows: "bucardo install -h localhost --pid-dir /var/run/bucardo --dbuser postgres --dbname postgres". </div><div><br></div><div>The thing is, it keeps asking repeatedly (4 times exactly) for the password of <b>postgres</b> user at database level, even though the linux user running the "bucardo install" is the <b>postgres</b> user itself and the environment is configured for a peer authentication method from localhost. It should be able to connect to the database with no issues... </div><div><br></div><div>Just to further clarify, let me list here the installation steps in my Ansible Playbook:</div><div><br></div><div>1) Install Bucardo dependencies (For current Debian Stable)</div><div>2) Download Bucardo from git</div><div>3) Build Bucardo Makefile</div><div>4) Make Bucardo</div><div>5) Make Install Bucardo</div><div>6) Creates local linux bucardo user (not required, no?)</div><div>7) Copy <b><i>Install Script</i></b> (My wrapper script around "bucardo install"). This is the script that currently has to feed <b>postgres</b> database user's password 4 times to "bucardo install".</div><div>8) Create bucardo log and run directories</div><div>9) Run <i style="font-weight:bold">Install Script </i>as local <b>postgres</b> linux user.</div><div><br></div><div>I've tried, for several days now, run the "bucardo install" with a database bucardo user with SUPERUSER privileges but was unable for several connection issues. </div><div><br></div><div>I'm at that point that I want first a minimal working setup using Ansible.</div><div><br></div><div>Postgres 11 and bucardo 5.6.0, btw.</div><div><br></div><div>Many thanks for the help.</div></div>
</blockquote></div>
_______________________________________________<br>
Bucardo-general mailing list<br>
<a href="mailto:Bucardo-general@bucardo.org" target="_blank">Bucardo-general@bucardo.org</a><br>
<a href="https://bucardo.org/mailman/listinfo/bucardo-general" rel="noreferrer" target="_blank">https://bucardo.org/mailman/listinfo/bucardo-general</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature">Gustavo.</div>