psql:FATAL:thedatabasesystemisinrecoverymode问题定位的方法与解决

首先介绍一下背景，在测试deepgreen（greenplum升级版）时，pgbench并发数设置过多，导致数据库卡死了，在进行连接、重启、关闭时，都报同样的错误：psql: fatal: the database system is in recovery mode。于是尝试进行如下操作，解决了该问题，总体步骤：

1.尝试登陆数据库，报错；2.查看master上的postgres进程，发现有update等待，说明segment上仍然有操作未完成；3、4、5、6.查看4个segment节点的postgres进程，看到有很多pgbench操作idle in transaction，简单判断这些操作已经不工作了，但是仍在事务中，未做处理（idle）；7.通过strace跟踪一个进程，发现果然没有操作；8.把master和segment上的pgbench操作全部杀死；重启数据库，问题解决。具体操作如下：

1.[dwadmin@master ~]$ psql -d postgres
psql: fatal:  the database system is in recovery mode

2.[dwadmin@master ~]$ ps -ef | grep postgres
dwadmin   7133     1  0 17:27         00:00:01 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/master/hgdwseg-1 -p 15432 -b 1 -z 80 --silent-mode=true -i -m master -c -1 -x 0 -e
dwadmin   7134  7133  0 17:27         00:00:00 postgres: port 15432, master logger process
dwadmin   7237  7133  0 17:27         00:00:00 postgres: port 15432, dwadmin pgbench [local] con22 [local] cmd2 update waiting
dwadmin   7397  7133  0 17:27         00:00:00 postgres: port 15432, dwadmin pgbench [local] con102 [local] cmd2 update waiting
dwadmin   8099  7133  0 17:27         00:00:00 postgres: port 15432, dwadmin pgbench [local] con453 [local] cmd2 update waiting

3.[dwadmin@seg0 ~]$ ps -ef | grep postgres
dwadmin   2705  2655  0 21:46 pts/0    00:00:00 grep --color=auto postgres
dwadmin  22367     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg12 -p 25444 -b 14 -z 80 --silent-mode=true -i -m mirrorless -c 12
dwadmin  22368     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg13 -p 25445 -b 15 -z 80 --silent-mode=true -i -m mirrorless -c 13
dwadmin  22372     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg16 -p 25448 -b 18 -z 80 --silent-mode=true -i -m mirrorless -c 16
dwadmin  22375     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg17 -p 25449 -b 19 -z 80 --silent-mode=true -i -m mirrorless -c 17
dwadmin  22376     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg11 -p 25443 -b 13 -z 80 --silent-mode=true -i -m mirrorless -c 11
dwadmin  22377     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg15 -p 25447 -b 17 -z 80 --silent-mode=true -i -m mirrorless -c 15
dwadmin  22378     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg2 -p 25434 -b 4 -z 80 --silent-mode=true -i -m mirrorless -c 2
dwadmin  22379     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg14 -p 25446 -b 16 -z 80 --silent-mode=true -i -m mirrorless -c 14
dwadmin  22380     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg19 -p 25451 -b 21 -z 80 --silent-mode=true -i -m mirrorless -c 19
dwadmin  22382     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg0 -p 25432 -b 2 -z 80 --silent-mode=true -i -m mirrorless -c 0
dwadmin  22384     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg10 -p 25442 -b 12 -z 80 --silent-mode=true -i -m mirrorless -c 10
dwadmin  22385     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg9 -p 25441 -b 11 -z 80 --silent-mode=true -i -m mirrorless -c 9
dwadmin  22388     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg8 -p 25440 -b 10 -z 80 --silent-mode=true -i -m mirrorless -c 8
dwadmin  22389     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg1 -p 25433 -b 3 -z 80 --silent-mode=true -i -m mirrorless -c 1
dwadmin  22390     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg3 -p 25435 -b 5 -z 80 --silent-mode=true -i -m mirrorless -c 3
dwadmin  22391     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg18 -p 25450 -b 20 -z 80 --silent-mode=true -i -m mirrorless -c 18
dwadmin  22392     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg7 -p 25439 -b 9 -z 80 --silent-mode=true -i -m mirrorless -c 7
dwadmin  22393     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg6 -p 25438 -b 8 -z 80 --silent-mode=true -i -m mirrorless -c 6
dwadmin  22394     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg5 -p 25437 -b 7 -z 80 --silent-mode=true -i -m mirrorless -c 5
dwadmin  22395     1  0 17:27         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg4 -p 25436 -b 6 -z 80 --silent-mode=true -i -m mirrorless -c 4
dwadmin  22396 22380  0 17:27         00:00:00 postgres: port 25451, logger process
dwadmin  22399 22367  0 17:27         00:00:00 postgres: port 25444, logger process
dwadmin  22402 22372  0 17:27         00:00:00 postgres: port 25448, logger process
dwadmin  22405 22368  0 17:27         00:00:00 postgres: port 25445, logger process
dwadmin  22410 22382  0 17:27         00:00:00 postgres: port 25432, logger process
dwadmin  22413 22376  0 17:27         00:00:00 postgres: port 25443, logger process
dwadmin  22416 22378  0 17:27         00:00:00 postgres: port 25434, logger process
dwadmin  22419 22380  0 17:27         00:00:00 postgres: port 25451, stats collector process
dwadmin  22420 22380  0 17:27         00:00:02 postgres: port 25451, writer process
dwadmin  22421 22380  0 17:27         00:00:00 postgres: port 25451, checkpoint process
dwadmin  22422 22380  0 17:27         00:00:00 postgres: port 25451, sweeper process
dwadmin  22423 22379  0 17:27         00:00:00 postgres: port 25446, logger process
dwadmin  22427 22372  0 17:27         00:00:00 postgres: port 25448, stats collector process
dwadmin  22428 22372  0 17:27         00:00:02 postgres: port 25448, writer process
dwadmin  22429 22372  0 17:27         00:00:00 postgres: port 25448, checkpoint process
dwadmin  22430 22372  0 17:27         00:00:00 postgres: port 25448, sweeper process
dwadmin  22433 22388  0 17:27         00:00:00 postgres: port 25440, logger process
dwadmin  22438 22393  0 17:27         00:00:00 postgres: port 25438, logger process
dwadmin  22441 22377  0 17:27         00:00:00 postgres: port 25447, logger process
dwadmin  22444 22382  0 17:27         00:00:00 postgres: port 25432, stats collector process
dwadmin  22445 22382  0 17:27         00:00:02 postgres: port 25432, writer process
dwadmin  22446 22382  0 17:27         00:00:00 postgres: port 25432, checkpoint process
dwadmin  22447 22382  0 17:27         00:00:00 postgres: port 25432, sweeper process
dwadmin  22448 22391  0 17:27         00:00:00 postgres: port 25450, logger process
dwadmin  22451 22389  0 17:27         00:00:00 postgres: port 25433, logger process
dwadmin  22454 22384  0 17:27         00:00:00 postgres: port 25442, logger process
dwadmin  22457 22395  0 17:27         00:00:00 postgres: port 25436, logger process
dwadmin  22460 22368  0 17:27         00:00:00 postgres: port 25445, stats collector process
dwadmin  22461 22368  0 17:27         00:00:02 postgres: port 25445, writer process
dwadmin  22462 22368  0 17:27         00:00:00 postgres: port 25445, checkpoint process
dwadmin  22464 22368  0 17:27         00:00:00 postgres: port 25445, sweeper process
dwadmin  22465 22385  0 17:27         00:00:00 postgres: port 25441, logger process
dwadmin  22468 22367  0 17:27         00:00:00 postgres: port 25444, stats collector process
dwadmin  22469 22367  0 17:27         00:00:02 postgres: port 25444, writer process
dwadmin  22470 22367  0 17:27         00:00:00 postgres: port 25444, checkpoint process
dwadmin  22471 22367  0 17:27         00:00:00 postgres: port 25444, sweeper process
dwadmin  22472 22392  0 17:27         00:00:00 postgres: port 25439, logger process
dwadmin  22475 22379  0 17:27         00:00:00 postgres: port 25446, stats collector process
dwadmin  22476 22379  0 17:27         00:00:02 postgres: port 25446, writer process
dwadmin  22477 22379  0 17:27         00:00:00 postgres: port 25446, checkpoint process
dwadmin  22478 22379  0 17:27         00:00:00 postgres: port 25446, sweeper process
dwadmin  22479 22390  0 17:27         00:00:00 postgres: port 25435, logger process
dwadmin  22481 22378  0 17:27         00:00:00 postgres: port 25434, stats collector process
dwadmin  22483 22378  0 17:27         00:00:02 postgres: port 25434, writer process
dwadmin  22484 22378  0 17:27         00:00:00 postgres: port 25434, checkpoint process
dwadmin  22485 22378  0 17:27         00:00:00 postgres: port 25434, sweeper process
dwadmin  22486 22375  0 17:27         00:00:00 postgres: port 25449, logger process
dwadmin  22492 22394  0 17:27         00:00:00 postgres: port 25437, logger process
dwadmin  22499 22388  0 17:27         00:00:00 postgres: port 25440, stats collector process
dwadmin  22500 22393  0 17:27         00:00:00 postgres: port 25438, stats collector process
dwadmin  22501 22393  0 17:27         00:00:02 postgres: port 25438, writer process
dwadmin  22502 22388  0 17:27         00:00:02 postgres: port 25440, writer process
dwadmin  22503 22393  0 17:27         00:00:00 postgres: port 25438, checkpoint process
dwadmin  22504 22388  0 17:27         00:00:00 postgres: port 25440, checkpoint process
dwadmin  22505 22388  0 17:27         00:00:00 postgres: port 25440, sweeper process
dwadmin  22506 22393  0 17:27         00:00:00 postgres: port 25438, sweeper process
dwadmin  22508 22377  0 17:27         00:00:00 postgres: port 25447, stats collector process
dwadmin  22509 22377  0 17:27         00:00:02 postgres: port 25447, writer process
dwadmin  22510 22377  0 17:27         00:00:00 postgres: port 25447, checkpoint process
dwadmin  22511 22377  0 17:27         00:00:00 postgres: port 25447, sweeper process
dwadmin  22515 22376  0 17:27         00:00:00 postgres: port 25443, stats collector process
dwadmin  22516 22376  0 17:27         00:00:02 postgres: port 25443, writer process
dwadmin  22517 22376  0 17:27         00:00:00 postgres: port 25443, checkpoint process
dwadmin  22518 22376  0 17:27         00:00:00 postgres: port 25443, sweeper process
dwadmin  22519 22392  0 17:27         00:00:00 postgres: port 25439, stats collector process
dwadmin  22520 22392  0 17:27         00:00:02 postgres: port 25439, writer process
dwadmin  22521 22392  0 17:27         00:00:00 postgres: port 25439, checkpoint process
dwadmin  22522 22392  0 17:27         00:00:00 postgres: port 25439, sweeper process
dwadmin  22523 22395  0 17:27         00:00:00 postgres: port 25436, stats collector process
dwadmin  22524 22395  0 17:27         00:00:02 postgres: port 25436, writer process
dwadmin  22525 22395  0 17:27         00:00:00 postgres: port 25436, checkpoint process
dwadmin  22526 22395  0 17:27         00:00:00 postgres: port 25436, sweeper process
dwadmin  22528 22391  0 17:27         00:00:00 postgres: port 25450, stats collector process
dwadmin  22529 22391  0 17:27         00:00:02 postgres: port 25450, writer process
dwadmin  22530 22391  0 17:27         00:00:00 postgres: port 25450, checkpoint process
dwadmin  22531 22391  0 17:27         00:00:00 postgres: port 25450, sweeper process
dwadmin  22532 22389  0 17:27         00:00:00 postgres: port 25433, stats collector process
dwadmin  22533 22389  0 17:27         00:00:02 postgres: port 25433, writer process
dwadmin  22534 22389  0 17:27         00:00:00 postgres: port 25433, checkpoint process
dwadmin  22535 22389  0 17:27         00:00:00 postgres: port 25433, sweeper process
dwadmin  22536 22385  0 17:27         00:00:00 postgres: port 25441, stats collector process
dwadmin  22537 22385  0 17:27         00:00:02 postgres: port 25441, writer process
dwadmin  22538 22385  0 17:27         00:00:00 postgres: port 25441, checkpoint process
dwadmin  22539 22385  0 17:27         00:00:00 postgres: port 25441, sweeper process
dwadmin  22540 22394  0 17:27         00:00:00 postgres: port 25437, stats collector process
dwadmin  22541 22394  0 17:27         00:00:02 postgres: port 25437, writer process
dwadmin  22542 22384  0 17:27         00:00:00 postgres: port 25442, stats collector process
dwadmin  22543 22394  0 17:27         00:00:00 postgres: port 25437, checkpoint process
dwadmin  22544 22384  0 17:27         00:00:02 postgres: port 25442, writer process
dwadmin  22545 22394  0 17:27         00:00:00 postgres: port 25437, sweeper process
dwadmin  22546 22384  0 17:27         00:00:00 postgres: port 25442, checkpoint process
dwadmin  22547 22384  0 17:27         00:00:00 postgres: port 25442, sweeper process
dwadmin  22548 22375  0 17:27         00:00:00 postgres: port 25449, stats collector process
dwadmin  22549 22375  0 17:27         00:00:02 postgres: port 25449, writer process
dwadmin  22550 22375  0 17:27         00:00:00 postgres: port 25449, checkpoint process
dwadmin  22551 22375  0 17:27         00:00:00 postgres: port 25449, sweeper process
dwadmin  22553 22390  0 17:27         00:00:00 postgres: port 25435, stats collector process
dwadmin  22554 22390  0 17:27         00:00:02 postgres: port 25435, writer process
dwadmin  22555 22390  0 17:27         00:00:00 postgres: port 25435, checkpoint process
dwadmin  22556 22390  0 17:27         00:00:00 postgres: port 25435, sweeper process
dwadmin  33253 22382  0 17:27         00:00:00 postgres: port 25432, dwadmin pgbench 192.168.20.1(29352) con102 seg0 idle in transaction
dwadmin  33270 22382  0 17:27         00:00:00 postgres: port 25432, dwadmin pgbench 192.168.20.1(29342) con22 seg0 idle in transaction
dwadmin  33376 22382  0 17:27         00:00:00 postgres: port 25432, dwadmin pgbench 192.168.20.1(29642) con453 seg0 idle in transaction
dwadmin  33386 22389  0 17:27         00:00:00 postgres: port 25433, dwadmin pgbench 192.168.20.1(62539) con102 seg1 idle in transaction
dwadmin  33433 22389  0 17:27         00:00:00 postgres: port 25433, dwadmin pgbench 192.168.20.1(62673) con22 seg1 idle in transaction
dwadmin  33608 22378  0 17:27         00:00:00 postgres: port 25434, dwadmin pgbench 192.168.20.1(60596) con22 seg2 idle in transaction
dwadmin  33632 22378  0 17:27         00:00:00 postgres: port 25434, dwadmin pgbench 192.168.20.1(60672) con102 seg2 idle in transaction
dwadmin  33668 22390  0 17:27         00:00:00 postgres: port 25435, dwadmin pgbench 192.168.20.1(49385) con22 seg3 idle in transaction
dwadmin  33713 22390  0 17:27         00:00:00 postgres: port 25435, dwadmin pgbench 192.168.20.1(49519) con102 seg3 idle in transaction
dwadmin  33795 22395  0 17:27         00:00:00 postgres: port 25436, dwadmin pgbench 192.168.20.1(4111) con22 seg4 idle in transaction
dwadmin  33810 22389  0 17:27         00:00:00 postgres: port 25433, dwadmin pgbench 192.168.20.1(63693) con453 seg1 idle in transaction
dwadmin  33828 22395  0 17:27         00:00:00 postgres: port 25436, dwadmin pgbench 192.168.20.1(4277) con102 seg4 idle in transaction
dwadmin  33904 22378  0 17:27         00:00:00 postgres: port 25434, dwadmin pgbench 192.168.20.1(61424) con453 seg2 idle in transaction
dwadmin  33942 22394  0 17:27         00:00:00 postgres: port 25437, dwadmin pgbench 192.168.20.1(27227) con102 seg5 idle in transaction
dwadmin  34017 22390  0 17:27         00:00:00 postgres: port 25435, dwadmin pgbench 192.168.20.1(50323) con453 seg3 idle in transaction
dwadmin  34092 22393  0 17:27         00:00:00 postgres: port 25438, dwadmin pgbench 192.168.20.1(8413) con102 seg6 idle in transaction
dwadmin  34108 22395  0 17:27         00:00:00 postgres: port 25436, dwadmin pgbench 192.168.20.1(4961) con453 seg4 idle in transaction
dwadmin  34142 22394  0 17:27         00:00:00 postgres: port 25437, dwadmin pgbench 192.168.20.1(27751) con22 seg5 idle in transaction
dwadmin  34187 22392  0 17:27         00:00:00 postgres: port 25439, dwadmin pgbench 192.168.20.1(46833) con102 seg7 idle in transaction
dwadmin  34216 22394  0 17:27         00:00:00 postgres: port 25437, dwadmin pgbench 192.168.20.1(27979) con453 seg5 idle in transaction
dwadmin  34229 22393  0 17:27         00:00:00 postgres: port 25438, dwadmin pgbench 192.168.20.1(8965) con22 seg6 idle in transaction
dwadmin  34307 22393  0 17:27         00:00:00 postgres: port 25438, dwadmin pgbench 192.168.20.1(9123) con453 seg6 idle in transaction
dwadmin  34318 22392  0 17:27         00:00:00 postgres: port 25439, dwadmin pgbench 192.168.20.1(47225) con22 seg7 idle in transaction
dwadmin  34400 22388  0 17:27         00:00:00 postgres: port 25440, dwadmin pgbench 192.168.20.1(46296) con102 seg8 idle in transaction
dwadmin  34516 22392  0 17:27         00:00:00 postgres: port 25439, dwadmin pgbench 192.168.20.1(47753) con453 seg7 idle in transaction
dwadmin  34577 22388  0 17:27         00:00:00 postgres: port 25440, dwadmin pgbench 192.168.20.1(46762) con22 seg8 idle in transaction
dwadmin  34589 22388  0 17:27         00:00:00 postgres: port 25440, dwadmin pgbench 192.168.20.1(46854) con453 seg8 idle in transaction
dwadmin  34651 22385  0 17:27         00:00:00 postgres: port 25441, dwadmin pgbench 192.168.20.1(58821) con102 seg9 idle in transaction
dwadmin  34672 22385  0 17:27         00:00:00 postgres: port 25441, dwadmin pgbench 192.168.20.1(58947) con453 seg9 idle in transaction
dwadmin  34802 22384  0 17:27         00:00:00 postgres: port 25442, dwadmin pgbench 192.168.20.1(47646) con453 seg10 idle in transaction
dwadmin  34806 22385  0 17:27         00:00:00 postgres: port 25441, dwadmin pgbench 192.168.20.1(59249) con22 seg9 idle in transaction
dwadmin  34903 22384  0 17:27         00:00:00 postgres: port 25442, dwadmin pgbench 192.168.20.1(48046) con102 seg10 idle in transaction
dwadmin  34918 22384  0 17:27         00:00:00 postgres: port 25442, dwadmin pgbench 192.168.20.1(48092) con22 seg10 idle in transaction
dwadmin  34935 22376  0 17:27         00:00:00 postgres: port 25443, dwadmin pgbench 192.168.20.1(63956) con453 seg11 idle in transaction
dwadmin  35059 22367  0 17:27         00:00:00 postgres: port 25444, dwadmin pgbench 192.168.20.1(16876) con453 seg12 idle in transaction
dwadmin  35096 22376  0 17:27         00:00:00 postgres: port 25443, dwadmin pgbench 192.168.20.1(64468) con102 seg11 idle in transaction
dwadmin  35176 22376  0 17:27         00:00:00 postgres: port 25443, dwadmin pgbench 192.168.20.1(64692) con22 seg11 idle in transaction
dwadmin  35317 22367  0 17:27         00:00:00 postgres: port 25444, dwadmin pgbench 192.168.20.1(17650) con102 seg12 idle in transaction
dwadmin  35328 22368  0 17:27         00:00:00 postgres: port 25445, dwadmin pgbench 192.168.20.1(6182) con453 seg13 idle in transaction
dwadmin  35408 22379  0 17:27         00:00:00 postgres: port 25446, dwadmin pgbench 192.168.20.1(54644) con453 seg14 idle in transaction
dwadmin  35431 22368  0 17:27         00:00:00 postgres: port 25445, dwadmin pgbench 192.168.20.1(6468) con102 seg13 idle in transaction
dwadmin  35591 22377  0 17:27         00:00:00 postgres: port 25447, dwadmin pgbench 192.168.20.1(12573) con453 seg15 idle in transaction
dwadmin  35673 22379  0 17:27         00:00:00 postgres: port 25446, dwadmin pgbench 192.168.20.1(55476) con102 seg14 idle in transaction
dwadmin  35725 22367  0 17:27         00:00:00 postgres: port 25444, dwadmin pgbench 192.168.20.1(18680) con22 seg12 idle in transaction
dwadmin  35791 22372  0 17:27         00:00:00 postgres: port 25448, dwadmin pgbench 192.168.20.1(50110) con453 seg16 idle in transaction
dwadmin  35796 22377  0 17:27         00:00:00 postgres: port 25447, dwadmin pgbench 192.168.20.1(13209) con102 seg15 idle in transaction
dwadmin  35833 22368  0 17:27         00:00:00 postgres: port 25445, dwadmin pgbench 192.168.20.1(7746) con22 seg13 idle in transaction
dwadmin  35874 22372  0 17:27         00:00:00 postgres: port 25448, dwadmin pgbench 192.168.20.1(50378) con102 seg16 idle in transaction
dwadmin  35968 22379  0 17:27         00:00:00 postgres: port 25446, dwadmin pgbench 192.168.20.1(56292) con22 seg14 idle in transaction
dwadmin  36005 22375  0 17:27         00:00:00 postgres: port 25449, dwadmin pgbench 192.168.20.1(6159) con102 seg17 idle in transaction
dwadmin  36014 22375  0 17:27         00:00:00 postgres: port 25449, dwadmin pgbench 192.168.20.1(6225) con453 seg17 idle in transaction
dwadmin  36081 22377  0 17:27         00:00:00 postgres: port 25447, dwadmin pgbench 192.168.20.1(14129) con22 seg15 idle in transaction
dwadmin  36112 22391  0 17:27         00:00:00 postgres: port 25450, dwadmin pgbench 192.168.20.1(62584) con102 seg18 idle in transaction
dwadmin  36126 22391  0 17:27         00:00:00 postgres: port 25450, dwadmin pgbench 192.168.20.1(62638) con453 seg18 idle in transaction
dwadmin  36166 22372  0 17:27         00:00:00 postgres: port 25448, dwadmin pgbench 192.168.20.1(51378) con22 seg16 idle in transaction
dwadmin  36235 22380  0 17:27         00:00:00 postgres: port 25451, dwadmin pgbench 192.168.20.1(17294) con453 seg19 idle in transaction
dwadmin  36270 22380  0 17:27         00:00:00 postgres: port 25451, dwadmin pgbench 192.168.20.1(17484) con102 seg19 idle in transaction
dwadmin  36288 22375  0 17:27         00:00:00 postgres: port 25449, dwadmin pgbench 192.168.20.1(7129) con22 seg17 idle in transaction
dwadmin  36426 22391  0 17:27         00:00:00 postgres: port 25450, dwadmin pgbench 192.168.20.1(63604) con22 seg18 idle in transaction
dwadmin  36547 22380  0 17:27         00:00:00 postgres: port 25451, dwadmin pgbench 192.168.20.1(18300) con22 seg19 idle in transaction
[dwadmin@seg0 ~]$

4.[dwadmin@seg1 ~]$ ps -ef | grep postgres
dwadmin   4928 33823  0 17:25         00:00:00 postgres: port 25432, dwadmin pgbench 192.168.20.1(40345) con453 seg20 idle in transaction
dwadmin   4946 33823  0 17:25         00:00:00 postgres: port 25432, dwadmin pgbench 192.168.20.1(40513) con102 seg20 idle in transaction
dwadmin   4981 33816  0 17:25         00:00:00 postgres: port 25433, dwadmin pgbench 192.168.20.1(34463) con453 seg21 idle in transaction
dwadmin   4998 33816  0 17:25         00:00:00 postgres: port 25433, dwadmin pgbench 192.168.20.1(34536) con102 seg21 idle in transaction
dwadmin   5027 33814  0 17:25         00:00:00 postgres: port 25434, dwadmin pgbench 192.168.20.1(24977) con453 seg22 idle in transaction
dwadmin   5037 33814  0 17:25         00:00:00 postgres: port 25434, dwadmin pgbench 192.168.20.1(25051) con102 seg22 idle in transaction
dwadmin   5069 33819  0 17:25         00:00:00 postgres: port 25435, dwadmin pgbench 192.168.20.1(39746) con453 seg23 idle in transaction
dwadmin   5079 33819  0 17:25         00:00:00 postgres: port 25435, dwadmin pgbench 192.168.20.1(39820) con102 seg23 idle in transaction
dwadmin   5115 33818  0 17:25         00:00:00 postgres: port 25436, dwadmin pgbench 192.168.20.1(11056) con453 seg24 idle in transaction
dwadmin   5127 33818  0 17:25         00:00:00 postgres: port 25436, dwadmin pgbench 192.168.20.1(11138) con102 seg24 idle in transaction
dwadmin   5156 33821  0 17:25         00:00:00 postgres: port 25437, dwadmin pgbench 192.168.20.1(31611) con453 seg25 idle in transaction
dwadmin   5186 33823  0 17:25         00:00:00 postgres: port 25432, dwadmin pgbench 192.168.20.1(41535) con22 seg20 idle in transaction
dwadmin   5187 33821  0 17:25         00:00:00 postgres: port 25437, dwadmin pgbench 192.168.20.1(31699) con102 seg25 idle in transaction
dwadmin   5193 33812  0 17:25         00:00:00 postgres: port 25438, dwadmin pgbench 192.168.20.1(24658) con453 seg26 idle in transaction
dwadmin   5227 33812  0 17:25         00:00:00 postgres: port 25438, dwadmin pgbench 192.168.20.1(24800) con102 seg26 idle in transaction
dwadmin   5230 33816  0 17:25         00:00:00 postgres: port 25433, dwadmin pgbench 192.168.20.1(35556) con22 seg21 idle in transaction
dwadmin   5261 33817  0 17:25         00:00:00 postgres: port 25439, dwadmin pgbench 192.168.20.1(58676) con453 seg27 idle in transaction
dwadmin   5268 33817  0 17:25         00:00:00 postgres: port 25439, dwadmin pgbench 192.168.20.1(58784) con102 seg27 idle in transaction
dwadmin   5269 33814  0 17:25         00:00:00 postgres: port 25434, dwadmin pgbench 192.168.20.1(26065) con22 seg22 idle in transaction
dwadmin   5314 33822  0 17:25         00:00:00 postgres: port 25440, dwadmin pgbench 192.168.20.1(35888) con453 seg28 idle in transaction
dwadmin   5325 33822  0 17:25         00:00:00 postgres: port 25440, dwadmin pgbench 192.168.20.1(35920) con102 seg28 idle in transaction
dwadmin   5342 33819  0 17:25         00:00:00 postgres: port 25435, dwadmin pgbench 192.168.20.1(40850) con22 seg23 idle in transaction
dwadmin   5356 33811  0 17:25         00:00:00 postgres: port 25441, dwadmin pgbench 192.168.20.1(4679) con453 seg29 idle in transaction
dwadmin   5367 33811  0 17:25         00:00:00 postgres: port 25441, dwadmin pgbench 192.168.20.1(4723) con102 seg29 idle in transaction
dwadmin   5381 33818  0 17:25         00:00:00 postgres: port 25436, dwadmin pgbench 192.168.20.1(12216) con22 seg24 idle in transaction
dwadmin   5393 33803  0 17:25         00:00:00 postgres: port 25442, dwadmin pgbench 192.168.20.1(51702) con453 seg30 idle in transaction
dwadmin   5411 33803  0 17:25         00:00:00 postgres: port 25442, dwadmin pgbench 192.168.20.1(51756) con102 seg30 idle in transaction
dwadmin   5428 33821  0 17:25         00:00:00 postgres: port 25437, dwadmin pgbench 192.168.20.1(32767) con22 seg25 idle in transaction
dwadmin   5442 33807  0 17:25         00:00:00 postgres: port 25443, dwadmin pgbench 192.168.20.1(35747) con453 seg31 idle in transaction
dwadmin   5461 33807  0 17:25         00:00:00 postgres: port 25443, dwadmin pgbench 192.168.20.1(35813) con102 seg31 idle in transaction
dwadmin   5486 33812  0 17:25         00:00:00 postgres: port 25438, dwadmin pgbench 192.168.20.1(25854) con22 seg26 idle in transaction
dwadmin   5501 33815  0 17:25         00:00:00 postgres: port 25444, dwadmin pgbench 192.168.20.1(52130) con453 seg32 idle in transaction
dwadmin   5505 33815  0 17:25         00:00:00 postgres: port 25444, dwadmin pgbench 192.168.20.1(52172) con102 seg32 idle in transaction
dwadmin   5536 33817  0 17:25         00:00:00 postgres: port 25439, dwadmin pgbench 192.168.20.1(59908) con22 seg27 idle in transaction
dwadmin   5565 33796  0 17:25         00:00:00 postgres: port 25445, dwadmin pgbench 192.168.20.1(49259) con453 seg33 idle in transaction
dwadmin   5582 33796  0 17:25         00:00:00 postgres: port 25445, dwadmin pgbench 192.168.20.1(49311) con102 seg33 idle in transaction
dwadmin   5596 33822  0 17:25         00:00:00 postgres: port 25440, dwadmin pgbench 192.168.20.1(37048) con22 seg28 idle in transaction
dwadmin   5668 33799  0 17:25         00:00:00 postgres: port 25447, dwadmin pgbench 192.168.20.1(49369) con453 seg35 idle in transaction
dwadmin   5684 33811  0 17:25         00:00:00 postgres: port 25441, dwadmin pgbench 192.168.20.1(5925) con22 seg29 idle in transaction
dwadmin   5686 33799  0 17:25         00:00:00 postgres: port 25447, dwadmin pgbench 192.168.20.1(49435) con102 seg35 idle in transaction
dwadmin   5734 33801  0 17:25         00:00:00 postgres: port 25448, dwadmin pgbench 192.168.20.1(4486) con453 seg36 idle in transaction
dwadmin   5739 33803  0 17:25         00:00:00 postgres: port 25442, dwadmin pgbench 192.168.20.1(53116) con22 seg30 idle in transaction
dwadmin   5743 33801  0 17:25         00:00:00 postgres: port 25448, dwadmin pgbench 192.168.20.1(4534) con102 seg36 idle in transaction
dwadmin   5777 33805  0 17:25         00:00:00 postgres: port 25449, dwadmin pgbench 192.168.20.1(30499) con453 seg37 idle in transaction
dwadmin   5789 33807  0 17:25         00:00:00 postgres: port 25443, dwadmin pgbench 192.168.20.1(37185) con22 seg31 idle in transaction
dwadmin   5790 33805  0 17:25         00:00:00 postgres: port 25449, dwadmin pgbench 192.168.20.1(30547) con102 seg37 idle in transaction
dwadmin   5819 33808  0 17:25         00:00:00 postgres: port 25450, dwadmin pgbench 192.168.20.1(54335) con453 seg38 idle in transaction
dwadmin   5836 33815  0 17:25         00:00:00 postgres: port 25444, dwadmin pgbench 192.168.20.1(53536) con22 seg32 idle in transaction
dwadmin   5849 33808  0 17:25         00:00:00 postgres: port 25450, dwadmin pgbench 192.168.20.1(54471) con102 seg38 idle in transaction
dwadmin   5884 33796  0 17:25         00:00:00 postgres: port 25445, dwadmin pgbench 192.168.20.1(50643) con22 seg33 idle in transaction
dwadmin   6010 33799  0 17:25         00:00:00 postgres: port 25447, dwadmin pgbench 192.168.20.1(50873) con22 seg35 idle in transaction
dwadmin   6093 33801  0 17:25         00:00:00 postgres: port 25448, dwadmin pgbench 192.168.20.1(6068) con22 seg36 idle in transaction
dwadmin   6155 33805  0 17:25         00:00:00 postgres: port 25449, dwadmin pgbench 192.168.20.1(32055) con22 seg37 idle in transaction
dwadmin   6202 33808  0 17:25         00:00:00 postgres: port 25450, dwadmin pgbench 192.168.20.1(55939) con22 seg38 idle in transaction
dwadmin  11893 33809  0 17:25         00:00:00 postgres: port 25451, stats collector process
dwadmin  11894 33809  0 17:25         00:00:02 postgres: port 25451, writer process
dwadmin  11895 33809  0 17:25         00:00:00 postgres: port 25451, checkpoint process
dwadmin  11896 33809  0 17:25         00:00:00 postgres: port 25451, sweeper process
dwadmin  11907 33820  0 17:25         00:00:00 postgres: port 25446, stats collector process
dwadmin  11908 33820  0 17:25         00:00:02 postgres: port 25446, writer process
dwadmin  11909 33820  0 17:25         00:00:00 postgres: port 25446, checkpoint process
dwadmin  11910 33820  0 17:25         00:00:00 postgres: port 25446, sweeper process
dwadmin  14621 14570  0 21:46 pts/0    00:00:00 grep --color=auto postgres
dwadmin  33796     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg33 -p 25445 -b 35 -z 80 --silent-mode=true -i -m mirrorless -c 33
dwadmin  33799     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg35 -p 25447 -b 37 -z 80 --silent-mode=true -i -m mirrorless -c 35
dwadmin  33801     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg36 -p 25448 -b 38 -z 80 --silent-mode=true -i -m mirrorless -c 36
dwadmin  33803     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg30 -p 25442 -b 32 -z 80 --silent-mode=true -i -m mirrorless -c 30
dwadmin  33805     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg37 -p 25449 -b 39 -z 80 --silent-mode=true -i -m mirrorless -c 37
dwadmin  33807     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg31 -p 25443 -b 33 -z 80 --silent-mode=true -i -m mirrorless -c 31
dwadmin  33808     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg38 -p 25450 -b 40 -z 80 --silent-mode=true -i -m mirrorless -c 38
dwadmin  33809     1  0 17:25         00:00:04 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg39 -p 25451 -b 41 -z 80 --silent-mode=true -i -m mirrorless -c 39
dwadmin  33811     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg29 -p 25441 -b 31 -z 80 --silent-mode=true -i -m mirrorless -c 29
dwadmin  33812     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg26 -p 25438 -b 28 -z 80 --silent-mode=true -i -m mirrorless -c 26
dwadmin  33814     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg22 -p 25434 -b 24 -z 80 --silent-mode=true -i -m mirrorless -c 22
dwadmin  33815     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg32 -p 25444 -b 34 -z 80 --silent-mode=true -i -m mirrorless -c 32
dwadmin  33816     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg21 -p 25433 -b 23 -z 80 --silent-mode=true -i -m mirrorless -c 21
dwadmin  33817     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg27 -p 25439 -b 29 -z 80 --silent-mode=true -i -m mirrorless -c 27
dwadmin  33818     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg24 -p 25436 -b 26 -z 80 --silent-mode=true -i -m mirrorless -c 24
dwadmin  33819     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg23 -p 25435 -b 25 -z 80 --silent-mode=true -i -m mirrorless -c 23
dwadmin  33820     1  0 17:25         00:00:04 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg34 -p 25446 -b 36 -z 80 --silent-mode=true -i -m mirrorless -c 34
dwadmin  33821     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg25 -p 25437 -b 27 -z 80 --silent-mode=true -i -m mirrorless -c 25
dwadmin  33822     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg28 -p 25440 -b 30 -z 80 --silent-mode=true -i -m mirrorless -c 28
dwadmin  33823     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg20 -p 25432 -b 22 -z 80 --silent-mode=true -i -m mirrorless -c 20
dwadmin  33824 33807  0 17:25         00:00:00 postgres: port 25443, logger process
dwadmin  33828 33799  0 17:25         00:00:00 postgres: port 25447, logger process
dwadmin  33831 33807  0 17:25         00:00:00 postgres: port 25443, stats collector process
dwadmin  33832 33807  0 17:25         00:00:02 postgres: port 25443, writer process
dwadmin  33833 33807  0 17:25         00:00:00 postgres: port 25443, checkpoint process
dwadmin  33834 33807  0 17:25         00:00:00 postgres: port 25443, sweeper process
dwadmin  33835 33809  0 17:25         00:00:00 postgres: port 25451, logger process
dwadmin  33838 33801  0 17:25         00:00:00 postgres: port 25448, logger process
dwadmin  33841 33821  0 17:25         00:00:00 postgres: port 25437, logger process
dwadmin  33844 33818  0 17:25         00:00:00 postgres: port 25436, logger process
dwadmin  33847 33820  0 17:25         00:00:00 postgres: port 25446, logger process
dwadmin  33851 33803  0 17:25         00:00:00 postgres: port 25442, logger process
dwadmin  33854 33817  0 17:25         00:00:00 postgres: port 25439, logger process
dwadmin  33867 33822  0 17:25         00:00:00 postgres: port 25440, logger process
dwadmin  33868 33821  0 17:25         00:00:00 postgres: port 25437, stats collector process
dwadmin  33870 33821  0 17:25         00:00:02 postgres: port 25437, writer process
dwadmin  33872 33821  0 17:25         00:00:00 postgres: port 25437, checkpoint process
dwadmin  33873 33821  0 17:25         00:00:00 postgres: port 25437, sweeper process
dwadmin  33874 33801  0 17:25         00:00:00 postgres: port 25448, stats collector process
dwadmin  33875 33801  0 17:25         00:00:02 postgres: port 25448, writer process
dwadmin  33876 33801  0 17:25         00:00:00 postgres: port 25448, checkpoint process
dwadmin  33877 33801  0 17:25         00:00:00 postgres: port 25448, sweeper process
dwadmin  33879 33805  0 17:25         00:00:00 postgres: port 25449, logger process
dwadmin  33882 33803  0 17:25         00:00:00 postgres: port 25442, stats collector process
dwadmin  33883 33803  0 17:25         00:00:02 postgres: port 25442, writer process
dwadmin  33884 33803  0 17:25         00:00:00 postgres: port 25442, checkpoint process
dwadmin  33885 33817  0 17:25         00:00:00 postgres: port 25439, stats collector process
dwadmin  33886 33803  0 17:25         00:00:00 postgres: port 25442, sweeper process
dwadmin  33887 33817  0 17:25         00:00:02 postgres: port 25439, writer process
dwadmin  33888 33817  0 17:25         00:00:00 postgres: port 25439, checkpoint process
dwadmin  33889 33817  0 17:25         00:00:00 postgres: port 25439, sweeper process
dwadmin  33890 33818  0 17:25         00:00:00 postgres: port 25436, stats collector process
dwadmin  33891 33818  0 17:25         00:00:02 postgres: port 25436, writer process
dwadmin  33892 33818  0 17:25         00:00:00 postgres: port 25436, checkpoint process
dwadmin  33893 33818  0 17:25         00:00:00 postgres: port 25436, sweeper process
dwadmin  33894 33796  0 17:25         00:00:00 postgres: port 25445, logger process
dwadmin  33895 33816  0 17:25         00:00:00 postgres: port 25433, logger process
dwadmin  33896 33814  0 17:25         00:00:00 postgres: port 25434, logger process
dwadmin  33907 33811  0 17:25         00:00:00 postgres: port 25441, logger process
dwadmin  33910 33815  0 17:25         00:00:00 postgres: port 25444, logger process
dwadmin  33911 33808  0 17:25         00:00:00 postgres: port 25450, logger process
dwadmin  33916 33823  0 17:25         00:00:00 postgres: port 25432, logger process
dwadmin  33919 33812  0 17:25         00:00:00 postgres: port 25438, logger process
dwadmin  33920 33819  0 17:25         00:00:00 postgres: port 25435, logger process
dwadmin  33922 33799  0 17:25         00:00:00 postgres: port 25447, stats collector process
dwadmin  33926 33799  0 17:25         00:00:02 postgres: port 25447, writer process
dwadmin  33927 33799  0 17:25         00:00:00 postgres: port 25447, checkpoint process
dwadmin  33928 33799  0 17:25         00:00:00 postgres: port 25447, sweeper process
dwadmin  33940 33822  0 17:25         00:00:00 postgres: port 25440, stats collector process
dwadmin  33941 33822  0 17:25         00:00:02 postgres: port 25440, writer process
dwadmin  33942 33822  0 17:25         00:00:00 postgres: port 25440, checkpoint process
dwadmin  33943 33822  0 17:25         00:00:00 postgres: port 25440, sweeper process
dwadmin  33944 33805  0 17:25         00:00:00 postgres: port 25449, stats collector process
dwadmin  33945 33805  0 17:25         00:00:02 postgres: port 25449, writer process
dwadmin  33946 33805  0 17:25         00:00:00 postgres: port 25449, checkpoint process
dwadmin  33947 33814  0 17:25         00:00:00 postgres: port 25434, stats collector process
dwadmin  33948 33805  0 17:25         00:00:00 postgres: port 25449, sweeper process
dwadmin  33949 33814  0 17:25         00:00:02 postgres: port 25434, writer process
dwadmin  33950 33814  0 17:25         00:00:00 postgres: port 25434, checkpoint process
dwadmin  33951 33814  0 17:25         00:00:00 postgres: port 25434, sweeper process
dwadmin  33952 33823  0 17:25         00:00:00 postgres: port 25432, stats collector process
dwadmin  33953 33808  0 17:25         00:00:00 postgres: port 25450, stats collector process
dwadmin  33954 33823  0 17:25         00:00:02 postgres: port 25432, writer process
dwadmin  33955 33808  0 17:25         00:00:02 postgres: port 25450, writer process
dwadmin  33956 33823  0 17:25         00:00:00 postgres: port 25432, checkpoint process
dwadmin  33957 33808  0 17:25         00:00:00 postgres: port 25450, checkpoint process
dwadmin  33958 33823  0 17:25         00:00:00 postgres: port 25432, sweeper process
dwadmin  33959 33808  0 17:25         00:00:00 postgres: port 25450, sweeper process
dwadmin  33960 33816  0 17:25         00:00:00 postgres: port 25433, stats collector process
dwadmin  33961 33816  0 17:25         00:00:02 postgres: port 25433, writer process
dwadmin  33962 33816  0 17:25         00:00:00 postgres: port 25433, checkpoint process
dwadmin  33963 33816  0 17:25         00:00:00 postgres: port 25433, sweeper process
dwadmin  33964 33819  0 17:25         00:00:00 postgres: port 25435, stats collector process
dwadmin  33965 33812  0 17:25         00:00:00 postgres: port 25438, stats collector process
dwadmin  33966 33819  0 17:25         00:00:02 postgres: port 25435, writer process
dwadmin  33967 33812  0 17:25         00:00:02 postgres: port 25438, writer process
dwadmin  33968 33819  0 17:25         00:00:00 postgres: port 25435, checkpoint process
dwadmin  33969 33812  0 17:25         00:00:00 postgres: port 25438, checkpoint process
dwadmin  33970 33812  0 17:25         00:00:00 postgres: port 25438, sweeper process
dwadmin  33971 33819  0 17:25         00:00:00 postgres: port 25435, sweeper process
dwadmin  33972 33796  0 17:25         00:00:00 postgres: port 25445, stats collector process
dwadmin  33973 33796  0 17:25         00:00:02 postgres: port 25445, writer process
dwadmin  33974 33796  0 17:25         00:00:00 postgres: port 25445, checkpoint process
dwadmin  33975 33796  0 17:25         00:00:00 postgres: port 25445, sweeper process
dwadmin  33976 33811  0 17:25         00:00:00 postgres: port 25441, stats collector process
dwadmin  33977 33815  0 17:25         00:00:00 postgres: port 25444, stats collector process
dwadmin  33978 33811  0 17:25         00:00:02 postgres: port 25441, writer process
dwadmin  33979 33815  0 17:25         00:00:02 postgres: port 25444, writer process
dwadmin  33980 33811  0 17:25         00:00:00 postgres: port 25441, checkpoint process
dwadmin  33981 33815  0 17:25         00:00:00 postgres: port 25444, checkpoint process
dwadmin  33982 33811  0 17:25         00:00:00 postgres: port 25441, sweeper process
dwadmin  33983 33815  0 17:25         00:00:00 postgres: port 25444, sweeper process
[dwadmin@seg1 ~]$

5.[dwadmin@seg2 ~]$ ps -ef | grep postgres
dwadmin   6502 35314  0 17:25         00:00:00 postgres: port 25432, dwadmin pgbench 192.168.20.1(55304) con453 seg40 idle in transaction
dwadmin   6550 35320  0 17:25         00:00:00 postgres: port 25433, dwadmin pgbench 192.168.20.1(23358) con453 seg41 idle in transaction
dwadmin   6556 35314  0 17:25         00:00:00 postgres: port 25432, dwadmin pgbench 192.168.20.1(55608) con102 seg40 idle in transaction
dwadmin   6596 35320  0 17:25         00:00:00 postgres: port 25433, dwadmin pgbench 192.168.20.1(23646) con102 seg41 idle in transaction
dwadmin   6598 35322  0 17:25         00:00:00 postgres: port 25434, dwadmin pgbench 192.168.20.1(19724) con453 seg42 idle in transaction
dwadmin   6631 35322  0 17:25         00:00:00 postgres: port 25434, dwadmin pgbench 192.168.20.1(19948) con102 seg42 idle in transaction
dwadmin   6636 35318  0 17:25         00:00:00 postgres: port 25435, dwadmin pgbench 192.168.20.1(10080) con453 seg43 idle in transaction
dwadmin   6668 35321  0 17:25         00:00:00 postgres: port 25436, dwadmin pgbench 192.168.20.1(51861) con453 seg44 idle in transaction
dwadmin   6669 35318  0 17:25         00:00:00 postgres: port 25435, dwadmin pgbench 192.168.20.1(10252) con102 seg43 idle in transaction
dwadmin   6699 35321  0 17:25         00:00:00 postgres: port 25436, dwadmin pgbench 192.168.20.1(52039) con102 seg44 idle in transaction
dwadmin   6703 35324  0 17:25         00:00:00 postgres: port 25437, dwadmin pgbench 192.168.20.1(62843) con453 seg45 idle in transaction
dwadmin   6732 35324  0 17:25         00:00:00 postgres: port 25437, dwadmin pgbench 192.168.20.1(62999) con102 seg45 idle in transaction
dwadmin   6736 35325  0 17:25         00:00:00 postgres: port 25438, dwadmin pgbench 192.168.20.1(48813) con453 seg46 idle in transaction
dwadmin   6761 35325  0 17:25         00:00:00 postgres: port 25438, dwadmin pgbench 192.168.20.1(48937) con102 seg46 idle in transaction
dwadmin   6772 35326  0 17:25         00:00:00 postgres: port 25439, dwadmin pgbench 192.168.20.1(57905) con453 seg47 idle in transaction
dwadmin   6792 35326  0 17:25         00:00:00 postgres: port 25439, dwadmin pgbench 192.168.20.1(58007) con102 seg47 idle in transaction
dwadmin   6794 35314  0 17:25         00:00:00 postgres: port 25432, dwadmin pgbench 192.168.20.1(56896) con22 seg40 idle in transaction
dwadmin   6804 35304  0 17:25         00:00:00 postgres: port 25440, dwadmin pgbench 192.168.20.1(36918) con453 seg48 idle in transaction
dwadmin   6827 35304  0 17:25         00:00:00 postgres: port 25440, dwadmin pgbench 192.168.20.1(37040) con102 seg48 idle in transaction
dwadmin   6830 35320  0 17:25         00:00:00 postgres: port 25433, dwadmin pgbench 192.168.20.1(24924) con22 seg41 idle in transaction
dwadmin   6853 35303  0 17:25         00:00:00 postgres: port 25441, dwadmin pgbench 192.168.20.1(63075) con453 seg49 idle in transaction
dwadmin   6856 35303  0 17:25         00:00:00 postgres: port 25441, dwadmin pgbench 192.168.20.1(63131) con102 seg49 idle in transaction
dwadmin   6870 35322  0 17:25         00:00:00 postgres: port 25434, dwadmin pgbench 192.168.20.1(21220) con22 seg42 idle in transaction
dwadmin   6892 35319  0 17:25         00:00:00 postgres: port 25442, dwadmin pgbench 192.168.20.1(43762) con453 seg50 idle in transaction
dwadmin   6906 35319  0 17:25         00:00:00 postgres: port 25442, dwadmin pgbench 192.168.20.1(43810) con102 seg50 idle in transaction
dwadmin   6914 35318  0 17:25         00:00:00 postgres: port 25435, dwadmin pgbench 192.168.20.1(11552) con22 seg43 idle in transaction
dwadmin   6936 35312  0 17:25         00:00:00 postgres: port 25443, dwadmin pgbench 192.168.20.1(63792) con453 seg51 idle in transaction
dwadmin   6948 35312  0 17:25         00:00:00 postgres: port 25443, dwadmin pgbench 192.168.20.1(63876) con102 seg51 idle in transaction
dwadmin   6953 35321  0 17:25         00:00:00 postgres: port 25436, dwadmin pgbench 192.168.20.1(53341) con22 seg44 idle in transaction
dwadmin   6978 35323  0 17:25         00:00:00 postgres: port 25444, dwadmin pgbench 192.168.20.1(63850) con453 seg52 idle in transaction
dwadmin   6984 35323  0 17:25         00:00:00 postgres: port 25444, dwadmin pgbench 192.168.20.1(63898) con102 seg52 idle in transaction
dwadmin   6998 35324  0 17:25         00:00:00 postgres: port 25437, dwadmin pgbench 192.168.20.1(64327) con22 seg45 idle in transaction
dwadmin   7024 35316  0 17:25         00:00:00 postgres: port 25445, dwadmin pgbench 192.168.20.1(18594) con453 seg53 idle in transaction
dwadmin   7030 35316  0 17:25         00:00:00 postgres: port 25445, dwadmin pgbench 192.168.20.1(18628) con102 seg53 idle in transaction
dwadmin   7044 35325  0 17:25         00:00:00 postgres: port 25438, dwadmin pgbench 192.168.20.1(50319) con22 seg46 idle in transaction
dwadmin   7063 35311  0 17:25         00:00:00 postgres: port 25446, dwadmin pgbench 192.168.20.1(14451) con453 seg54 idle in transaction
dwadmin   7080 35326  0 17:25         00:00:00 postgres: port 25439, dwadmin pgbench 192.168.20.1(59409) con22 seg47 idle in transaction
dwadmin   7089 35311  0 17:25         00:00:00 postgres: port 25446, dwadmin pgbench 192.168.20.1(14533) con102 seg54 idle in transaction
dwadmin   7103 35307  0 17:25         00:00:00 postgres: port 25447, dwadmin pgbench 192.168.20.1(40911) con453 seg55 idle in transaction
dwadmin   7120 35304  0 17:25         00:00:00 postgres: port 25440, dwadmin pgbench 192.168.20.1(38448) con22 seg48 idle in transaction
dwadmin   7126 35307  0 17:25         00:00:00 postgres: port 25447, dwadmin pgbench 192.168.20.1(41011) con102 seg55 idle in transaction
dwadmin   7147 35300  0 17:25         00:00:00 postgres: port 25448, dwadmin pgbench 192.168.20.1(54617) con453 seg56 idle in transaction
dwadmin   7162 35303  0 17:25         00:00:00 postgres: port 25441, dwadmin pgbench 192.168.20.1(64559) con22 seg49 idle in transaction
dwadmin   7172 35300  0 17:25         00:00:00 postgres: port 25448, dwadmin pgbench 192.168.20.1(54743) con102 seg56 idle in transaction
dwadmin   7208 35319  0 17:25         00:00:00 postgres: port 25442, dwadmin pgbench 192.168.20.1(45240) con22 seg50 idle in transaction
dwadmin   7217 35294  0 17:25         00:00:00 postgres: port 25449, dwadmin pgbench 192.168.20.1(49423) con453 seg57 idle in transaction
dwadmin   7233 35294  0 17:25         00:00:00 postgres: port 25449, dwadmin pgbench 192.168.20.1(49523) con102 seg57 idle in transaction
dwadmin   7255 35312  0 17:25         00:00:00 postgres: port 25443, dwadmin pgbench 192.168.20.1(65324) con22 seg51 idle in transaction
dwadmin   7280 35299  0 17:25         00:00:00 postgres: port 25450, dwadmin pgbench 192.168.20.1(40329) con453 seg58 idle in transaction
dwadmin   7284 35299  0 17:25         00:00:00 postgres: port 25450, dwadmin pgbench 192.168.20.1(40483) con102 seg58 idle in transaction
dwadmin   7307 35323  0 17:25         00:00:00 postgres: port 25444, dwadmin pgbench 192.168.20.1(65428) con22 seg52 idle in transaction
dwadmin   7335 35302  0 17:25         00:00:00 postgres: port 25451, dwadmin pgbench 192.168.20.1(43193) con453 seg59 idle in transaction
dwadmin   7342 35302  0 17:25         00:00:00 postgres: port 25451, dwadmin pgbench 192.168.20.1(43233) con102 seg59 idle in transaction
dwadmin   7343 35316  0 17:25         00:00:00 postgres: port 25445, dwadmin pgbench 192.168.20.1(20114) con22 seg53 idle in transaction
dwadmin   7389 35311  0 17:25         00:00:00 postgres: port 25446, dwadmin pgbench 192.168.20.1(15973) con22 seg54 idle in transaction
dwadmin   7429 35307  0 17:25         00:00:00 postgres: port 25447, dwadmin pgbench 192.168.20.1(42419) con22 seg55 idle in transaction
dwadmin   7469 35300  0 17:25         00:00:00 postgres: port 25448, dwadmin pgbench 192.168.20.1(56155) con22 seg56 idle in transaction
dwadmin   7519 35294  0 17:25         00:00:00 postgres: port 25449, dwadmin pgbench 192.168.20.1(50897) con22 seg57 idle in transaction
dwadmin   7558 35299  0 17:25         00:00:00 postgres: port 25450, dwadmin pgbench 192.168.20.1(41713) con22 seg58 idle in transaction
dwadmin   7610 35302  0 17:25         00:00:00 postgres: port 25451, dwadmin pgbench 192.168.20.1(44455) con22 seg59 idle in transaction
dwadmin  16303 16254  0 21:47 pts/0    00:00:00 grep --color=auto postgres
dwadmin  35294     1  0 17:25         00:00:02 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg57 -p 25449 -b 59 -z 80 --silent-mode=true -i -m mirrorless -c 57
dwadmin  35299     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg58 -p 25450 -b 60 -z 80 --silent-mode=true -i -m mirrorless -c 58
dwadmin  35300     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg56 -p 25448 -b 58 -z 80 --silent-mode=true -i -m mirrorless -c 56
dwadmin  35302     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg59 -p 25451 -b 61 -z 80 --silent-mode=true -i -m mirrorless -c 59
dwadmin  35303     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg49 -p 25441 -b 51 -z 80 --silent-mode=true -i -m mirrorless -c 49
dwadmin  35304     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg48 -p 25440 -b 50 -z 80 --silent-mode=true -i -m mirrorless -c 48
dwadmin  35307     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg55 -p 25447 -b 57 -z 80 --silent-mode=true -i -m mirrorless -c 55
dwadmin  35311     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg54 -p 25446 -b 56 -z 80 --silent-mode=true -i -m mirrorless -c 54
dwadmin  35312     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg51 -p 25443 -b 53 -z 80 --silent-mode=true -i -m mirrorless -c 51
dwadmin  35314     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg40 -p 25432 -b 42 -z 80 --silent-mode=true -i -m mirrorless -c 40
dwadmin  35316     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg53 -p 25445 -b 55 -z 80 --silent-mode=true -i -m mirrorless -c 53
dwadmin  35318     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg43 -p 25435 -b 45 -z 80 --silent-mode=true -i -m mirrorless -c 43
dwadmin  35319     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg50 -p 25442 -b 52 -z 80 --silent-mode=true -i -m mirrorless -c 50
dwadmin  35320     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg41 -p 25433 -b 43 -z 80 --silent-mode=true -i -m mirrorless -c 41
dwadmin  35321     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg44 -p 25436 -b 46 -z 80 --silent-mode=true -i -m mirrorless -c 44
dwadmin  35322     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg42 -p 25434 -b 44 -z 80 --silent-mode=true -i -m mirrorless -c 42
dwadmin  35323     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg52 -p 25444 -b 54 -z 80 --silent-mode=true -i -m mirrorless -c 52
dwadmin  35324     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg45 -p 25437 -b 47 -z 80 --silent-mode=true -i -m mirrorless -c 45
dwadmin  35325     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg46 -p 25438 -b 48 -z 80 --silent-mode=true -i -m mirrorless -c 46
dwadmin  35326     1  0 17:25         00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -d /hgdata/dwdata/primary/hgdwseg47 -p 25439 -b 49 -z 80 --silent-mode=true -i -m mirrorless -c 47
dwadmin  35327 35294  0 17:25         00:00:00 postgres: port 25449, logger process
dwadmin  35331 35294  0 17:25         00:00:00 postgres: port 25449, stats collector process
dwadmin  35332 35294  0 17:25         00:00:02 postgres: port 25449, writer process
dwadmin  35333 35294  0 17:25         00:00:00 postgres: port 25449, checkpoint process
dwadmin  35334 35294  0 17:25         00:00:00 postgres: port 25449, sweeper process
dwadmin  35335 35302  0 17:25         00:00:00 postgres: port 25451, logger process
dwadmin  35338 35300  0 17:25         00:00:00 postgres: port 25448, logger process
dwadmin  35343 35299  0 17:25         00:00:00 postgres: port 25450, logger process
dwadmin  35346 35312  0 17:25         00:00:00 postgres: port 25443, logger process
dwadmin  35349 35307  0 17:25         00:00:00 postgres: port 25447, logger process
dwadmin  35352 35300  0 17:25         00:00:00 postgres: port 25448, stats collector process
dwadmin  35353 35300  0 17:25         00:00:02 postgres: port 25448, writer process
dwadmin  35354 35300  0 17:25         00:00:00 postgres: port 25448, checkpoint process
dwadmin  35355 35300  0 17:25         00:00:00 postgres: port 25448, sweeper process
dwadmin  35356 35302  0 17:25         00:00:00 postgres: port 25451, stats collector process
dwadmin  35357 35302  0 17:25         00:00:02 postgres: port 25451, writer process
dwadmin  35358 35302  0 17:25         00:00:00 postgres: port 25451, checkpoint process
dwadmin  35359 35321  0 17:25         00:00:00 postgres: port 25436, logger process
dwadmin  35360 35302  0 17:25         00:00:00 postgres: port 25451, sweeper process
dwadmin  35363 35314  0 17:25         00:00:00 postgres: port 25432, logger process
dwadmin  35367 35303  0 17:25         00:00:00 postgres: port 25441, logger process
dwadmin  35373 35299  0 17:25         00:00:00 postgres: port 25450, stats collector process
dwadmin  35374 35299  0 17:25         00:00:02 postgres: port 25450, writer process
dwadmin  35375 35299  0 17:25         00:00:00 postgres: port 25450, checkpoint process
dwadmin  35376 35299  0 17:25         00:00:00 postgres: port 25450, sweeper process
dwadmin  35378 35312  0 17:25         00:00:00 postgres: port 25443, stats collector process
dwadmin  35379 35312  0 17:25         00:00:02 postgres: port 25443, writer process
dwadmin  35380 35312  0 17:25         00:00:00 postgres: port 25443, checkpoint process
dwadmin  35381 35312  0 17:25         00:00:00 postgres: port 25443, sweeper process
dwadmin  35382 35323  0 17:25         00:00:00 postgres: port 25444, logger process
dwadmin  35385 35307  0 17:25         00:00:00 postgres: port 25447, stats collector process
dwadmin  35386 35307  0 17:25         00:00:02 postgres: port 25447, writer process
dwadmin  35387 35307  0 17:25         00:00:00 postgres: port 25447, checkpoint process
dwadmin  35388 35307  0 17:25         00:00:00 postgres: port 25447, sweeper process
dwadmin  35389 35321  0 17:25         00:00:00 postgres: port 25436, stats collector process
dwadmin  35390 35321  0 17:25         00:00:02 postgres: port 25436, writer process
dwadmin  35391 35321  0 17:25         00:00:00 postgres: port 25436, checkpoint process
dwadmin  35392 35321  0 17:25         00:00:00 postgres: port 25436, sweeper process
dwadmin  35393 35319  0 17:25         00:00:00 postgres: port 25442, logger process
dwadmin  35396 35320  0 17:25         00:00:00 postgres: port 25433, logger process
dwadmin  35399 35311  0 17:25         00:00:00 postgres: port 25446, logger process
dwadmin  35403 35314  0 17:25         00:00:00 postgres: port 25432, stats collector process
dwadmin  35404 35314  0 17:25         00:00:02 postgres: port 25432, writer process
dwadmin  35405 35314  0 17:25         00:00:00 postgres: port 25432, checkpoint process
dwadmin  35406 35314  0 17:25         00:00:00 postgres: port 25432, sweeper process
dwadmin  35407 35324  0 17:25         00:00:00 postgres: port 25437, logger process
dwadmin  35408 35326  0 17:25         00:00:00 postgres: port 25439, logger process
dwadmin  35413 35316  0 17:25         00:00:00 postgres: port 25445, logger process
dwadmin  35414 35304  0 17:25         00:00:00 postgres: port 25440, logger process
dwadmin  35419 35322  0 17:25         00:00:00 postgres: port 25434, logger process
dwadmin  35422 35318  0 17:25         00:00:00 postgres: port 25435, logger process
dwadmin  35423 35325  0 17:25         00:00:00 postgres: port 25438, logger process
dwadmin  35428 35303  0 17:25         00:00:00 postgres: port 25441, stats collector process
dwadmin  35429 35303  0 17:25         00:00:02 postgres: port 25441, writer process
dwadmin  35430 35303  0 17:25         00:00:00 postgres: port 25441, checkpoint process
dwadmin  35431 35303  0 17:25         00:00:00 postgres: port 25441, sweeper process
dwadmin  35441 35320  0 17:25         00:00:00 postgres: port 25433, stats collector process
dwadmin  35442 35319  0 17:25         00:00:00 postgres: port 25442, stats collector process
dwadmin  35443 35311  0 17:25         00:00:00 postgres: port 25446, stats collector process
dwadmin  35444 35320  0 17:25         00:00:02 postgres: port 25433, writer process
dwadmin  35445 35319  0 17:25         00:00:02 postgres: port 25442, writer process
dwadmin  35446 35311  0 17:25         00:00:02 postgres: port 25446, writer process
dwadmin  35447 35320  0 17:25         00:00:00 postgres: port 25433, checkpoint process
dwadmin  35448 35311  0 17:25         00:00:00 postgres: port 25446, checkpoint process
dwadmin  35449 35319  0 17:25         00:00:00 postgres: port 25442, checkpoint process
dwadmin  35450 35320  0 17:25         00:00:00 postgres: port 25433, sweeper process
dwadmin  35451 35319  0 17:25         00:00:00 postgres: port 25442, sweeper process
dwadmin  35452 35311  0 17:25         00:00:00 postgres: port 25446, sweeper process
dwadmin  35454 35323  0 17:25         00:00:00 postgres: port 25444, stats collector process
dwadmin  35455 35326  0 17:25         00:00:00 postgres: port 25439, stats collector process
dwadmin  35456 35323  0 17:25         00:00:02 postgres: port 25444, writer process
dwadmin  35457 35326  0 17:25         00:00:02 postgres: port 25439, writer process
dwadmin  35458 35323  0 17:25         00:00:00 postgres: port 25444, checkpoint process
dwadmin  35459 35326  0 17:25         00:00:00 postgres: port 25439, checkpoint process
dwadmin  35460 35323  0 17:25         00:00:00 postgres: port 25444, sweeper process
dwadmin  35461 35324  0 17:25         00:00:00 postgres: port 25437, stats collector process
dwadmin  35462 35326  0 17:25         00:00:00 postgres: port 25439, sweeper process
dwadmin  35463 35324  0 17:25         00:00:02 postgres: port 25437, writer process
dwadmin  35464 35324  0 17:25         00:00:00 postgres: port 25437, checkpoint process
dwadmin  35465 35324  0 17:25         00:00:00 postgres: port 25437, sweeper process
dwadmin  35467 35325  0 17:25         00:00:00 postgres: port 25438, stats collector process
dwadmin  35468 35325  0 17:25         00:00:02 postgres: port 25438, writer process
dwadmin  35469 35325  0 17:25         00:00:00 postgres: port 25438, checkpoint process
dwadmin  35470 35325  0 17:25         00:00:00 postgres: port 25438, sweeper process
dwadmin  35471 35304  0 17:25         00:00:00 postgres: port 25440, stats collector process
dwadmin  35472 35304  0 17:25         00:00:02 postgres: port 25440, writer process
dwadmin  35473 35304  0 17:25         00:00:00 postgres: port 25440, checkpoint process
dwadmin  35474 35304  0 17:25         00:00:00 postgres: port 25440, sweeper process
dwadmin  35475 35316  0 17:25         00:00:00 postgres: port 25445, stats collector process
dwadmin  35476 35316  0 17:25         00:00:02 postgres: port 25445, writer process
dwadmin  35477 35316  0 17:25         00:00:00 postgres: port 25445, checkpoint process
dwadmin  35478 35316  0 17:25         00:00:00 postgres: port 25445, sweeper process
dwadmin  35479 35318  0 17:25         00:00:00 postgres: port 25435, stats collector process
dwadmin  35480 35318  0 17:25         00:00:02 postgres: port 25435, writer process
dwadmin  35481 35318  0 17:25         00:00:00 postgres: port 25435, checkpoint process
dwadmin  35482 35318  0 17:25         00:00:00 postgres: port 25435, sweeper process
dwadmin  35483 35322  0 17:25         00:00:00 postgres: port 25434, stats collector process
dwadmin  35484 35322  0 17:25         00:00:02 postgres: port 25434, writer process
dwadmin  35485 35322  0 17:25         00:00:00 postgres: port 25434, checkpoint process
dwadmin  35486 35322  0 17:25         00:00:00 postgres: port 25434, sweeper process
[dwadmin@seg2 ~]$

6.[dwadmin@seg3 ~]$ ps -ef | grep postgres
dwadmin   1122 31177  0 17:24         00:00:00 postgres: port 25436, dwadmin pgbench 192.168.20.1(3452) con102 seg64 idle in transaction
dwadmin   1211 31182  0 17:24         00:00:00 postgres: port 25437, dwadmin pgbench 192.168.20.1(44001) con102 seg65 idle in transaction
dwadmin   1255 31177  0 17:24         00:00:00 postgres: port 25436, dwadmin pgbench 192.168.20.1(3442) con22 seg64 idle in transaction
dwadmin   1260 31178  0 17:24         00:00:00 postgres: port 25438, dwadmin pgbench 192.168.20.1(56463) con102 seg66 idle in transacti