Thread: vacuumdb can't be canceled
Vacuumdb command can't be canceled by Control-C and VACUUM is still running. When wrong database name is specified to vacuumdb, cancellation is required to stop VACUUM FULL which runs long. Option -c of psql forget to set signal handler for 7.3 or prior. Vacuumdb have no signal handler of cancellation for 7.4devel. Kenji Sugita
Sorry, my testing was on CVS version of PostgreSQL. --------------------------------------------------------------------------- Kenji Sugita wrote: > Vacuumdb command can't be canceled by Control-C and VACUUM is still running. > When wrong database name is specified to vacuumdb, cancellation is required to > stop VACUUM FULL which runs long. > > Option -c of psql forget to set signal handler for 7.3 or prior. Vacuumdb > have no signal handler of cancellation for 7.4devel. > > > Kenji Sugita > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
Control-C works here. What platform are you on? Can you reproduce it? I just tried: psql -c 'select * from pg_class, pg_proc' test and control-C terminated the query. --------------------------------------------------------------------------- Kenji Sugita wrote: > Vacuumdb command can't be canceled by Control-C and VACUUM is still running. > When wrong database name is specified to vacuumdb, cancellation is required to > stop VACUUM FULL which runs long. > > Option -c of psql forget to set signal handler for 7.3 or prior. Vacuumdb > have no signal handler of cancellation for 7.4devel. > > > Kenji Sugita > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073