psql: FATAL: the database system is in recovery mode - 问题定位方法与解决

首先介绍一下背景,在测试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 transaction
dwadmin   1311 31181  0 17:24 ?        00:00:00 postgres: port 25439, dwadmin pgbench 192.168.20.1(50090) con102 seg67 idle in transaction
dwadmin   1399 31177  0 17:24 ?        00:00:00 postgres: port 25436, dwadmin pgbench 192.168.20.1(3748) con453 seg64 idle in transaction
dwadmin   1413 31185  0 17:24 ?        00:00:00 postgres: port 25440, dwadmin pgbench 192.168.20.1(41357) con102 seg68 idle in transaction
dwadmin   1469 31187  0 17:24 ?        00:00:00 postgres: port 25441, dwadmin pgbench 192.168.20.1(19949) con102 seg69 idle in transaction
dwadmin   1485 31182  0 17:24 ?        00:00:00 postgres: port 25437, dwadmin pgbench 192.168.20.1(44783) con22 seg65 idle in transaction
dwadmin   1554 31155  0 17:24 ?        00:00:00 postgres: port 25442, dwadmin pgbench 192.168.20.1(21880) con102 seg70 idle in transaction
dwadmin   1656 31178  0 17:24 ?        00:00:00 postgres: port 25438, dwadmin pgbench 192.168.20.1(57667) con22 seg66 idle in transaction
dwadmin   1684 31174  0 17:24 ?        00:00:00 postgres: port 25443, dwadmin pgbench 192.168.20.1(65342) con102 seg71 idle in transaction
dwadmin   1757 31181  0 17:24 ?        00:00:00 postgres: port 25439, dwadmin pgbench 192.168.20.1(51392) con22 seg67 idle in transaction
dwadmin   1824 31169  0 17:24 ?        00:00:00 postgres: port 25444, dwadmin pgbench 192.168.20.1(39650) con102 seg72 idle in transaction
dwadmin   1896 31176  0 17:24 ?        00:00:00 postgres: port 25445, dwadmin pgbench 192.168.20.1(40111) con102 seg73 idle in transaction
dwadmin   1907 31182  0 17:24 ?        00:00:00 postgres: port 25437, dwadmin pgbench 192.168.20.1(45923) con453 seg65 idle in transaction
dwadmin   1947 31185  0 17:24 ?        00:00:00 postgres: port 25440, dwadmin pgbench 192.168.20.1(42847) con22 seg68 idle in transaction
dwadmin   2027 31187  0 17:24 ?        00:00:00 postgres: port 25441, dwadmin pgbench 192.168.20.1(21403) con22 seg69 idle in transaction
dwadmin   2216 31183  0 17:24 ?        00:00:00 postgres: port 25446, dwadmin pgbench 192.168.20.1(28310) con102 seg74 idle in transaction
dwadmin   2252 31155  0 17:24 ?        00:00:00 postgres: port 25442, dwadmin pgbench 192.168.20.1(23680) con22 seg70 idle in transaction
dwadmin   2358 31184  0 17:24 ?        00:00:00 postgres: port 25447, dwadmin pgbench 192.168.20.1(41926) con102 seg75 idle in transaction
dwadmin   2397 31174  0 17:24 ?        00:00:00 postgres: port 25443, dwadmin pgbench 192.168.20.1(2847) con22 seg71 idle in transaction
dwadmin   2517 31169  0 17:24 ?        00:00:00 postgres: port 25444, dwadmin pgbench 192.168.20.1(41516) con22 seg72 idle in transaction
dwadmin   2523 31175  0 17:24 ?        00:00:00 postgres: port 25448, dwadmin pgbench 192.168.20.1(48715) con102 seg76 idle in transaction
dwadmin   2639 31158  0 17:24 ?        00:00:00 postgres: port 25449, dwadmin pgbench 192.168.20.1(39301) con102 seg77 idle in transaction
dwadmin   2666 31176  0 17:24 ?        00:00:00 postgres: port 25445, dwadmin pgbench 192.168.20.1(42211) con22 seg73 idle in transaction
dwadmin   2689 31178  0 17:24 ?        00:00:00 postgres: port 25438, dwadmin pgbench 192.168.20.1(60145) con453 seg66 idle in transaction
dwadmin   2773 31186  0 17:24 ?        00:00:00 postgres: port 25450, dwadmin pgbench 192.168.20.1(13826) con102 seg78 idle in transaction
dwadmin   2838 31183  0 17:24 ?        00:00:00 postgres: port 25446, dwadmin pgbench 192.168.20.1(30114) con22 seg74 idle in transaction
dwadmin   2865 31181  0 17:24 ?        00:00:00 postgres: port 25439, dwadmin pgbench 192.168.20.1(54088) con453 seg67 idle in transaction
dwadmin   2925 31173  0 17:24 ?        00:00:00 postgres: port 25451, dwadmin pgbench 192.168.20.1(5155) con102 seg79 idle in transaction
dwadmin   2996 31185  0 17:24 ?        00:00:00 postgres: port 25440, dwadmin pgbench 192.168.20.1(45858) con453 seg68 idle in transaction
dwadmin   3047 31184  0 17:24 ?        00:00:00 postgres: port 25447, dwadmin pgbench 192.168.20.1(43864) con22 seg75 idle in transaction
dwadmin   3317 31187  0 17:24 ?        00:00:00 postgres: port 25441, dwadmin pgbench 192.168.20.1(24677) con453 seg69 idle in transaction
dwadmin   3349 31175  0 17:24 ?        00:00:00 postgres: port 25448, dwadmin pgbench 192.168.20.1(50653) con22 seg76 idle in transaction
dwadmin   3597 31155  0 17:24 ?        00:00:00 postgres: port 25442, dwadmin pgbench 192.168.20.1(27068) con453 seg70 idle in transaction
dwadmin   3601 31158  0 17:24 ?        00:00:00 postgres: port 25449, dwadmin pgbench 192.168.20.1(41515) con22 seg77 idle in transaction
dwadmin   3785 31174  0 17:24 ?        00:00:00 postgres: port 25443, dwadmin pgbench 192.168.20.1(6335) con453 seg71 idle in transaction
dwadmin   3787 31186  0 17:24 ?        00:00:00 postgres: port 25450, dwadmin pgbench 192.168.20.1(16368) con22 seg78 idle in transaction
dwadmin   4005 31169  0 17:24 ?        00:00:00 postgres: port 25444, dwadmin pgbench 192.168.20.1(45252) con453 seg72 idle in transaction
dwadmin   4149 31176  0 17:24 ?        00:00:00 postgres: port 25445, dwadmin pgbench 192.168.20.1(46105) con453 seg73 idle in transaction
dwadmin   4270 31173  0 17:24 ?        00:00:00 postgres: port 25451, dwadmin pgbench 192.168.20.1(8702) con22 seg79 idle in transaction
dwadmin   4408 31183  0 17:24 ?        00:00:00 postgres: port 25446, dwadmin pgbench 192.168.20.1(34344) con453 seg74 idle in transaction
dwadmin   4565 31184  0 17:24 ?        00:00:00 postgres: port 25447, dwadmin pgbench 192.168.20.1(47734) con453 seg75 idle in transaction
dwadmin   4829 31175  0 17:24 ?        00:00:00 postgres: port 25448, dwadmin pgbench 192.168.20.1(54989) con453 seg76 idle in transaction
dwadmin   5132 31158  0 17:24 ?        00:00:00 postgres: port 25449, dwadmin pgbench 192.168.20.1(46063) con453 seg77 idle in transaction
dwadmin   5203 31186  0 17:24 ?        00:00:00 postgres: port 25450, dwadmin pgbench 192.168.20.1(20588) con453 seg78 idle in transaction
dwadmin   5383 31173  0 17:24 ?        00:00:00 postgres: port 25451, dwadmin pgbench 192.168.20.1(11760) con453 seg79 idle in transaction
dwadmin   7260 31180  0 17:24 ?        00:00:00 postgres: port 25432, dwadmin pgbench 192.168.20.1(13308) con102 seg60 idle in transaction
dwadmin   7270 31180  0 17:24 ?        00:00:00 postgres: port 25432, dwadmin pgbench 192.168.20.1(13272) con453 seg60 idle in transaction
dwadmin   7340 31179  0 17:24 ?        00:00:00 postgres: port 25433, dwadmin pgbench 192.168.20.1(33801) con453 seg61 idle in transaction
dwadmin   7385 31179  0 17:24 ?        00:00:00 postgres: port 25433, dwadmin pgbench 192.168.20.1(34047) con102 seg61 idle in transaction
dwadmin   7456 31170  0 17:24 ?        00:00:00 postgres: port 25434, dwadmin pgbench 192.168.20.1(34271) con453 seg62 idle in transaction
dwadmin   7473 31170  0 17:24 ?        00:00:00 postgres: port 25434, dwadmin pgbench 192.168.20.1(34395) con102 seg62 idle in transaction
dwadmin   7529 31167  0 17:24 ?        00:00:00 postgres: port 25435, dwadmin pgbench 192.168.20.1(37789) con453 seg63 idle in transaction
dwadmin   7565 31167  0 17:24 ?        00:00:00 postgres: port 25435, dwadmin pgbench 192.168.20.1(37985) con102 seg63 idle in transaction
dwadmin   7566 31180  0 17:24 ?        00:00:00 postgres: port 25432, dwadmin pgbench 192.168.20.1(14524) con22 seg60 idle in transaction
dwadmin   7688 31179  0 17:24 ?        00:00:00 postgres: port 25433, dwadmin pgbench 192.168.20.1(35139) con22 seg61 idle in transaction
dwadmin   7777 31170  0 17:24 ?        00:00:00 postgres: port 25434, dwadmin pgbench 192.168.20.1(35519) con22 seg62 idle in transaction
dwadmin   7833 31167  0 17:24 ?        00:00:00 postgres: port 25435, dwadmin pgbench 192.168.20.1(39081) con22 seg63 idle in transaction
dwadmin  12057 12006  0 21:43 pts/0    00:00:00 grep --color=auto postgres
dwadmin  31155     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg70 -p 25442 -b 72 -z 80 --silent-mode=true -i -M mirrorless -C 70
dwadmin  31158     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg77 -p 25449 -b 79 -z 80 --silent-mode=true -i -M mirrorless -C 77
dwadmin  31167     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg63 -p 25435 -b 65 -z 80 --silent-mode=true -i -M mirrorless -C 63
dwadmin  31169     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg72 -p 25444 -b 74 -z 80 --silent-mode=true -i -M mirrorless -C 72
dwadmin  31170     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg62 -p 25434 -b 64 -z 80 --silent-mode=true -i -M mirrorless -C 62
dwadmin  31173     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg79 -p 25451 -b 81 -z 80 --silent-mode=true -i -M mirrorless -C 79
dwadmin  31174     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg71 -p 25443 -b 73 -z 80 --silent-mode=true -i -M mirrorless -C 71
dwadmin  31175     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg76 -p 25448 -b 78 -z 80 --silent-mode=true -i -M mirrorless -C 76
dwadmin  31176     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg73 -p 25445 -b 75 -z 80 --silent-mode=true -i -M mirrorless -C 73
dwadmin  31177     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg64 -p 25436 -b 66 -z 80 --silent-mode=true -i -M mirrorless -C 64
dwadmin  31178     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg66 -p 25438 -b 68 -z 80 --silent-mode=true -i -M mirrorless -C 66
dwadmin  31179     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg61 -p 25433 -b 63 -z 80 --silent-mode=true -i -M mirrorless -C 61
dwadmin  31180     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg60 -p 25432 -b 62 -z 80 --silent-mode=true -i -M mirrorless -C 60
dwadmin  31181     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg67 -p 25439 -b 69 -z 80 --silent-mode=true -i -M mirrorless -C 67
dwadmin  31182     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg65 -p 25437 -b 67 -z 80 --silent-mode=true -i -M mirrorless -C 65
dwadmin  31183     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg74 -p 25446 -b 76 -z 80 --silent-mode=true -i -M mirrorless -C 74
dwadmin  31184     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg75 -p 25447 -b 77 -z 80 --silent-mode=true -i -M mirrorless -C 75
dwadmin  31185     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg68 -p 25440 -b 70 -z 80 --silent-mode=true -i -M mirrorless -C 68
dwadmin  31186     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg78 -p 25450 -b 80 -z 80 --silent-mode=true -i -M mirrorless -C 78
dwadmin  31187     1  0 17:23 ?        00:00:03 /home/dwadmin/vitesse.deepgreendb.16.21.171007/bin/postgres -D /hgdata/dwdata/primary/hgdwseg69 -p 25441 -b 71 -z 80 --silent-mode=true -i -M mirrorless -C 69
dwadmin  31188 31155  0 17:23 ?        00:00:00 postgres: port 25442, logger process
dwadmin  31191 31169  0 17:23 ?        00:00:00 postgres: port 25444, logger process
dwadmin  31194 31173  0 17:23 ?        00:00:00 postgres: port 25451, logger process
dwadmin  31197 31167  0 17:23 ?        00:00:00 postgres: port 25435, logger process
dwadmin  31201 31176  0 17:23 ?        00:00:00 postgres: port 25445, logger process
dwadmin  31207 31169  0 17:23 ?        00:00:00 postgres: port 25444, stats collector process
dwadmin  31208 31169  0 17:23 ?        00:00:02 postgres: port 25444, writer process
dwadmin  31209 31169  0 17:23 ?        00:00:00 postgres: port 25444, checkpoint process
dwadmin  31210 31169  0 17:23 ?        00:00:00 postgres: port 25444, sweeper process
dwadmin  31211 31155  0 17:23 ?        00:00:00 postgres: port 25442, stats collector process
dwadmin  31212 31155  0 17:23 ?        00:00:02 postgres: port 25442, writer process
dwadmin  31213 31155  0 17:23 ?        00:00:00 postgres: port 25442, checkpoint process
dwadmin  31214 31155  0 17:23 ?        00:00:00 postgres: port 25442, sweeper process
dwadmin  31215 31175  0 17:23 ?        00:00:00 postgres: port 25448, logger process
dwadmin  31219 31178  0 17:23 ?        00:00:00 postgres: port 25438, logger process
dwadmin  31220 31167  0 17:23 ?        00:00:00 postgres: port 25435, stats collector process
dwadmin  31221 31167  0 17:23 ?        00:00:02 postgres: port 25435, writer process
dwadmin  31223 31167  0 17:23 ?        00:00:00 postgres: port 25435, checkpoint process
dwadmin  31225 31167  0 17:23 ?        00:00:00 postgres: port 25435, sweeper process
dwadmin  31226 31173  0 17:23 ?        00:00:00 postgres: port 25451, stats collector process
dwadmin  31227 31173  0 17:23 ?        00:00:02 postgres: port 25451, writer process
dwadmin  31228 31173  0 17:23 ?        00:00:00 postgres: port 25451, checkpoint process
dwadmin  31229 31173  0 17:23 ?        00:00:00 postgres: port 25451, sweeper process
dwadmin  31230 31180  0 17:23 ?        00:00:00 postgres: port 25432, logger process
dwadmin  31233 31176  0 17:23 ?        00:00:00 postgres: port 25445, stats collector process
dwadmin  31234 31176  0 17:23 ?        00:00:02 postgres: port 25445, writer process
dwadmin  31235 31176  0 17:23 ?        00:00:00 postgres: port 25445, checkpoint process
dwadmin  31236 31184  0 17:23 ?        00:00:00 postgres: port 25447, logger process
dwadmin  31237 31176  0 17:23 ?        00:00:00 postgres: port 25445, sweeper process
dwadmin  31243 31179  0 17:23 ?        00:00:00 postgres: port 25433, logger process
dwadmin  31246 31175  0 17:23 ?        00:00:00 postgres: port 25448, stats collector process
dwadmin  31247 31175  0 17:23 ?        00:00:02 postgres: port 25448, writer process
dwadmin  31248 31175  0 17:23 ?        00:00:00 postgres: port 25448, checkpoint process
dwadmin  31249 31175  0 17:23 ?        00:00:00 postgres: port 25448, sweeper process
dwadmin  31251 31174  0 17:23 ?        00:00:00 postgres: port 25443, logger process
dwadmin  31254 31158  0 17:23 ?        00:00:00 postgres: port 25449, logger process
dwadmin  31257 31178  0 17:23 ?        00:00:00 postgres: port 25438, stats collector process
dwadmin  31258 31178  0 17:23 ?        00:00:02 postgres: port 25438, writer process
dwadmin  31259 31178  0 17:23 ?        00:00:00 postgres: port 25438, checkpoint process
dwadmin  31260 31178  0 17:23 ?        00:00:00 postgres: port 25438, sweeper process
dwadmin  31261 31182  0 17:23 ?        00:00:00 postgres: port 25437, logger process
dwadmin  31262 31180  0 17:23 ?        00:00:00 postgres: port 25432, stats collector process
dwadmin  31263 31180  0 17:23 ?        00:00:02 postgres: port 25432, writer process
dwadmin  31264 31180  0 17:23 ?        00:00:00 postgres: port 25432, checkpoint process
dwadmin  31266 31180  0 17:23 ?        00:00:00 postgres: port 25432, sweeper process
dwadmin  31268 31181  0 17:23 ?        00:00:00 postgres: port 25439, logger process
dwadmin  31271 31186  0 17:23 ?        00:00:00 postgres: port 25450, logger process
dwadmin  31274 31183  0 17:23 ?        00:00:00 postgres: port 25446, logger process
dwadmin  31275 31187  0 17:23 ?        00:00:00 postgres: port 25441, logger process
dwadmin  31276 31170  0 17:23 ?        00:00:00 postgres: port 25434, logger process
dwadmin  31283 31185  0 17:23 ?        00:00:00 postgres: port 25440, logger process
dwadmin  31286 31177  0 17:23 ?        00:00:00 postgres: port 25436, logger process
dwadmin  31290 31184  0 17:23 ?        00:00:00 postgres: port 25447, stats collector process
dwadmin  31291 31184  0 17:23 ?        00:00:02 postgres: port 25447, writer process
dwadmin  31292 31184  0 17:23 ?        00:00:00 postgres: port 25447, checkpoint process
dwadmin  31293 31184  0 17:23 ?        00:00:00 postgres: port 25447, sweeper process
dwadmin  31303 31179  0 17:23 ?        00:00:00 postgres: port 25433, stats collector process
dwadmin  31304 31179  0 17:23 ?        00:00:02 postgres: port 25433, writer process
dwadmin  31305 31179  0 17:23 ?        00:00:00 postgres: port 25433, checkpoint process
dwadmin  31306 31179  0 17:23 ?        00:00:00 postgres: port 25433, sweeper process
dwadmin  31307 31174  0 17:23 ?        00:00:00 postgres: port 25443, stats collector process
dwadmin  31308 31174  0 17:23 ?        00:00:02 postgres: port 25443, writer process
dwadmin  31309 31174  0 17:23 ?        00:00:00 postgres: port 25443, checkpoint process
dwadmin  31310 31174  0 17:23 ?        00:00:00 postgres: port 25443, sweeper process
dwadmin  31311 31182  0 17:23 ?        00:00:00 postgres: port 25437, stats collector process
dwadmin  31312 31182  0 17:23 ?        00:00:02 postgres: port 25437, writer process
dwadmin  31313 31182  0 17:23 ?        00:00:00 postgres: port 25437, checkpoint process
dwadmin  31314 31182  0 17:23 ?        00:00:00 postgres: port 25437, sweeper process
dwadmin  31315 31181  0 17:23 ?        00:00:00 postgres: port 25439, stats collector process
dwadmin  31316 31158  0 17:23 ?        00:00:00 postgres: port 25449, stats collector process
dwadmin  31317 31181  0 17:23 ?        00:00:02 postgres: port 25439, writer process
dwadmin  31318 31186  0 17:23 ?        00:00:00 postgres: port 25450, stats collector process
dwadmin  31319 31158  0 17:23 ?        00:00:02 postgres: port 25449, writer process
dwadmin  31320 31181  0 17:23 ?        00:00:00 postgres: port 25439, checkpoint process
dwadmin  31321 31186  0 17:23 ?        00:00:02 postgres: port 25450, writer process
dwadmin  31322 31158  0 17:23 ?        00:00:00 postgres: port 25449, checkpoint process
dwadmin  31323 31181  0 17:23 ?        00:00:00 postgres: port 25439, sweeper process
dwadmin  31324 31186  0 17:23 ?        00:00:00 postgres: port 25450, checkpoint process
dwadmin  31325 31186  0 17:23 ?        00:00:00 postgres: port 25450, sweeper process
dwadmin  31326 31158  0 17:23 ?        00:00:00 postgres: port 25449, sweeper process
dwadmin  31327 31183  0 17:23 ?        00:00:00 postgres: port 25446, stats collector process
dwadmin  31328 31183  0 17:23 ?        00:00:02 postgres: port 25446, writer process
dwadmin  31329 31183  0 17:23 ?        00:00:00 postgres: port 25446, checkpoint process
dwadmin  31330 31187  0 17:23 ?        00:00:00 postgres: port 25441, stats collector process
dwadmin  31331 31183  0 17:23 ?        00:00:00 postgres: port 25446, sweeper process
dwadmin  31332 31187  0 17:23 ?        00:00:02 postgres: port 25441, writer process
dwadmin  31333 31187  0 17:23 ?        00:00:00 postgres: port 25441, checkpoint process
dwadmin  31334 31187  0 17:23 ?        00:00:00 postgres: port 25441, sweeper process
dwadmin  31335 31170  0 17:23 ?        00:00:00 postgres: port 25434, stats collector process
dwadmin  31336 31170  0 17:23 ?        00:00:02 postgres: port 25434, writer process
dwadmin  31337 31170  0 17:23 ?        00:00:00 postgres: port 25434, checkpoint process
dwadmin  31338 31170  0 17:23 ?        00:00:00 postgres: port 25434, sweeper process
dwadmin  31339 31185  0 17:23 ?        00:00:00 postgres: port 25440, stats collector process
dwadmin  31340 31185  0 17:23 ?        00:00:02 postgres: port 25440, writer process
dwadmin  31341 31185  0 17:23 ?        00:00:00 postgres: port 25440, checkpoint process
dwadmin  31342 31185  0 17:23 ?        00:00:00 postgres: port 25440, sweeper process
dwadmin  31344 31177  0 17:23 ?        00:00:00 postgres: port 25436, stats collector process
dwadmin  31345 31177  0 17:23 ?        00:00:02 postgres: port 25436, writer process
dwadmin  31346 31177  0 17:23 ?        00:00:00 postgres: port 25436, checkpoint process
dwadmin  31347 31177  0 17:23 ?        00:00:00 postgres: port 25436, sweeper process
[dwadmin@seg3 ~]$

7.strace查看进程,并没有做什么操作:
[dwadmin@seg0 ~]$ strace -p 33632
Process 33632 attached
recvfrom(8,

 ^CProcess 33632 detached
 <detached ...>
[dwadmin@seg0 ~]$ ^C

8.使用脚本杀死所有pgbench相关的进程,重启greenplum成功。
[dwadmin@master ~]$ gpstop -a
20180329:05:35:31:018021 gpstop:master:dwadmin-[INFO]:-Starting gpstop with args: -a
20180329:05:35:31:018021 gpstop:master:dwadmin-[INFO]:-Gathering information and validating the environment...
20180329:05:35:31:018021 gpstop:master:dwadmin-[INFO]:-Obtaining Greenplum Master catalog information
20180329:05:35:31:018021 gpstop:master:dwadmin-[INFO]:-Obtaining Segment details from master...
20180329:05:35:31:018021 gpstop:master:dwadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.3.99.00 build Deepgreen DB'
20180329:05:35:31:018021 gpstop:master:dwadmin-[INFO]:-There are 0 connections to the database
20180329:05:35:31:018021 gpstop:master:dwadmin-[INFO]:-Commencing Master instance shutdown with mode='smart'
20180329:05:35:31:018021 gpstop:master:dwadmin-[INFO]:-Master host=master
20180329:05:35:31:018021 gpstop:master:dwadmin-[INFO]:-Commencing Master instance shutdown with mode=smart
20180329:05:35:31:018021 gpstop:master:dwadmin-[INFO]:-Master segment instance directory=/hgdata/dwdata/master/hgdwseg-1
20180329:05:35:32:018021 gpstop:master:dwadmin-[INFO]:-Attempting forceful termination of any leftover master process
20180329:05:35:32:018021 gpstop:master:dwadmin-[INFO]:-Terminating processes for segment /hgdata/dwdata/master/hgdwseg-1
20180329:05:35:32:018021 gpstop:master:dwadmin-[INFO]:-No standby master host configured
20180329:05:35:32:018021 gpstop:master:dwadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...
20180329:05:35:32:018021 gpstop:master:dwadmin-[INFO]:-0.00% of jobs completed
20180329:05:35:42:018021 gpstop:master:dwadmin-[INFO]:-100.00% of jobs completed
20180329:05:35:42:018021 gpstop:master:dwadmin-[INFO]:-----------------------------------------------------
20180329:05:35:42:018021 gpstop:master:dwadmin-[INFO]:-   Segments stopped successfully      = 80
20180329:05:35:42:018021 gpstop:master:dwadmin-[INFO]:-   Segments with errors during stop   = 0
20180329:05:35:42:018021 gpstop:master:dwadmin-[INFO]:-----------------------------------------------------
20180329:05:35:42:018021 gpstop:master:dwadmin-[INFO]:-Successfully shutdown 80 of 80 segment instances
20180329:05:35:42:018021 gpstop:master:dwadmin-[INFO]:-Database successfully shutdown with no errors reported
20180329:05:35:42:018021 gpstop:master:dwadmin-[INFO]:-Cleaning up leftover gpmmon process
20180329:05:35:42:018021 gpstop:master:dwadmin-[INFO]:-No leftover gpmmon process found
20180329:05:35:42:018021 gpstop:master:dwadmin-[INFO]:-Cleaning up leftover gpsmon processes
20180329:05:35:42:018021 gpstop:master:dwadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts
20180329:05:35:42:018021 gpstop:master:dwadmin-[INFO]:-Cleaning up leftover shared memory
上一篇:对PostgreSQL的UPDATE和DELETE外键属性思考


下一篇:Greenplum/Deepgreen空间满了数据库宕机怎么办?