[Bucardo-general] Setting up Bucardo with Postgres 9.5 Issues

[David Christensen]

> On Jun 15, 2017, at 9:27 AM, David Christensen <david at endpoint.com> 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
david at endpoint.com
785-727-1171