> On Jun 15, 2017, at 9:27 AM, David Christensen <[email protected]> wrote: > >> Upon running the ./bucardo add all tables command I get the following output: >> >> DBD::Pg::st execute failed: ERROR: DBI >> connect('dbname=dbname,'bucardo',...) failed: fe_sendauth: no password >> supplied at line 62. >> CONTEXT: PL/Perl function "validate_goat" at ./bucardo line 6850. >> >> I am able to connect to the database via psql by setting up the .pgpass file >> : psql -U bucardo >> >> *:5432:*:bucardo:bucardo > > Have you verified this .pgpass works as the bucardo user? You will need to > make sure it’s in the home directory of the user the bucardo daemon runs as, > not just the user launching Bucardo.
Actually, since this is coming from the validate_goat() SQL function, it’s likely running as the “postgres” user, so you should put that .pgpass in ~postgres/ as well, since it’s attempting to connect to the remote db from a plperl function. Best, David -- David Christensen End Point Corporation [email protected] 785-727-1171 _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
