Thank you David. Adding the bucardo information to the .pgpass in the postgres user home directory solved the issue for me. I only had it in the user that I was executing bucardo as which was not the same user postgres was running as.
I assume whatever user is running the postgres process must have the bucardo authentication information in its .pgpass for it to function correctly (even if the user is not postgres) because the postgres process is using the pl/perl extension to call the bucardo scripts and therefore assumes the home of that user? I am trying to wrap my head around how the application functions. Thanks again for the help. Sean Logan -----Original Message----- From: David Christensen [mailto:[email protected]] Sent: Thursday, June 15, 2017 10:30 AM To: Logan, Sean (U.S. Person) <[email protected]> Cc: [email protected] Subject: Re: [Bucardo-general] Setting up Bucardo with Postgres 9.5 Issues > 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
