|
portgres: cancel query keywords : psql postgres postgresql query To cancel a psql-query get the PID by SELECT * FROM pg_stat_activity; and kill the postmaster-process. To get the query and not only the database and username, add stats_command_string = true to postgresql.conf serial : 390 If you found any nonsense in this entry or want to see important improvements, I would appreatiate to receive your comments at knowledge@goldfisch.at disclaimer : all these entries are part of my very private knowledgebase that I created while solving problems. Many solutions are taken from other webpages or from usenet. There is no warranty for this entries of course. Some of the articles are even stupid and one day you might even find the name of my prefered pizza-service in here, cause I always forget about it. Remember : This is my knowledgebase. If you need professional support and are willing to pay for it just email me at pilsl@goldfisch.at For enlightment take a look at http://leblogsportif.sportnation.at |