Re: Postmaster can't stop with pg_ctl

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