02-13-2013
bakunin thanks for your response!
At the moment I dont care for anything inside this database. Dropping it will automatically free all the space used?
10 More Discussions You Might Find Interesting
1. Linux
Hello,
My apache was working before, but not anymore. When I try to run this service this way: service httpd start
I get the following error:
Starting httpd: /usr/sbin/httpd: error while loading shared libraries: libpcre.so.0: cannot open shared object file: Permission denied
Anyone... (2 Replies)
Discussion started by: HSN
2 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I am working on device drivers.Once If register a device i'll get one major no. If i unregister and register again i'll get a different major no.What i have to do to get same major no. each time :( (0 Replies)
Discussion started by: Agnello
0 Replies
3. HP-UX
Hello, I have 2 hp-ux both running 11.23, I have move one of a harddisk from "UNIX A" to "UNIX B", so how can I read back the data in "UNIX B"?
Thanks (5 Replies)
Discussion started by: zetadhell
5 Replies
4. AIX
Hi,
What is the purpose of this connector ?
I attached picture of it.
In docs it is called "Ethernet connector".
thanks
Vilius (1 Reply)
Discussion started by: vilius
1 Replies
5. Shell Programming and Scripting
Hi.
I have these two variables:
My objective here is to reuse that $file_name variable again and again by resetting the $cv value.
for example, if i reissue the cv="$(print 'CV01')" command, thus $file_name is now should be "CP99978_CV01.TXT", not "CP99978_CV01.TXT" anymore.
How I'm... (7 Replies)
Discussion started by: aimy
7 Replies
6. AIX
Hi,
I have done NIM restoration via nim_bosinst a lot of times but I have some doubts on restoring a server which is clustered specifically HACMP. Previously, I don't know the trend but after doing a nim_bosinst, I can see the client's hostname is back to "localhost" rather than its original... (0 Replies)
Discussion started by: depam
0 Replies
7. Shell Programming and Scripting
I am newbe to unix.
I have a very serious problem on my server.
I have a java application running, and all day on Monday morning, the process that is associated with this java is locked.
Usually I doing a shutdown by the shutdown java command , you have to kill the process with the kill-kill... (1 Reply)
Discussion started by: jjoottaa
1 Replies
8. Emergency UNIX and Linux Support
I have a LUN (From HP-Storage VA7110) that is claimed on 2 servers, but is in used in one of the VG on Server-1 .
Now I want to shut Server-1 and re-use that LUN on server-2 .
Server-1
Path-1 : /dev/rdsk/c4t0d1
Path-2: /dev/rdsk/c6t0d1
Server-2
Path-1: /dev/rdsk/c5t0d1
Path-2:... (8 Replies)
Discussion started by: Shirishlnx
8 Replies
9. Solaris
Hi,
Can you help me on booting x86 server configured under VxVM. Server boots fine normally from both the disks but if I try to boot server from mirror disk without starting veritas, then it does not boot.
vxplex -g rootdg dis var-02
vxplex -g rootdg dis swapvol-02
vxplex -g rootdg dis... (2 Replies)
Discussion started by: milindphanse604
2 Replies
10. Programming
I have a collection of format strings for sscanf, such as
"%02d%*1s%02d%*1s%02d"
to read in certain formatted strings, such as dates, times, etc.
I wonder if there is a way to use them in printf without some changes? The example above would not work - at least I can't think of any ways to... (4 Replies)
Discussion started by: migurus
4 Replies
LEARN ABOUT CENTOS
drop_database
DROP
DATABASE(7) PostgreSQL 9.2.7 Documentation DROP DATABASE(7)
NAME
DROP_DATABASE - remove a database
SYNOPSIS
DROP DATABASE [ IF EXISTS ] name
DESCRIPTION
DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the directory containing the data. It can only
be executed by the database owner. Also, it cannot be executed while you or anyone else are connected to the target database. (Connect to
postgres or any other database to issue this command.)
DROP DATABASE cannot be undone. Use it with care!
PARAMETERS
IF EXISTS
Do not throw an error if the database does not exist. A notice is issued in this case.
name
The name of the database to remove.
NOTES
DROP DATABASE cannot be executed inside a transaction block.
This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the program dropdb(1)
instead, which is a wrapper around this command.
COMPATIBILITY
There is no DROP DATABASE statement in the SQL standard.
SEE ALSO
CREATE DATABASE (CREATE_DATABASE(7))
PostgreSQL 9.2.7 2014-02-17 DROP DATABASE(7)