View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000808 | Pgpool-II | General | public | 2023-07-29 21:40 | 2023-08-26 15:44 |
| Reporter | velasquezjr23 | Assigned To | t-ishii | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 4.3.2 | ||||
| Summary | 0000808: I need to know which table PostgreSQL 12 stores the information from to generate the "show pool_nodes" report | ||||
| Description | Hello, I have installed pgpool_version 4.3 and PostgreSQL 12.15, please can you tell me which is the table where PostgreSQL 12 stores the information to generate the report with the command psql -h 192.168.20.348 -p 9999 -U pgpool postgres -c "show pool_nodes", regards | ||||
| Tags | No tags attached. | ||||
|
|
This is not the right place to ask questions regarding Pgpool-II. https://pgpool.net/mediawiki/index.php/Bug_tracking_system Please post your questions to the pgpool-general mailing instead. In the mean time, there's no such a table in PostgreSQL because the info is in the memory of pgpool process. If the reason that you are looking for such a table is you want to extract the info using SELECT, you may want to use pgpool_adm_pcp_node_info extension. https://www.pgpool.net/docs/43/en/html/pgpool-adm-pcp-node-info.html If you have further question, please post it to the mailing list. |
|
|
excellent, thank you very much, regards |
|
|
I am going to close this issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-07-29 21:40 | velasquezjr23 | New Issue | |
| 2023-07-30 13:43 | t-ishii | Assigned To | => t-ishii |
| 2023-07-30 13:43 | t-ishii | Status | new => assigned |
| 2023-07-30 13:51 | t-ishii | Note Added: 0004421 | |
| 2023-07-30 22:28 | velasquezjr23 | Note Added: 0004422 | |
| 2023-08-26 15:43 | t-ishii | Note Added: 0004424 | |
| 2023-08-26 15:44 | t-ishii | Status | assigned => closed |
