Hi,
On Wed, 5 Apr 2023 at 01:01, Tatsuo Ishii wrote:
> Hi,
>
> I am not sure if Patroni provides load balancing feature.
>
It depends on understanding of load-balancing:
- If we talk about load balancing read-only traffic across multiple
replicas - it is very easy to achieve with Patroni.
- If
Hi,
> Hi Guys,
>
> Hope you are doing well.
>
> Can someone please suggest what is one (Patroni vs PGPool II) is best for
> achieving HA/Auto failover, Load balancing for DB servers.
I am not sure if Patroni provides load balancing feature.
> Along with this, can you please share the company/
On 4/4/23 02:01, Erik Wienhold wrote:
On 04/04/2023 03:50 CEST jian he wrote:
"Returns true if any JSON value at the given path matches the predicate.
Returns NULL when not a path predicate or comparing different types."
in first sentence, should we add something "otherwise return false."
Can someone please suggest what is one (Patroni vs PGPool II) is best
for achieving HA/Auto failover, Load balancing for DB servers. Along
with this, can you please share the company/client names using these
tools for large PG databases?
Having used pgpool in multiple production deployments
On Mon, 3 Apr 2023 06:33:46 +
Inzamam Shafiq wrote:
[...]
> Can someone please suggest what is one (Patroni vs PGPool II) is best for
> achieving HA/Auto failover, Load balancing for DB servers. Along with this,
> can you please share the company/client names using these tools for large PG
> d
First, let me say I was holding off replying/thanking everyone to have the
time
to properly test this. Erik's quasi-question makes me break that silence.
On Tue, Apr 4, 2023 at 10:46 AM Erik Wienhold wrote:
> > On 04/04/2023 07:55 CEST walt...@technowledgy.de wrote:
> > For me, checking whether
> On 04/04/2023 03:50 CEST jian he wrote:
>
> > "Returns true if any JSON value at the given path matches the predicate.
> > Returns NULL when not a path predicate or comparing different types."
>
> in first sentence, should we add something "otherwise return false." ?
I omitted the "otherwise f
> On 04/04/2023 07:55 CEST walt...@technowledgy.de wrote:
>
> Erik Wienhold:
> > A single DEFINER function works if you capture current_user with a parameter
> > and default value. Let's call it claimed_role. Use pg_has_role[0] to check
> > that session_user has the privilege for claimed_role (in
