The shell-scripting tag has no wiki summary.
1
vote
1answer
29 views
PostgreSQL - partial dump of large orbjects (pg_largeobject table)
Context : Our web-app is like a collaboration platform where you can share files, appointments, survey and so on. An instance of this web-app is divided in communities, each one is independent to each ...
0
votes
1answer
20 views
How do you dump specific table(s)?
Hi i have a shell script for doing a selected databases backup.
Now my requirement is i wanted to take a particular tables in a database to be backed up.
Each database backup need to be created in ...
0
votes
2answers
34 views
Write output from dynamic queries in PL/pgSQL to CSV file
PG_CMD="psql -d portal -U portal -c "
PG_CMD_TP="psql -d portal -U portal -t -P format=unaligned -c "
abc()
{
$PG_CMD "
DO \$$
DECLARE
srowdata record;
...
0
votes
1answer
23 views
Shell script for partial table backup
I have multiple database in my MYSQL server and i want to take some particular tables backup from each database.
can anyone help me in writting a shell script for this scenario.
0
votes
0answers
17 views
Failover_command in pgpool is not working?
I have setup the pgpool with load balancing and failover mode.
Following is my failover_command='/usr/local/etc/failover.sh %d %P %H %R'
The following is the script:
!/bin/bash -x
FALLING_NODE=$1 ...
0
votes
1answer
27 views
dynamic postgres inside shell script not working
PG_CMD="psql -d portal -U portal -c "
PG_CMD_TP="psql -d portal -U portal -t -P format=unaligned -c "
abc()
{
$PG_CMD "
DO \$$
BEGIN
select * from customer;
...
0
votes
1answer
59 views
Running Oracle Export Utility within a Shell script
I have wasted a lot of time on this. Any ideas of what I am doing wrong here?
Script in bash
#!/usr/bin/bash
.
.
.
/export/home/app/oracle/product/10.2.0/bin/exp $uname/$passw \
...
0
votes
0answers
43 views
Insert values from one database table to other database table through shell scripting
I am working with 2 databases say logdb.db and logdb2.db .
I have created a table named Original in logdb.db Sqlite database such as follows :
CREATE TABLE Original (s_id INT PRIMARY KEY NOT NULL ...
0
votes
0answers
163 views
pgpool-II doesn't execute my failover script
I have been installed pgpool-II 3.3.4 from source. I have two pgpool nodes and I also used the watchdog configuration to get a pgpool services with High Availability. When I stop one, the other wake ...
0
votes
0answers
147 views
How to redirect a SQL command Output in shell script?
I want to run a shell script for some group of mysql commands and the result of those commands should be saved in separate o/p file. The o/p file should contains both the query and its result.
...
1
vote
1answer
53 views
mysqldump - select table in database only if it contains a specific string
(I'm new to Database Administrators, and am not a Database Administrator. However I originally asked this question on Stack Overflow (here) but didn't get any answers. Sorry if this is not the right ...
0
votes
1answer
70 views
How do I list all databases and tables using psql in a pipable format? [duplicate]
This question deals with getting a list. So I get this:
$ psql --list
List of databases
Name | Owner | Encoding | Collate | Ctype | ...
0
votes
0answers
2k views
execute .sql script inside an anonymous pl/sql block which is invoked by a shell script
I got a shell script which connects to SQLPLUS and executes the .sql file like below:
read a
x=`echo $a | cut -d , -f 1`
y=`echo $a | sed 's/.*,//'`
c=`echo $USER | cut -c -2`"OPR"`echo $USER | ...
