[Bucardo-general] Error with postgresql-9.6

[David Christensen]

> On Aug 2, 2019, at 8:25 PM, Claudio Quevedo <claudio.quev92 at gmail.com> wrote:
> 
> Hello bucardo-general,
> 6 months ago I used bucardo and it worked correctly, today it didn't work after a long time I decided to reinstall both postgresql and bucardo. Once reinstalled, the following errors appeared:
>           $bucardo add database test2 dbname=test host=10.42.0.108
> node1=172.16.34.230, node2=10.42.0.108, db=test
> 
> Connection to "test2" (PostgreSQL database) as user bucardo failed.
> Error was: FATAL:  no pg_hba.conf entry for host "10.42.0.1", user "bucardo", database "test", SSL on
> FATAL:  no pg_hba.conf entry for host "10.42.0.1", user "bucardo", database "test", SSL off
> Will try to connect as user postgres and create superuser bucardo...
> Connection as postgres failed, too. You may force add it with the --force argument.
> Error was: FATAL:  no pg_hba.conf entry for host "10.42.0.1", user "postgres", database "test", SSL on
> FATAL:  no pg_hba.conf entry for host "10.42.0.1", user "postgres", database "test", SSL off
> 
> The bucardo superuser was already created, and the pg_hba.conf and postgresql.conf files have already been modified.
> A postgresql restart was also done.
> I don't know what else to do, and really bucardo is the only thing that worked for me to create a master-master connection.
> Thank you very much for your time, I will be attentive to your response.
> 
> Claudio Quevedo G.

Hi Claudio,

I would double-check the pg_hba.conf settings and make sure you’ve reloaded PostgreSQL after confirming those settings, as that is the reason the daemon is not being allowed to connect.  Did the host’s IP change or are you running Bucardo on a different host than last time?

HTH,

David
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20190813/344b0bba/attachment.sig>