View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000647 | Pgpool-II | General | public | 2020-09-08 20:36 | 2020-10-30 02:56 |
| Reporter | jayakumar | Assigned To | hoshiai | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | feedback | Resolution | open | ||
| Platform | Redhat Linux 7.2 | OS | Redhat Linux 7.2 | OS Version | Redhat Linux 7.2 |
| Product Version | 3.7.10 | ||||
| Summary | 0000647: How to find application and system ip of the connection from pgpool | ||||
| Description | When I am checking connections with pg_stat_activity I am finding client address as pgpool server ip. I want to know the connection origin system ip and application name of the connection . How to get these details. | ||||
| Tags | No tags attached. | ||||
|
|
I think that "pcp_proc_info" can be used. pcp_proc_info can show postgres's pid and pgpool child pid, so pg_stat_activity information is connected with pcp_proc_info and pgpool pid. You can confirm client address, if you check pgpool logs(use %h with log_line_prefix) or pgpool process status(for example, execute "ps" command). And, this mantis use for bug report, so we use mailing list of pgpool-general for a question. |
|
|
"You can confirm client address, if you check pgpool logs(use %h with log_line_prefix)" I do not believe this is accurate. At least for version 4.1.4. According to the documentation at https://www.pgpool.net/docs/latest/en/html/runtime-config-logging.html there is no escape for %h. Thinking it was maybe an undocumented feature I tried it in my environment and it is indeed ignored. This would be a really nice feature to have because, trying to figure out who is actually connecting to pgPool is kind of a pain. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-09-08 20:36 | jayakumar | New Issue | |
| 2020-09-14 16:52 | hoshiai | Assigned To | => hoshiai |
| 2020-09-14 16:52 | hoshiai | Status | new => assigned |
| 2020-09-25 09:29 | hoshiai | Status | assigned => feedback |
| 2020-09-25 09:29 | hoshiai | Note Added: 0003572 | |
| 2020-10-30 02:56 | montemj | Note Added: 0003591 |
