Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Backup-Script for Postgres
Top Forums Shell Programming and Scripting Backup-Script for Postgres Post 302381416 by karl_ha on Friday 18th of December 2009 05:39:13 AM
Old 12-18-2009
sed 's/(/\\(/g'`
Code:
sed 's/(/\\(/g'`

Sorry, it's not working.

Code:
Fr 18. Dez 11:03:33 CET 2009: Script ./backupscript starting
Fr 18. Dez 11:03:34 CET 2009: Backing up database 'alktemplate' to '/backup/backup/20091218/backup.20091218_110334.alktemplate.tar.bz2'
Fr 18. Dez 11:03:34 CET 2009: Backing up database 'alktemplate' to '/backup/backup/20091218/backup.20091218_110334.alktemplate.tar.bz2' complete
Fr 18. Dez 11:03:34 CET 2009: Backing up schema 'information_schema' of database 'alktemplate' to '/backup/backup/20091218/backup.20091218_110334.alktemplate.information_schema.tar.bz2'
Fr 18. Dez 11:03:34 CET 2009: Backing up schema 'information_schema' of database 'alktemplate' to '/backup/backup/20091218/backup.20091218_110334.alktemplate.information_schema.tar.bz2' complete
Fr 18. Dez 11:03:34 CET 2009: Backing up schema 'pg_catalog' of database 'alktemplate' to '/backup/backup/20091218/backup.20091218_110334.alktemplate.pg_catalog.tar.bz2'
Fr 18. Dez 11:03:35 CET 2009: Backing up schema 'pg_catalog' of database 'alktemplate' to '/backup/backup/20091218/backup.20091218_110334.alktemplate.pg_catalog.tar.bz2' complete
Fr 18. Dez 11:03:35 CET 2009: Backing up schema 'pg_toast' of database 'alktemplate' to '/backup/backup/20091218/backup.20091218_110335.alktemplate.pg_toast.tar.bz2'
Fr 18. Dez 11:03:35 CET 2009: Backing up schema 'pg_toast' of database 'alktemplate' to '/backup/backup/20091218/backup.20091218_110335.alktemplate.pg_toast.tar.bz2' complete
Fr 18. Dez 11:03:35 CET 2009: Backing up schema 'pg_toast_temp_1' of database 'alktemplate' to '/backup/backup/20091218/backup.20091218_110335.alktemplate.pg_toast_temp_1.tar.bz2'
Fr 18. Dez 11:03:35 CET 2009: Backing up schema 'pg_toast_temp_1' of database 'alktemplate' to '/backup/backup/20091218/backup.20091218_110335.alktemplate.pg_toast_temp_1.tar.bz2' complete
Fr 18. Dez 11:03:35 CET 2009: Backing up schema 'public' of database 'alktemplate' to '/backup/backup/20091218/backup.20091218_110335.alktemplate.public.tar.bz2'
Fr 18. Dez 11:03:36 CET 2009: Backing up schema 'public' of database 'alktemplate' to '/backup/backup/20091218/backup.20091218_110335.alktemplate.public.tar.bz2' complete
Fr 18. Dez 11:03:36 CET 2009: Backing up schema '(5' of database 'alktemplate' to '/backup/backup/20091218/backup.20091218_110336.alktemplate.(5.tar.bz2'
pg_dump: SQL command failed
pg_dump: Error message from server: FEHLER:  ungültiger regulärer Ausdruck: parentheses () not balanced
pg_dump: The command was: SELECT oid FROM pg_catalog.pg_namespace n
WHERE n.nspname ~ '^((5)$'

shell & sed is still new for me.
Last edited by pludi; 12-21-2009 at 09:38 AM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how will i connect postgres database from unix shell script

I have got the solution so just closing this issue. (3 Replies)
Discussion started by: jambesh
3 Replies

2. Shell Programming and Scripting

Postgres : pg_dump Error

hi friends, i have script to take backup of postgresql server ....i am getting error like access denied myscript.sh sendEmail=/home/backup/scripts/sendEmail.pl DAY=`/bin/date +%d-%m-%y` DIR=/home/backup/psql/$DAY test -d $DIR | mkdir -p $DIR dblist="test test1 postgres" for db in... (8 Replies)
Discussion started by: jagnikam
8 Replies

3. Shell Programming and Scripting

testing postgres connection in shell script

I have a script that does db query in postgres. I'm trying to put in some error checking in the script. I keep running into the password prompt problem where when invalid credentials/or database is put it, it would prompt me for a password which hangs the script. Is there a way that I can check for... (0 Replies)
Discussion started by: zerofire123
0 Replies

4. Shell Programming and Scripting

help copy *.txt to postgres

hi all, a have problem to load *.txt to postgres my database: id_list_ip (nextval) list_ip (varchar) txt file (list_ip.txt) hasilping_10.8.248.1 hasilping_119.110.112.226 hasilping_119.110.125.33 hasilping_125.22.1.25 hasilping_192.168.2.1 hasilping_202.73.96.70 script... (3 Replies)
Discussion started by: adi0926
3 Replies

5. Shell Programming and Scripting

rsync backup mode(--backup) Are there any options to remove backup folders on successful deployment?

Hi Everyone, we are running rsync with --backup mode, Are there any rsync options to remove backup folders on successful deployment? Thanks in adv. (0 Replies)
Discussion started by: MVEERA
0 Replies

6. Shell Programming and Scripting

Help with Backup Shell Script for Network Device Configuration backup

HI all, im new to shell scripting. need your guidence for my script. i wrote one script and is attached here Im explaining the requirement of script. AIM: Shell script to run automatically as per scheduled and backup few network devices configurations. Script will contain a set of commands... (4 Replies)
Discussion started by: saichand1985
4 Replies

7. Shell Programming and Scripting

Postgres in Linux

I have this 15 postgres sql queries similar to below to run in linux... Its taking a lot of time to run (3hours) . can any one plz guide me how can i reduce the time of execution execute 'insert into cc.rpt_cons_sub_ccdb_data(report_date, server_name, report_type, count) select... (3 Replies)
Discussion started by: nikhil jain
3 Replies

8. Shell Programming and Scripting

Script for removing Postgres

I made a script to remove Postgres if this is already installed on your system. I have a other script to install Postgres, so this script can be used before you going to install Postgres. Do you like this script? I would love to hear feedback. #!/bin/bash # #################################... (2 Replies)
Discussion started by: dannyvdberg
2 Replies

9. Shell Programming and Scripting

Taking information from a postgres sql query and putting it into a shell script array

I have a postgres sql statement that is the following: select age from students; which gives me the entries: Age --- 10 15 13 12 9 14 10 which is about 7 rows of data. Now what I would like to do with this is use a shell script to create an array age. As a results... (3 Replies)
Discussion started by: JSNY
3 Replies

LEARN ABOUT DEBIAN

bbackupd-config

BBACKUPD-CONFIG(8)						    Box Backup							BBACKUPD-CONFIG(8)

NAME

       bbackupd-config - Box Backup client daemon configuration file generator

SYNOPSIS

       bbackupd-config config-dir backup-mode account-num server-hostname working-dir backup-dir [backup-dir ...]

DESCRIPTION

       The bbackupd-config script creates configuration files and client certificates. It takes at least six parameters:

       config-dir
	   Configuration directory. Usually /etc/box.

       backup-mode
	   Either lazy or snapshot.

       account-num
	   The client account number. This is set by the bbstored administrator.

       server-hostname
	   The hostname or IP address of the bbstored server.

       working-dir
	   A directory to keep temporary state files. This is usually something like /var/bbackupd. This can be changed in bbackupd.conf later on
	   if required.

       backup-dir
	   A space-separated list of directories to be backed up. Note that this does not traverse mount points.

FILES

       /etc/box/bbackupd.conf

       /etc/box/bbackupd/NotifySysAdmin.sh

SEE ALSO

       bbackupd.conf(5), bbackupd(8), bbackupctl(8)

AUTHORS

       Ben Summers

       Per Thomsen

       James O'Gorman

Box Backup 0.11 						    10/28/2011							BBACKUPD-CONFIG(8)
All times are GMT -4. The time now is 08:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy