takuya koide wrote: > 4) send 'SIGSTOP' signal to postgres > # kill -SIGSTOP 3619 > # ps axuw|grep -i postgres|grep -Ev 'grep|bash|su -' > postgres 3507 0.0 1.1 21352 2804 ? S 18:48 0:00 > /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data > postgres 3509 0.0 0.2 11132 568 ? S 18:48 0:00 postgres: logger > process > postgres 3514 0.0 0.3 21352 852 ? S 18:48 0:00 postgres: writer > process > postgres 3515 0.0 0.2 12132 564 ? S 18:48 0:00 postgres: stats buffer > process > postgres 3516 0.0 0.3 11364 772 ? S 18:48 0:00 postgres: stats > collector process > postgres 3618 0.0 0.6 8476 1752 pts/3 S+ 18:54 0:00 psql template1 > postgres 3619 0.0 0.8 22012 2124 ? T 18:54 0:00 postgres: > postgres template1 [local] idle
If you "stop" a process by SIGSTOP you must make it run again with SIGCONT. Otherwise it's just not processing signals, so it'll obviously not shut down. I don't think this is a bug. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
