Re: [Bucardo-general] Password auth issue + Bucardo and postgres

[Jon Jensen via Bucardo-general]

On Thu, 14 Jul 2022, Kotresh Kumar Toolahalli wrote:


Am getting below error, couldn’t able to solve. Please assist


Kotresh,

It looks to me like your pg_hba.conf is requiring a password for 
connections from 127.0.0.1, because this line:


host all all 127.0.0.1/32 scram-sha-256

Comes before this one:

host all bucardo 0.0.0.0/0 trust

If you want the "bucardo" user to connect with no password as that 
indicates, you should move that bucardo line before the "host" + "all" 
line, which takes priority the way you have it now.


Jon



Ubuntu version: 20.04
Postgres 14
And latest bucardo

I have update the hba_conf
# Database administrative login by Unix domain socket
local   all postgrestrust
local   all all ident map=app


# TYPE  DATABASEUSERADDRESS METHOD

# "local" is for Unix domain socket connections only
local   all all trust
# IPv4 local connections:
hostall all 127.0.0.1/32scram-sha-256
hostall all 0.0.0.0/0md5
# IPv6 local connections:
hostall all ::1/128 scram-sha-256
hostall all 0.0.0.0/0md5
hostall bucardo 0.0.0.0/0   trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication all trust
hostreplication all 127.0.0.1/32scram-sha-256
hostreplication all ::1/128 scram-sha-256


and /etc/postgresql/14/main/pg_ident.conf'

# Put your actual configuration here
# --

# MAPNAME   SYSTEM-USERNAME PG-USERNAME
app rootpostgres
app rootbucardo
app {username}  bucardo


ubuntu@ip-172-31-32-191:~$ sudo bucardo show all

DBI connect('dbname=bucardo;host=localhost;port=5432','bucardo',...) failed: connection to server 
at "localhost" (127.0.0.1), port 5432 failed: FATAL:  password authentication failed for 
user "bucardo"

connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL:  password 
authentication failed for user "bucardo" at /usr/bin/bucardo line 310.

Regards,
Kotresh


--
Jon Jensen
End Point Corporation
https://www.endpointdev.com/___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://bucardo.org/mailman/listinfo/bucardo-general

Re: [Bucardo-general] PostgreSQL Upgrade from 9.2 to 14 with Bucardo

[Jon Jensen via Bucardo-general]

Lucas,

Thanks for sharing your experience! That was interesting to read, and I'm 
glad it went well.


Jon


On Wed, 9 Mar 2022, Lucas via Bucardo-general wrote:


Hi guys!

You may have seen my previous posts about Streaming Replication Lag issues 
(in the PG General Mail list) and some questions regarding upgrading from 
PostgreSQL 9.2 to PostgreSQL 14. Well, I have completed the project a couple 
of weeks ago and have successfully migrated from PG 9.2 to PG 14. :)


You can check it out here: PostgreSQL Live Migration from 9.2 to 14 with 
Bucardo (lpossamai.me) [1]


My previous posts:

[1] 
https://www.postgresql.org/message-id/Z14WgPUs_T-sranXV8i1KakN-eGRgP7fFcKUR8wHJDmjR-V8tHXkIIVWPxEEUd69GBeQCCKD0BeFn4f9AKItYa22mk_DzQP0yKuhRoyXZCc=@sud0.nz


[2] 
https://www.postgresql.org/message-id/4fd63109744f5ef6eee098fc92c4fa87%40sud0.nz


Cheers!
Lucas

Links:
--
[1] https://lpossamai.me/2022-03-09-pg9_to_pg14/


--
Jon Jensen
End Point Corporation
https://www.endpointdev.com/
___
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://bucardo.org/mailman/listinfo/bucardo-general