From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | Greg Sabino Mullane <htamfids(at)gmail(dot)com> |
Cc: | Sebastien Flaesch <sebastien(dot)flaesch(at)4js(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Tracing libpq client: Only with PQtrace()? |
Date: | 2024-04-09 15:01:22 |
Message-ID: | 202404091501.e4buwthhrd27@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2024-Apr-09, Greg Sabino Mullane wrote:
> On Tue, Apr 9, 2024 at 8:51 AM Sebastien Flaesch <sebastien(dot)flaesch(at)4js(dot)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
Another approach might be to use Wireshark, which has a decoder for the
Postgres FE/BE protocol.
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2024-04-09 15:09:02 | Re: [Code: 0, SQL State: 0A000] when "typing" from pg_catalog |
Previous Message | Thiemo Kellner | 2024-04-09 14:59:38 | [Code: 0, SQL State: 0A000] when "typing" from pg_catalog |