The row:
> #IPv4
> host all all127.0.0.1/32 <http://127.0.0.1/32>
seems strange for me.
Maybe try to change authentication method to 'trust' for a while:
#
#local:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all all trust
# The same using local loopback TCP/IP connections.
#
# TYPE DATABASE USER CIDR-ADDRESS METHOD
host all all 127.0.0.1/32 trust
and if everything will go well (with bucardo - including dbs synch) then
add some normal authentication.
> |#Database administrative login by Unix domain socket
> local all postgres peer
> local all bucardo md5
> #"local" is for Unix domain socket connections only
> local all all peer
> #IPv4
> host all all127.0.0.1/32 <http://127.0.0.1/32> md5
W dniu 24.11.2014 o 09:54, Hadri Rahman pisze:
Whenever I try to synchronize (or even run it in general) I would get
the error message:
|DBI connect('dbname=bucardo;host=localhost;port5432', 'bucardo',...) failed: FATAL:
password authentication failed for user "bucardo"
FATAL: password authentication failed for user "bucardo" at
/usr/local/bin/bucardo line 296
|
I've checked my installation, and confirmed that there is an entry for
user "Bucardo" and the password for user Bucardo in both the database
and .pgpass file matched, and I was able to install it successfully. But
when I tried to run or perform any synchronization, I would get the same
error message.
The contents of the pg_hba.conf file are as follows:
|#Database administrative login by Unix domain socket
local all postgres peer
local all bucardo md5
#"local" is for Unix domain socket connections only
local all all peer
#IPv4
host all all127.0.0.1/32 <http://127.0.0.1/32> md5
#IPv6
host all all ::1/128 md5
#Allow replication connections from localhost:
host replication rep192.168.0.111/32 <http://192.168.0.111/32> md5|
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
