PGPool II does not recognize backend_server0

2025-06-25 Thread Pablo Calientos
Hi all, I'm new to pgpool, I'm testing from scratch with version [postgres@pgpool-01 ~]$ pgpool --version pgpool-II version 4.6.2 (chirikoboshi) I'm following the ufficial guide at https://www.pgpool.net/docs/latest/en/html/example-basic.html. I started testing native replication mode, I use this

Re: password rules

2025-06-25 Thread raphi
Am 25.06.2025 um 17:33 schrieb Peter J. Holzer: On 2025-06-25 14:42:26 +0200, raphi wrote: [snip] That's not how the identiy principle works, at least not how it's implement in our company. A user in ldap has a direct relation to one digital entity, either a token from an application or certi

Re: password rules

2025-06-25 Thread Peter J. Holzer
On 2025-06-23 16:35:35 +0200, raphi wrote: > To be fair, setting up LDAP is very easy in PG, just one line in hba.conf > and all is done. But sadly, that's only where the problems begin. The > difficult part is to embedd this setup into a company, especially a large > one as I work for with over 10

Re: password rules

2025-06-25 Thread Peter J. Holzer
On 2025-06-25 14:42:26 +0200, raphi wrote: > > > Am 25.06.2025 um 13:55 schrieb Peter J. Holzer: > > On 2025-06-23 16:35:35 +0200, raphi wrote: > > > To be fair, setting up LDAP is very easy in PG, just one line in hba.conf > > > and all is done. But sadly, that's only where the problems begin. T

Re: PGPool II does not recognize backend_server0

2025-06-25 Thread Greg Sabino Mullane
Basic debugging: Try looking at each node more closely with pcp_node_info https://www.pgpool.net/docs/latest/en/html/pcp-node-info.html Also make sure you are always using health_check https://www.pgpool.net/docs/latest/en/html/runtime-config-health-check.html Specific debugging: 2025-06-19 1

Re: password rules

2025-06-25 Thread raphi
Am 25.06.2025 um 13:55 schrieb Peter J. Holzer: On 2025-06-23 16:35:35 +0200, raphi wrote: To be fair, setting up LDAP is very easy in PG, just one line in hba.conf and all is done. But sadly, that's only where the problems begin. The difficult part is to embedd this setup into a company, esp

Re: Cannot turn track_counts on

2025-06-25 Thread Anton Shepelev
I wrote: > I have a Postgres sever with the 'track_counts' setting > stuck in 'off'. [...] I ghosted-out from this thread with my tail between my legs, because the only collegue who had access to the affected machine had no time to spare and then went of vacation. He has returned now, and I hav