ctrl-c - is it safe to kill a query?

Поиск
Список
Период
Сортировка
От Mark Steben
Тема ctrl-c - is it safe to kill a query?
Дата
Msg-id 20100208154107.B5764632416@mail.postgresql.org
обсуждение исходный текст
Ответы Re: ctrl-c - is it safe to kill a query?
Список pgsql-admin

Hi folks,

 

We are running psql 8.3.7 and linux 2.6.9-78.0.17.ELsmp

 

We had a situation this weekend where someone was running an update

On the psql command line and had to kill it. 

 

It is considered ‘best practice’ to use cntrl-c to do so?

 Or is there a better way?  The transaction did roll back.

 

Good to know for future reference.  Thank you.

 

 

Mark Steben | Database Administrator 
@utoRevenue® - "Keeping Customers Close" 
95D Ashley Ave, West Springfield, MA 01089
413.243.4800 x1512 (Phone) |413.732-1824 (Fax)

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Best Replication Tool
Следующее
От: Rosser Schwarz
Дата:
Сообщение: Re: Best Replication Tool