> 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
> 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
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 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
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 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."
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/
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
