kill - postgresql Post: 302469539

Sponsored Content

Top Forums Programming kill - postgresql Post 302469539 by DGPickett on Saturday 6th of November 2010 09:49:25 PM

11-06-2010

Registered User

Often runaway RDBMS commands have to be killed by another session, as they do not come back to the client socket for data until they finish. It helps to have an extra client open. Sometimes you have to be dba/sa to kill the bad session. Sometimes the RDBMS can be configured with limits so they clear themselves eventually.

This User Gave Thanks to DGPickett For This Post:

DGPickett

View Public Profile for DGPickett

Find all posts by DGPickett

8 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

When kill doesnt work, how to kill a process ?

Hi All, I am unable to kill a process using kill command. I am using HP-UX system. I have tried with kill -9 and i have root privilages. How can i terminate this daemon ? ? ? Regards, Vijay Hegde

2. Programming

kill(0,-9) don't kill the process

Hi all i have simple c program , when i wish to kill the app im using kill(0,-9) , but it seams this command don't do any thing and the program. just ignore it . what im doing wrong here ? im using HP-UX ia64 Thanks

3. Shell Programming and Scripting

Kill a process without using kill command

Sorry, posted the question in other forum.

4. Linux

Kill a process without using kill command

I want to Kill a process without using kill command as i don't have privileges to kill the process. I know the pid and i am using Linux 2.6.9 OS.

5. Programming

SQL Functions - PostgreSQL

Hi guys. I have some questions about SQL functions in postgresql: 1. Can a SQL function call another SQL function? 2. How about recursive calls? 3. Consider we have function that has a varchar argument. CREATE FUNCTION func(varchar) RETURN void AS $$ some SQL queries. ...

6. Solaris

Postgresql installation

Hi all, I want to install two postgreql 8.3.5 instances on same servers. already one instalce is running on default port and i need it to be installed on another port.. How ever i achived installing the second instance.. but the problem is if i create a new user using createuser in the newly...

7. Shell Programming and Scripting

Kill an specific process ID using the KILL and GREP commands

Good afternoon I need to KILL a process in a single command sentence, for example: kill -9 `ps -aef | grep 'CAL255.4ge' | grep -v grep | awk '{print $2}'` That sentence Kills the process ID corresponding to the program CAL255.4ge. However it is possible that the same program...

8. High Performance Computing

Postgresql Database Corrupt

I am managing a linux cluster which has been build on Platform Cluster Manager PCM 1.2.1) from IBM Platform Computing. Unfortunately somebody deteled data files of postgresql from /var/lib directory. I somehow managed to start the postmaster service again, but all the administrative commands of...

8 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

When kill doesnt work, how to kill a process ?

Discussion started by: VijayHegde

2. Programming

kill(0,-9) don't kill the process

Discussion started by: umen

3. Shell Programming and Scripting

Kill a process without using kill command

Discussion started by: sudhamacs

4. Linux

Kill a process without using kill command

Discussion started by: sudhamacs

5. Programming

SQL Functions - PostgreSQL

Discussion started by: majid.merkava

6. Solaris

Postgresql installation

Discussion started by: phani4u

7. Shell Programming and Scripting

Kill an specific process ID using the KILL and GREP commands

Discussion started by: enriquegm82

8. High Performance Computing

Postgresql Database Corrupt

Discussion started by: ahsanpmd