欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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

程序员文章站 2022-06-21 20:59:45
首先介绍一下背景,在测试deepgreen(greenplum升级版)时,pgbench并发数设置过多,导致数据库卡死了,在进行连接、重启、关闭时,都报同样的错误:psql: fatal: the...

首先介绍一下背景,在测试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