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
推荐阅读
-
Android输入法与表情面板切换时的界面抖动问题解决方法
-
困扰JSP的一些问题与解决方法
-
解决MySQL Sending data导致查询很慢问题的方法与思路
-
Weblogic 10下JSP el与ognl的问题与解决方法 博客分类: Java JSPWeblogicWebworkWebXML
-
解决MySQL Sending data导致查询很慢问题的方法与思路
-
python2.7的编码问题与解决方法
-
sql server 2000阻塞和死锁问题的查看与解决方法
-
Python2.x中str与unicode相关问题的解决方法
-
Javascript 浮点运算的问题分析与解决方法_javascript技巧
-
debugger Optimizer与Debugger兼容性问题的解决方法