Re: psql trying twice to connect to local DB

2023-10-07 Thread Ron
On 10/7/23 17:44, Steve Baldwin wrote: I have a local DB (15.2) running in a docker container. If I make a connection to that DB from most clients I see log entries like this: 2023-10-07 22:32:26.518 UTC,,,16278,"172.21.0.1:33192 ",6521dc7a.3f96,1,"",2023-10-07

Re: psql trying twice to connect to local DB

2023-10-07 Thread Tom Lane
Steve Baldwin writes: > If I make a connection to that DB from most clients I see log entries like > this: > ... > If however I use psql I see two connection log entries - sometimes almost a > second apart. For example: These log entries show that you're using password-based authentication. I

Re: psql trying twice to connect to local DB

2023-10-07 Thread Steve Baldwin
It seems this is not restricted to local connections. Here's the log entries from making a connection with the same psql client to a remote (RDS) instance: 2023-10-07 22:47:06.506 UTC,,,23005,"10.117.100.26:55302",6521dfea.59dd,1,"",2023-10-07 22:47:06 UTC,,0,LOG,0,"connection received:

psql trying twice to connect to local DB

2023-10-07 Thread Steve Baldwin
I have a local DB (15.2) running in a docker container. If I make a connection to that DB from most clients I see log entries like this: 2023-10-07 22:32:26.518 UTC,,,16278,"172.21.0.1:33192",6521dc7a.3f96,1,"",2023-10-07 22:32:26 UTC,,0,LOG,0,"connection received: host=172.21.0.1

Monitoring logical replication

2023-10-07 Thread Shaheed Haque
Hi, I've been playing with logical replication (currently on PG14), specifically in an AWS RDS Postgres context, but NOT using AWS' own replication tooling. I'm generally familiar with the challenges of distributed systems (such causality, time synchronisation etc), but not especially familiar