Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: kill - postgresql
Top Forums Programming kill - postgresql Post 302469539 by DGPickett on Saturday 6th of November 2010 09:49:25 PM
Old 11-06-2010
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:
majid.merkava
 

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 (3 Replies)
Discussion started by: VijayHegde
3 Replies

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 (9 Replies)
Discussion started by: umen
9 Replies

3. Shell Programming and Scripting

Kill a process without using kill command

Sorry, posted the question in other forum. (0 Replies)
Discussion started by: sudhamacs
0 Replies

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. (6 Replies)
Discussion started by: sudhamacs
6 Replies

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. ... (0 Replies)
Discussion started by: majid.merkava
0 Replies

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... (3 Replies)
Discussion started by: phani4u
3 Replies

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... (6 Replies)
Discussion started by: enriquegm82
6 Replies

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... (2 Replies)
Discussion started by: ahsanpmd
2 Replies

LEARN ABOUT LINUX

gnome-session-save

gnome-session-save(1)						   User Commands					     gnome-session-save(1)

NAME

       gnome-session-save - saves or terminates the current GNOME session

SYNOPSIS

       gnome-session-save [--kill] [--gui] [gnome-std-options]

DESCRIPTION

       gnome-session-save can be used from a GNOME session to save a snapshot of the currently running applications. This session will be restored
       at your next GNOME startup session.

OPTIONS

       The following options are supported:

       --gui	       Shows a dialog when the session is saved, and reports errors in dialog boxes instead of printing to stderr.

       --kill	       Terminates the GNOME session.

       gnome-std-optionStandard options available for use with most GNOME applications.  See gnome-std-options(5) for more information.

EXAMPLES

       Example 1: Saving the user's current session

       example% gnome-session-save

       Example 2: Terminating the user's current session

       example% gnome-session-save --kill

       Example 3: Using the GUI to terminate the user's current session

       example% gnome-session-save --kill --gui

EXIT STATUS

       The following exit values are returned:

       0	Application exited successfully

       >0	Application exited with failure

FILES

       The following files are used by this application:

       /usr/bin/gnome-session-sThe command-line executable for the application.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWgnome-session 	   |
       +-----------------------------+-----------------------------+
       |Interface stability	     |External			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       gnome-std-options(5), default.session(5), gnome-smproxy(1), gnome-session(1)

NOTES

       Written by Brian Cameron, Sun Microsystems  Inc., 2003.

SunOS 5.10							    13 Jan 2003 					     gnome-session-save(1)
All times are GMT -4. The time now is 04:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy