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

[Logan, Sean]

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:david at endpoint.com] 
Sent: Thursday, June 15, 2017 10:30 AM
To: Logan, Sean (U.S. Person) <slogan01 at harris.com>
Cc: bucardo-general at bucardo.org
Subject: Re: [Bucardo-general] Setting up Bucardo with Postgres 9.5 Issues


> 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