11-10-2009
Need help on Shell script for database maintainace..
Hi All,
I have to perform some tasks for database maintainace. I am using postgresql on RHEL 4.4.
1) I have to run "vacuumedb" on the database as postgres user.
2) I have to reindex the database as postgres user.
Now i want to write shell script to do these tasks one after another. Please any one suggest me, how to write a shell script..
Thanks in advance..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
Language like C,Java can interact with database..and can use database information .. can a shall script do this?
if yes thn plz guide me.....
thankx (7 Replies)
Discussion started by: johnray31
7 Replies
2. Shell Programming and Scripting
Hi ,
I am new to linux and also also to shell scripting.
I have one shell script which unpacks .tgz file and install software on machine.
When this script runs I want to insert id,filename,description(which will be in readme file),log(which will be in log file) and name of unpacked folder... (1 Reply)
Discussion started by: ring
1 Replies
3. Shell Programming and Scripting
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (2 Replies)
Discussion started by: alokjyotibal
2 Replies
4. Shell Programming and Scripting
Input for the program is a text file consisting of n no. of items.
I want search each item in a database and the existing parts should go to FOUND folder and the others should go to NOTFOUND folder.
Pls help me in this.
Thank u. (1 Reply)
Discussion started by: smarty86
1 Replies
5. Shell Programming and Scripting
Hi
when i am calling the shell script with two parameter like id and date it works fine.But the same shell script is call by java application it gives the error as shown below
Thu Jan 8 04:13:22 EST 2009|The Get Segment Process Failed: SP2-0306:
Invalid option.
Usage: CONN where <logon>... (1 Reply)
Discussion started by: ravi214u
1 Replies
6. Shell Programming and Scripting
hi,
I have a script that will logon to a database siebel and do the select query and then get the result in command prompt of unix.Below the script.
#!/bin/ksh
. $HOME/conf/systemProperties/EnvSetup.properties
#set -x
while read i
do
echo $i
connect1=`sqlplus -silent... (1 Reply)
Discussion started by: ali560045
1 Replies
7. Shell Programming and Scripting
Hi all,
I am satyakiran , i am new to the forum. i never done shell scripts for connecting to the data base (oracle) and fetching the data from the database( thru sql select statements ) i want to know
1. how to connect to the data base(oracle) using shell script
2. how to retrieve data... (8 Replies)
Discussion started by: satyakiran
8 Replies
8. Shell Programming and Scripting
Hi all,
This is my first ever post to any forum so, dont let this go in vain...........:)
Here is the scenario........
I have logged into the unix where oracle_sid is initialized for some X database in the .profile.
I have a unix script where some sql query which fetches data from X... (3 Replies)
Discussion started by: sachinkl
3 Replies
9. Shell Programming and Scripting
Hi Unix Gurus,
I have a requirement to write a script, Oracle DB gets referesh every 6hrs, hence we need write a script to connect to the database , if it connects it should generate a file to proceed the next job application or when an error when connectiong to DB it should not generate any... (8 Replies)
Discussion started by: bshivali
8 Replies
10. Shell Programming and Scripting
Hi All,
I am newbie to unix shell scripting. I want to connect to oracle database using shell script. I know how to connect DB using user name and password but my question is if my password is having '@' sign then how to connect.
I have tried like below,
cnt=`sqlplus -s /nolog << EOFSQL
... (3 Replies)
Discussion started by: pmotewar
3 Replies
LEARN ABOUT DEBIAN
wiki-toolkit-revert-to-date
WIKI-TOOLKIT-REVERT-TO-DATE(1p) User Contributed Perl Documentation WIKI-TOOLKIT-REVERT-TO-DATE(1p)
NAME
wiki-toolkit-revert-to-date - Revert the state of a Wiki::Toolkit instance to an earlier point in time.
SYNOPSIS
# Removes any changes made to a Wiki::Toolkit instance since a given date
# (and optionally time), restoring it to the state at that point.
wiki-toolkit-revert-to-date --type postgres
--name mywiki
--user wiki
--pass wiki
--host 'db.example.com'
--port 1234
--date 2007-01-05
--time 11:23:21
DESCRIPTION
Takes three mandatory arguments:
type
The database type. Should be one of 'postgres', 'mysql' and 'sqlite'.
name
The database name.
date
The date to revert the state back to, in the format YYYY-MM-DD
five optional arguments:
time
The time (on the specified date) to revert the state back to, in the format hh:mm:ss. If not specified, will use midnight.
user
The user that connects to the database. It must have permission to create and drop tables in the database.
pass
The user's database password.
host
The hostname of the machine the database server is running on (omit for local databases).
port
The port number that the database server is expecting connections to.
AUTHOR
Nick Burch
COPYRIGHT
Copyright (C) 2006 Nick Burch. All Rights Reserved.
This code is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
Wiki::Toolkit
perl v5.14.2 2011-09-25 WIKI-TOOLKIT-REVERT-TO-DATE(1p)