[Bucardo-general] having trouble installing

[Christophe Pettus]

Very likely you are missing one of "local" and "127.0.0.1" in your pg_hba.conf set to "trust".  "local" and "127.0.0.1" aren't the same in hba.conf; one is local sockets, and the other is a local TCP/IP connection.  From the looks of it, you need to set "local" to trust as well as "127.0.0.1".

On Jul 22, 2011, at 3:30 PM, Tony Caduto wrote:

> I followed the directions and I can get to the add database part and 
> then I get a error about ident authentication failed for
> user postgres, so I su postgres and then get a error that role bucardo 
> already exists:
> 
> root at securetrans:~/Bucardo-4.4.6# bucardo_ctl --dbhost 127.0.0.1 add 
> database securetrans
> Added database "securetrans"
> root at securetrans:~/Bucardo-4.4.6# bucardo_ctl --dbhost 127.0.0.1 add all 
> tables
> DBI connect('dbname=securetrans;port=5432','postgres',...) failed: 
> FATAL:  Ident authentication failed for user "postgres" at 
> /usr/local/bin/bucardo_ctl line 5280
> root at securetrans:~/Bucardo-4.4.6# su postgres
> postgres at securetrans:/root/Bucardo-4.4.6$ bucardo_ctl --dbhost 127.0.0.1 
> add all tables
> DBD::Pg::db do failed: ERROR:  role "bucardo" already exists at 
> /usr/local/bin/bucardo_ctl line 5281.
> 
> I was following the directions and for my testing I have everything in 
> the hba config file set to trust.
> 
> Any ideas?
> 
> Thanks,
> 
> Tony
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general

--
Christophe Pettus
PostgreSQL Experts, Inc.
christophe.pettus at pgexperts.com