View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000719 | Pgpool-II | Bug | public | 2021-06-17 23:05 | 2021-07-01 11:01 |
| Reporter | Yasser | Assigned To | |||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Platform | VM | OS | Ubuntu | OS Version | 20.04.2 |
| Product Version | 4.1.1 | ||||
| Summary | 0000719: pg_terminate_backend stop all backends when it is used over pgpool psql session | ||||
| Description | My goal is to restore database, I am working in postgres 12 (streaming master, slave) before triggering restore I terminate all the connection on that database with: SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'database_name' when there is connection to terminate, it terminate all the connection and stop all postgres nodes. if there is no connection to terminate, pgpool does not stop any postgres node | ||||
| Steps To Reproduce | - create databaes x - connect to it - trigger pg_terminate_backend over pgpool psql (all postgres nodes are down) | ||||
| Tags | No tags attached. | ||||
|
|
It's an expected behavior. https://www.pgpool.net/docs/41/en/html/restrictions.html You need to pass pid parameter as a constant to pg_terminate_backend(). |
|
|
May I close this issue? |
|
|
Thanks @t-ishii it works with constance @adminsitrator yes please |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-06-17 23:05 | Yasser | New Issue | |
| 2021-06-18 09:25 | t-ishii | Note Added: 0003879 | |
| 2021-06-30 11:07 | administrator | Status | new => feedback |
| 2021-06-30 11:07 | administrator | Note Added: 0003893 | |
| 2021-06-30 15:33 | Yasser | Note Added: 0003894 | |
| 2021-06-30 15:33 | Yasser | Status | feedback => new |
| 2021-07-01 11:01 | administrator | Status | new => closed |
