Re: client waits for end of update operation and server proc is idle

From: Matthias Apitz <guru(at)unixarea(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: client waits for end of update operation and server proc is idle
Date: 2021-04-26 06:04:55
Message-ID: YIZYBzsR4LRXdLXK@c720-r368166.fritz.box
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

El día lunes, abril 26, 2021 a las 07:38:40a. m. +0200, Matthias Apitz escribió:

> Having solved this issue, one last question: Is there any good way for a
> C-written or ESQL/C-written client to get the local port number or even
> the PID of the PostgreSQL server process on the other end of the
> connection for logging/tracing purpose?

Ah, I found it as

int PQbackendPID(const PGconn *conn);

One should read firt the fine documentatio befor asking stupid
questions: https://www.postgresql.org/docs/11/libpq-status.html

matthias

--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
¡Con Cuba no te metas! «» Don't mess with Cuba! «» Leg Dich nicht mit Kuba an!
http://www.cubadebate.cu/noticias/2020/12/25/en-video-con-cuba-no-te-metas/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2021-04-26 11:49:18 Invalid byte sequence when importing Oracle BLOB
Previous Message Matthias Apitz 2021-04-26 05:38:40 Re: client waits for end of update operation and server proc is idle