Re: Logging queries executed by SPI_execute

2025-02-03 Thread Pavel Stehule
út 4. 2. 2025 v 5:09 odesílatel Marcelo Fernandes napsal: > On Mon, Feb 3, 2025 at 6:46 PM Pavel Stehule > wrote: > > The queries executed by SPI are never executed on the top level. These > queries are marked as nested. > > > > So you need to use auto_explain > https://www.postgresql.org/docs/c

Re: Logging queries executed by SPI_execute

2025-02-03 Thread Marcelo Fernandes
On Mon, Feb 3, 2025 at 6:46 PM Pavel Stehule wrote: > The queries executed by SPI are never executed on the top level. These > queries are marked as nested. > > So you need to use auto_explain > https://www.postgresql.org/docs/current/auto-explain.html with active > auto_explain.log_nested_stat

Re: could not accept ssl connection tlsv1 alert unknown ca

2025-02-03 Thread Adrian Klaver
On 2/3/25 08:09, Adrian Klaver wrote: On 2/3/25 02:14, Zwettler Markus (OIZ) wrote: Is it possible to configure "clientcert=disable" in pg_hba.conf or disable the client verification otherwise? The docs only mention "verify-ca" and "verify-full". "In addition to the method-specific options li

Re: could not accept ssl connection tlsv1 alert unknown ca

2025-02-03 Thread Adrian Klaver
On 2/3/25 02:14, Zwettler Markus (OIZ) wrote: bash-4.4$ cat pg_hba.conf # Do not edit this file manually! # It will be overwritten by Patroni! local all "postgres" peer hostssl replication "_crunchyrepl" all cert hostssl "postgres" "_crunchyrepl" all cert host all "_crunchyrepl" all reject host

Re: Re: could not accept ssl connection tlsv1 alert unknown ca

2025-02-03 Thread Zwettler Markus (OIZ)
> -Ursprüngliche Nachricht- > Von: Zwettler Markus (OIZ) > Gesendet: Montag, 3. Februar 2025 09:37 > An: Adrian Klaver ; Tom Lane > ; pgsql-general@lists.postgresql.org > Betreff: Re: Re: could not accept ssl connection tlsv1 alert unknown ca > > > -Ursprüngliche Nachricht- > > Vo

Re: Re: could not accept ssl connection tlsv1 alert unknown ca

2025-02-03 Thread Zwettler Markus (OIZ)
> -Ursprüngliche Nachricht- > Von: Adrian Klaver > Gesendet: Freitag, 31. Januar 2025 18:07 > An: Zwettler Markus (OIZ) ; Tom Lane > ; pgsql-general@lists.postgresql.org > Betreff: [Extern] Re: could not accept ssl connection tlsv1 alert unknown ca > > On 1/31/25 08:57, Zwettler Markus (O