View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000594Pgpool-IIBugpublic2020-03-06 17:182020-04-14 12:49
Reporterkanika.kamboj Assigned Topengbo  
PriorityurgentSeveritymajorReproducibilityunable to reproduce
Status feedbackResolutionopen 
OSLinuxOS Version7.7 
Product Version4.0.7 
Summary0000594: Problem on Connection Pooling
DescriptionI am trying connection Pooling on one server. PostgreSQL max_connections are 450. But still getting 64676 pgpool: wait for connection request(36 times). Can you please help to initially configure pg pool on PostgreSQL 9.6. I have attached pgpool.conf

Tagspgpool-II

Activities

kanika.kamboj

2020-03-06 17:18

reporter  

pgpool.conf (40,730 bytes)

kanika.kamboj

2020-03-06 17:27

reporter   ~0003253

Logs are also not being generated. Pg pool version 4.0.8

pengbo

2020-03-10 10:50

developer   ~0003255

> I am trying connection Pooling on one server. PostgreSQL max_connections are 450. But still getting 64676 pgpool: wait for connection request(36 times).

It is a normal feature.
"pgpool: wait for connection request" means that this pgpool child process can accept client connection and is waiting for client connection.
Pgpool-II forks the number of pgpool processes specified in "num_init_children" parameter initially at startup.

See:
https://www.pgpool.net/docs/latest/en/html/runtime-config-connection.html#GUC-NUM-INIT-CHILDREN


> Logs are also not being generated. Pg pool version 4.0.8

Are you using 4.0.7?
It was a bug that no syslog output. Please upgrade to Pgpool-II 4.0.8.

kanika.kamboj

2020-03-11 15:35

reporter   ~0003258

I am already using Pg pool 4.0.8 . But still logs are not generating.

When I use ps -ef | grep postgres.I have attached the output for the same. Please confirm pg pool is configured properly.

root 523 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 530 523 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 535 657 41 10:28 ? 00:01:09 postgres: postgres automation_tn_2g [local] DELETE
root 555 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 563 555 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 567 657 48 10:28 ? 00:01:19 postgres: postgres automation_tn_2g [local] DELETE
root 627 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 638 627 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 639 657 46 10:28 ? 00:01:17 postgres: postgres automation_tn_2g [local] DELETE
postgres 657 1 0 Feb25 ? 00:19:12 /opt/PostgreSQL/9.5/bin/postgres -D /PM_APPLICATION/pmautomation/PM/postgres-9.5-data
postgres 667 657 0 Feb25 ? 00:00:00 postgres: logger process
postgres 678 657 0 Feb25 ? 00:48:36 postgres: checkpointer process
postgres 679 657 0 Feb25 ? 00:01:39 postgres: writer process
postgres 680 657 0 Feb25 ? 00:25:01 postgres: wal writer process
postgres 681 657 0 Feb25 ? 00:37:01 postgres: autovacuum launcher process
postgres 682 657 0 Feb25 ? 00:41:32 postgres: stats collector process
root 696 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 705 696 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 708 657 46 10:28 ? 00:01:15 postgres: postgres airtel_automation_tn_2g [local] DELETE
root 1185 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 1195 1185 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 1202 657 46 10:28 ? 00:01:10 postgres: postgres automation_tn_2g [local] DELETE
root 1205 1 0 10:17 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 1215 1205 0 10:17 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 1223 657 38 10:17 ? 00:05:28 postgres: postgres automation_tn_2g [local] DELETE
root 1375 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 1383 1375 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 1388 657 40 10:28 ? 00:01:00 postgres: postgres automation_tn_2g [local] DELETE
postgres 1404 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
root 1525 1 0 10:29 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 1534 1525 0 10:29 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 1542 657 40 10:29 ? 00:00:57 postgres: postgres automation_tn_2g [local] DELETE
root 1708 1 0 10:29 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 1716 1708 0 10:29 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 1719 657 46 10:29 ? 00:01:03 postgres: postgres automation_tn_2g [local] DELETE
root 1908 1 0 10:29 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 1917 1908 0 10:29 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 1924 657 38 10:29 ? 00:00:50 postgres: postgres automation_tn_2g [local] DELETE
root 2000 1 0 10:29 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 2009 2000 0 10:29 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 2018 657 44 10:29 ? 00:00:56 postgres: postgres automation_tn_2g [local] DELETE
root 2119 1 0 10:29 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 2124 2119 0 10:29 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 2125 657 44 10:29 ? 00:00:55 postgres: postgres automation_tn_2g [local] DELETE
root 2455 1 0 10:29 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 2464 2455 0 10:29 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 2465 657 37 10:29 ? 00:00:42 postgres: postgres automation_tn_2g [local] DELETE
root 2577 1 0 10:29 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 2587 2577 0 10:29 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 2595 657 46 10:29 ? 00:00:50 postgres: postgres automation_tn_2g [local] DELETE
root 2671 1 0 10:29 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 2678 2671 0 10:29 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 2681 657 45 10:29 ? 00:00:48 postgres: postgres automation_tn_2g [local] DELETE
root 2772 1 0 10:29 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 2779 2772 0 10:29 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 2816 657 37 10:29 ? 00:00:38 postgres: postgres automation_tn_2g [local] DELETE
root 2941 1 0 10:29 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 2948 2941 0 10:29 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 2957 657 36 10:29 ? 00:00:36 postgres: postgres automation_tn_2g [local] DELETE
root 3100 1 0 10:29 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3107 3100 0 10:29 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3110 657 38 10:29 ? 00:00:36 postgres: postgres automation_tn_2g [local] DELETE
root 3236 1 0 10:29 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3242 3236 0 10:29 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3246 657 35 10:29 ? 00:00:33 postgres: postgres automation_tn_2g [local] DELETE
root 3374 1 0 10:29 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3380 3374 0 10:29 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3383 657 44 10:29 ? 00:00:39 postgres: postgres automation_tn_2g [local] DELETE
postgres 3575 657 0 10:30 ? 00:00:00 postgres: postgres dc 127.0.0.1(41826) idle
postgres 3576 657 7 10:30 ? 00:00:06 postgres: postgres dc 127.0.0.1(41827) INSERT
postgres 3582 657 3 10:30 ? 00:00:03 postgres: postgres dc 127.0.0.1(41828) idle
postgres 3583 657 3 10:30 ? 00:00:03 postgres: postgres dc 127.0.0.1(41829) idle
postgres 3585 657 0 10:30 ? 00:00:00 postgres: postgres dc 127.0.0.1(41830) idle
postgres 3586 657 0 10:30 ? 00:00:00 postgres: postgres dc 127.0.0.1(41831) idle
postgres 3587 657 1 10:30 ? 00:00:00 postgres: postgres dc 127.0.0.1(41832) idle
postgres 3590 657 0 10:30 ? 00:00:00 postgres: postgres dc 127.0.0.1(41833) idle
root 3600 1 0 10:30 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d db
root 3608 3600 0 10:30 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3615 657 35 10:30 ? 00:00:29 postgres: postgres automation_tn_2g [local] DELETE
root 3628 1 0 10:30 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3633 3628 0 10:30 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3638 657 46 10:30 ? 00:00:36 postgres: postgres automation_tn_2g [local] DELETE
root 3663 1 0 10:30 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3672 3663 0 10:30 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3679 657 39 10:30 ? 00:00:29 postgres: postgres automation_tn_2g [local] DELETE
root 3689 1 0 10:30 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3697 3689 0 10:30 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3705 657 45 10:30 ? 00:00:32 postgres: postgres automation_tn_2g [local] DELETE
root 3724 1 0 10:30 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3729 3724 0 10:30 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3733 657 37 10:30 ? 00:00:25 postgres: postgres automation_tn_2g [local] DELETE
root 3752 1 0 10:30 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3760 3752 0 10:30 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3767 657 40 10:30 ? 00:00:25 postgres: postgres airtel_automation_tn_2g [local] DELETE
root 3780 1 0 10:30 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3788 3780 0 10:30 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3798 657 35 10:30 ? 00:00:20 postgres: postgres automation_tn_2g [local] DELETE
root 3803 1 0 10:30 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3811 3803 0 10:30 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3818 657 37 10:30 ? 00:00:21 postgres: postgres automation_tn_2g [local] DELETE
root 3827 1 0 10:30 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3833 3827 0 10:30 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3836 657 35 10:30 ? 00:00:20 postgres: postgres automation_tn_2g [local] DELETE
root 3850 1 0 10:30 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3855 3850 0 10:30 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3857 657 32 10:30 ? 00:00:18 postgres: postgres automation_tn_2g [local] DELETE
root 3919 3884 0 10:30 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3925 3919 0 10:30 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3934 657 48 10:30 ? 00:00:20 postgres: postgres automation_tn_2g [local] DELETE
root 3948 3884 0 10:30 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3956 3948 0 10:30 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3957 657 44 10:30 ? 00:00:16 postgres: postgres automation_tn_2g [local] DELETE
root 3979 3884 0 10:30 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 3984 3979 0 10:30 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 3986 657 33 10:30 ? 00:00:10 postgres: postgres automation_tn_2g [local] DELETE
root 4088 3884 0 10:31 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 4096 4088 0 10:31 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 4103 657 47 10:31 ? 00:00:11 postgres: postgres automation_tn_2g [local] DELETE
root 4157 3884 0 10:31 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 4162 4157 0 10:31 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 4166 657 40 10:31 ? 00:00:07 postgres: postgres automation_tn_2g [local] DELETE
root 4188 3884 0 10:31 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 4194 4188 0 10:31 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 4203 657 31 10:31 ? 00:00:04 postgres: postgres automation_tn_2g [local] DELETE
root 4612 3884 0 10:31 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 4621 4612 0 10:31 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 4625 657 38 10:31 ? 00:00:04 postgres: postgres automation_tn_2g [local] DELETE
root 5607 3884 0 10:31 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 5615 5607 0 10:31 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 5619 657 24 10:31 ? 00:00:00 postgres: postgres automation_tn_2g [local] COPY
root 5658 30149 0 10:31 pts/3 00:00:00 grep postgres
root 7532 1 0 10:19 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 7539 7532 0 10:19 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 7542 657 50 10:19 ? 00:06:11 postgres: postgres automation_tn_2g [local] DELETE
root 12677 1 0 10:20 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 12682 12677 0 10:20 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 12686 657 39 10:20 ? 00:04:12 postgres: postgres automation_tn_2g [local] DELETE
postgres 13053 657 1 08:50 ? 00:01:27 postgres: postgres dc 127.0.0.1(41692) idle
postgres 13570 1 0 Mar05 ? 00:00:03 /usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf -n
postgres 13574 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13575 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13576 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13578 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13579 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13580 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13581 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13583 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13584 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13585 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13586 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13587 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13588 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13589 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13590 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13591 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13592 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13593 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13594 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13595 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13596 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13597 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13598 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13599 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13601 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13603 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13604 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13605 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13607 13570 0 Mar05 ? 00:00:00 pgpool: PCP: wait for connection request
postgres 13608 13570 0 Mar05 ? 00:00:00 pgpool: worker process
postgres 13609 13570 0 Mar05 ? 00:00:00 pgpool: health check process(0)
root 17174 1 0 10:22 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 17181 17174 0 10:22 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 17190 657 49 10:22 ? 00:04:23 postgres: postgres automation_tn_2g [local] DELETE
root 20643 1 0 10:24 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 20650 20643 0 10:24 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 20654 657 41 10:24 ? 00:02:56 postgres: postgres automation_tn_2g [local] DELETE
postgres 25145 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
root 25921 1 0 10:26 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 25928 25921 0 10:26 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 25929 657 48 10:26 ? 00:02:36 postgres: postgres automation_tn_2g [local] DELETE
postgres 28659 13570 0 Mar09 ? 00:00:00 pgpool: wait for connection request
root 29581 1 0 10:27 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 29588 29581 0 10:27 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 29594 657 39 10:27 ? 00:01:34 postgres: postgres automation_tn_2g [local] DELETE
root 30416 1 0 10:27 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 30423 30416 0 10:27 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 30426 657 41 10:27 ? 00:01:30 postgres: postgres automation_tn_2g [local] DELETE
root 30521 1 0 10:27 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 30527 30521 0 10:27 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 30532 657 49 10:27 ? 00:01:45 postgres: postgres automation_tn_2g [local] DELETE
root 30632 1 0 10:27 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 30642 30632 0 10:27 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 30643 657 40 10:27 ? 00:01:26 postgres: postgres automation_tn_2g [local] DELETE
root 30769 1 0 10:27 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 30777 30769 0 10:27 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 30780 657 46 10:27 ? 00:01:38 postgres: postgres automation_tn_2g [local] DELETE
root 30989 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 30995 30989 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 31000 657 39 10:28 ? 00:01:20 postgres: postgres automation_tn_2g [local] DELETE
root 31221 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 31228 31221 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 31232 657 48 10:28 ? 00:01:36 postgres: postgres automation_tn_2g [local] DELETE
root 31404 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 31411 31404 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 31416 657 39 10:28 ? 00:01:18 postgres: postgres airtel_automation_tn_2g [local] DELETE
root 31597 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 31607 31597 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 31608 657 47 10:28 ? 00:01:30 postgres: postgres automation_tn_2g [local] DELETE
root 31790 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 31800 31790 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 31802 657 47 10:28 ? 00:01:29 postgres: postgres automation_tn_2g [local] DELETE
postgres 31871 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
root 31997 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 32003 31997 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 32006 657 41 10:28 ? 00:01:16 postgres: postgres automation_tn_2g [local] DELETE
root 32207 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 32217 32207 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 32218 657 40 10:28 ? 00:01:12 postgres: postgres airtel_automation_tn_2g [local] DELETE
root 32333 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 32341 32333 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 32344 657 47 10:28 ? 00:01:23 postgres: postgres automation_tn_2g [local] DELETE
root 32543 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 32552 32543 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 32554 657 41 10:28 ? 00:01:10 postgres: postgres airtel_automation_tn_2g [local] DELETE
root 32680 1 0 10:28 pts/0 00:00:00 /bin/bash /opt/PostgreSQL/9.5/bin/psql -U postgres -d automation_tn_2g
root 32688 32680 0 10:28 pts/0 00:00:00 /opt/PostgreSQL/9.5/bin/psql.bin -U postgres -d automation_tn_2g
postgres 32698 657 41 10:28 ? 00:01:09 postgres: postgres automation_tn_2g [local] DELETE









Can you please help to check the connection pooling is configured and working properly.

pengbo

2020-03-12 10:53

developer   ~0003259

> I am already using Pg pool 4.0.8 . But still logs are not generating.
If you start pgpool using systemd, you can check the log by using the commad below:

    # journalctl -a | grep pgpool

If you want to redirect standard output and standard error to log file,
you need to redirect while starting pgpool.

   # pgpool -n -f /etc/pgpool-II/pgpool.conf > /var/log/pgpool.log 2>&1 &

Also you can use "syslog" to output logs.
See example:
https://www.pgpool.net/docs/latest/en/html/example-cluster.html#EXAMPLE-CLUSTER-PGPOOL-CONFIG-LOG

> Please confirm pg pool is configured properly.


-----------
postgres 13574 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13575 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13576 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
postgres 13578 13570 0 Mar05 ? 00:00:00 pgpool: wait for connection request
-----------

Yes. I think pgpool is started properly.

kanika.kamboj

2020-03-12 13:38

reporter   ~0003260

Can you please suggest some best ways to test effective connection pooling using pg pool ?

kanika.kamboj

2020-03-12 13:39

reporter   ~0003261

How can we test the pooling and connections are being distributed..??

pengbo

2020-03-16 12:11

developer   ~0003270

Connect to pgpool and exit, then check "pg_stat_activity" to see if the connection is cached.

(1) Connect to pgpool.

    $ psql -h 127.0.0.1 -U test1 test1 -p 9999

(2) Exit

    test1=> \q

(3) Connect to PostgreSQL and execute "select * from pg_stat_activity".
      If the connection to database test1 is displayed, it means the connection pooling works properly.

    $ psql -h 127.0.0.1 -U postgres postgres -p 9999
    postgres=# select * from pg_stat_activity where backend_type = 'client backend' and datname = 'test1';
    ...
   16396 | test1 | 5654 | 10 | test1 | psql | | | -1 | 202
0-03-11 10:30:26.283691+09 | | | 2020-03-11 10:30:26.285531+09 | Client | ClientRea
d | idle | | | | client backend
    (1 row)


You can also use "show pool_pools" command to check the pools status.

https://www.pgpool.net/docs/latest/en/html/sql-show-pool-pools.html

kanika.kamboj

2020-03-18 19:18

reporter   ~0003272

Still logs are not getting configured.

pengbo

2020-03-25 15:01

developer   ~0003282

How did you start pgpool?

kanika.kamboj

2020-04-06 15:37

reporter   ~0003304

systemctl start pgpool.service

pengbo

2020-04-07 10:14

developer   ~0003307

Did you set "log_destination = 'syslog'"?

Please follow this setting example to config log:
https://www.pgpool.net/docs/latest/en/html/example-cluster.html#EXAMPLE-CLUSTER-PGPOOL-CONFIG-LOG

Don't forget to restart rsyslog after editing rsyslog.conf.

# systemctl restart rsyslog

Issue History

Date Modified Username Field Change
2020-03-06 17:18 kanika.kamboj New Issue
2020-03-06 17:18 kanika.kamboj File Added: pgpool.conf
2020-03-06 17:18 kanika.kamboj Tag Attached: pgpool-II
2020-03-06 17:27 kanika.kamboj Note Added: 0003253
2020-03-10 10:40 pengbo Assigned To => pengbo
2020-03-10 10:40 pengbo Status new => assigned
2020-03-10 10:40 pengbo Description Updated
2020-03-10 10:50 pengbo Note Added: 0003255
2020-03-11 12:50 pengbo Status assigned => feedback
2020-03-11 15:35 kanika.kamboj Note Added: 0003258
2020-03-11 15:35 kanika.kamboj Status feedback => assigned
2020-03-12 10:53 pengbo Note Added: 0003259
2020-03-12 13:38 kanika.kamboj Note Added: 0003260
2020-03-12 13:39 kanika.kamboj Note Added: 0003261
2020-03-16 12:11 pengbo Note Added: 0003270
2020-03-18 19:18 kanika.kamboj Note Added: 0003272
2020-03-25 15:01 pengbo Note Added: 0003282
2020-04-06 15:37 kanika.kamboj Note Added: 0003304
2020-04-07 10:14 pengbo Note Added: 0003307
2020-04-14 12:49 pengbo Status assigned => feedback