MIME-Version: 1.0
References: <AM9P191MB1286CDC331224EE55AE68DB8B0072@AM9P191MB1286.EURP191.PROD.OUTLOOK.COM>
In-Reply-To: <AM9P191MB1286CDC331224EE55AE68DB8B0072@AM9P191MB1286.EURP191.PROD.OUTLOOK.COM>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Tue, 9 Apr 2024 10:50:11 -0400
Message-ID: <CAKAnmmKxUOcVk_NWVtxhRd_ks-MHKKt4hHU0Z+WTAkBEoLjC7w@mail.gmail.com>
Subject: Re: Tracing libpq client: Only with PQtrace()?
To: Sebastien Flaesch <sebastien.flaesch@4js.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000038cf360615ab0c90"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmKxUOcVk_NWVtxhRd_ks-MHKKt4hHU0Z%2BWTAkBEoLjC7w%40mail.gmail.com>
Precedence: bulk

--00000000000038cf360615ab0c90
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Apr 9, 2024 at 8:51=E2=80=AFAM Sebastien Flaesch <sebastien.flaesch=
@4js.com>
wrote:

> Is the PQtrace() API the only way to enable libpq client tracing?
>
> I thought about some environment variable of client configuration
> setting...
>

That's generally the job of the client, or more specifically, the driver
providing the interface between your program and the libpq API. Unless you
are writing at the low level yourself, in which case, you would need to
have your program detect an env and call PQtrace() as needed.

See for example
https://metacpan.org/pod/DBD::Pg#parse_trace_flag-and-parse_trace_flags

Cheers,
Greg

--00000000000038cf360615ab0c90
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Apr 9, 2024 at 8:51=E2=80=AFAM Se=
bastien Flaesch &lt;<a href=3D"mailto:sebastien.flaesch@4js.com">sebastien.=
flaesch@4js.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px=
 solid rgb(204,204,204);padding-left:1ex"><div class=3D"msg-696214172392018=
2952">


<div dir=3D"ltr">
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)"><span style=3D"fo=
nt-size:12pt">Is the PQtrace() API the only way to enable libpq client trac=
ing?</span><br></div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
I thought about some environment variable of client configuration setting..=
.</div></div></div></blockquote><div><br></div><div>That&#39;s generally th=
e job of the client, or more specifically, the driver providing the interfa=
ce between your program and the libpq API. Unless you are writing at the lo=
w level yourself, in which case, you would need to have your program detect=
 an env and call PQtrace() as needed.=C2=A0</div><div><br></div><div>See fo=
r example=C2=A0<a href=3D"https://metacpan.org/pod/DBD::Pg#parse_trace_flag=
-and-parse_trace_flags">https://metacpan.org/pod/DBD::Pg#parse_trace_flag-a=
nd-parse_trace_flags</a>=C2=A0</div><div><br></div><div>Cheers,</div><div>G=
reg</div><div>=C2=A0</div></div></div>

--00000000000038cf360615ab0c90--