02-19-2010
Thanks fpmurphy...i will try to find out such scripts..iam very new to the Linux admin role.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Does anyone have an example of a ksh script that executes a Sybase stored procedure, via the ISQL command, and can detect a deadlock and loop until the process completes successfully? I'm a little confused on where to start.
Thanks in advance for any assistance you can provide. (0 Replies)
Discussion started by: BCarlson
0 Replies
2. UNIX for Dummies Questions & Answers
For vertitas netbackup 6.0
I have media server :Solaris
Client server: Windows
I want to restart the netbackup service on the media server .
plz suggest ASAP. (1 Reply)
Discussion started by: saurabh84g
1 Replies
3. Shell Programming and Scripting
Hello, I am trying to write a script which will monitor few processes(winbind) for cpu utilization, If the process consumes more than say 99% cpu for 3 minutes, I want to run a script to restart the service which forks the process.
---------- Post updated at 11:21 AM ---------- Previous update... (5 Replies)
Discussion started by: linuxaddict7
5 Replies
4. Shell Programming and Scripting
I have a service that are not 100% stable and stops from time to time.
So I have a script that do restart the service if it does not run.
This script works win on Ubuntu 9.04 but will not start the service in Ubuntu 10.10
If I run the part that do starts the service from CLI, it starts... (2 Replies)
Discussion started by: Jotne
2 Replies
5. UNIX for Advanced & Expert Users
I'm becoming a dying breed where I work. More and more sys admins are advocating automatically restarting failed services such as tomcat, jboss, etc. I've always been against doing this except with buggy apps that can't be fixed or avoided.
My main argument is that I feel it's a trick used by... (9 Replies)
Discussion started by: mglenney
9 Replies
6. Shell Programming and Scripting
Hi All,
Requirement : I need to check for some services in my environment and restart the service if its not running.
I have written script to check the script if its running or not. While if its not running i need to restart it using ./start command. But it will ask for password prompt and i... (4 Replies)
Discussion started by: pradeepbaliga
4 Replies
7. Shell Programming and Scripting
Can any one help me with a script to restart secondary server and sync data in it..
smsc101-0:ssh smsc101-1 "invoke-rc.d smsc restart"
pwd:***
smsc101-0:rsync -avz /usr/local/smsc/data smsc101-1:/usr/local/npac/data (1 Reply)
Discussion started by: chinuku
1 Replies
8. SuSE
Hi,
Beside using crontab, what is other application we can set it? Normally I check using command crontab -l.
Any other path I need to check? Please guide me.
Thanks. (2 Replies)
Discussion started by: mzainal
2 Replies
9. Red Hat
Hello
How do I restart init.d ?? (centos 6.5)
Thanks (2 Replies)
Discussion started by: mnnn
2 Replies
10. Shell Programming and Scripting
I want the tomcat to restart when java goes 100% cpu utilize and remain on this , Get pid kill and start tomcat .
top | grep java
We can get pid and cpu utilize , But how can we do on run time.
Please use code tags as required by forum rules! (1 Reply)
Discussion started by: kaushik02018
1 Replies
LEARN ABOUT CENTOS
drop_role
DROP
ROLE(7) PostgreSQL 9.2.7 Documentation DROP ROLE(7)
NAME
DROP_ROLE - remove a database role
SYNOPSIS
DROP ROLE [ IF EXISTS ] name [, ...]
DESCRIPTION
DROP ROLE removes the specified role(s). To drop a superuser role, you must be a superuser yourself; to drop non-superuser roles, you must
have CREATEROLE privilege.
A role cannot be removed if it is still referenced in any database of the cluster; an error will be raised if so. Before dropping the role,
you must drop all the objects it owns (or reassign their ownership) and revoke any privileges the role has been granted. The REASSIGN OWNED
(REASSIGN_OWNED(7)) and DROP OWNED (DROP_OWNED(7)) commands can be useful for this purpose.
However, it is not necessary to remove role memberships involving the role; DROP ROLE automatically revokes any memberships of the target
role in other roles, and of other roles in the target role. The other roles are not dropped nor otherwise affected.
PARAMETERS
IF EXISTS
Do not throw an error if the role does not exist. A notice is issued in this case.
name
The name of the role to remove.
NOTES
PostgreSQL includes a program dropuser(1) that has the same functionality as this command (in fact, it calls this command) but can be run
from the command shell.
EXAMPLES
To drop a role:
DROP ROLE jonathan;
COMPATIBILITY
The SQL standard defines DROP ROLE, but it allows only one role to be dropped at a time, and it specifies different privilege requirements
than PostgreSQL uses.
SEE ALSO
CREATE ROLE (CREATE_ROLE(7)), ALTER ROLE (ALTER_ROLE(7)), SET ROLE (SET_ROLE(7))
PostgreSQL 9.2.7 2014-02-17 DROP ROLE(7)