Hi Rodrigo, I saw some projects in which the install process is automated. This <https://hub.docker.com/r/plgr/bucardo/dockerfile> Dockerfile is an example of an automated installation of bucardo.
Gustavo. On Thu, Feb 18, 2021 at 1:27 PM Rodrigo Rodovalho < [email protected]> wrote: > Just for completeness, here is the output from "*bucardo@localhost$ > bucardo install -h localhost --pid-dir /var/run/bucardo --dbuser bucardo > --dbname bucardo*", run after the creation of a local linux *bucardo* > user, a database called *bucardo* and a postgres user also called > *bucardo* with SUPERUSER privileges. > > *-------------------------------------------------* > > > > > > > > > > > > > > > > > > > *This will install the bucardo database into an existing Postgres > cluster.Postgres must have been compiled with Perl support,and you must > connect as a superuserCurrent connection settings:1. Host: > localhost2. Port: 54323. User: bucardo4. Database: > bucardo5. PID directory: /var/run/bucardoEnter a number to change it, P > to proceed, or Q to quit: PPassword for user bucardo: Password for user > bucardo: Attempting to create and populate the bucardo database and > schemaPassword for user bucardo: Database creation is completeDBI > connect('dbname=bucardo;host=localhost;port=5432','bucardo',...) failed: > fe_sendauth: no password supplied at /usr/local/bin/bucardo line 9167.* > *------------------------------------------------* > > > In my pg_hba.conf: > (...) > > *local all bucardo peer* > *(...)* > > > Again, thanks > > Em qui., 18 de fev. de 2021 às 12:09, Rodrigo Rodovalho < > [email protected]> escreveu: > >> Hi, >> >> I'm trying to automate deployment of bucardo in a multi-master setup >> using Ansible. >> >> 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". >> >> The thing is, it keeps asking repeatedly (4 times exactly) for the >> password of *postgres* user at database level, even though the linux >> user running the "bucardo install" is the *postgres* 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... >> >> Just to further clarify, let me list here the installation steps in my >> Ansible Playbook: >> >> 1) Install Bucardo dependencies (For current Debian Stable) >> 2) Download Bucardo from git >> 3) Build Bucardo Makefile >> 4) Make Bucardo >> 5) Make Install Bucardo >> 6) Creates local linux bucardo user (not required, no?) >> 7) Copy *Install Script* (My wrapper script around "bucardo install"). >> This is the script that currently has to feed *postgres* database user's >> password 4 times to "bucardo install". >> 8) Create bucardo log and run directories >> 9) Run *Install Script *as local *postgres* linux user. >> >> 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. >> >> I'm at that point that I want first a minimal working setup using Ansible. >> >> Postgres 11 and bucardo 5.6.0, btw. >> >> Many thanks for the help. >> > _______________________________________________ > Bucardo-general mailing list > [email protected] > https://bucardo.org/mailman/listinfo/bucardo-general > -- Gustavo.
_______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
