Sponsored Content
Full Discussion: Postgres : pg_dump Error
Top Forums Shell Programming and Scripting Postgres : pg_dump Error Post 302223921 by jagnikam on Monday 11th of August 2008 06:29:08 PM
Old 08-11-2008
Quote:
Originally Posted by Ikon
You getting "Permission denied" so its a permission problem somewhere.
finally i got problem ..
i have two hard drive as well as two partion
/dev/sda1 contain all / folder excluding /home
/dev/sdb1 contain /home
pg_sql not able to dump data on /home but it can able to dump data on other /folders

Please help me to solve this issue now
 

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

Backup-Script for Postgres

Hi, I'm working with postgres. Now I found a script to backup my databases. # #!/bin/bash # # # setup environment PG_PORT=5432 PG_HOME=/usr/lib/postgresql/8.3 PG_VAR=/backup PG_DATA=/backup/data PG_BACKUPS=/backup/backup PG_LOGS=/backup/logs ... (6 Replies)
Discussion started by: karl_ha
6 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

How to write cron job for calling sql function database is postgres

Hi, Please help me to write cron job for calling sql function daily. I have Postgres database. (1 Reply)
Discussion started by: kulbhushan
1 Replies

5. 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

6. 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

7. UNIX for Advanced & Expert Users

How to set postgres process in monit file?

Dear Friends, I need to add the postgres process in monit file ( Debian machine ). How to add that process in monit?. If anyone know the solution for this, pls let me know. ---------- Post updated at 02:27 PM ---------- Previous update was at 12:21 PM ---------- I have found the... (0 Replies)
Discussion started by: rekha_sri
0 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

Using shell scripting for making queries on postgres sql

I have a situation where I have a list of airplanes that make a series of flights. Therefore I am looking up the different flights that each airplane makes based on a postgres sql query: select flightid from plane where airplane='DELTAx' As a result I get a series of flight numbers... (0 Replies)
Discussion started by: JSNY
0 Replies
bup-save(1)						      General Commands Manual						       bup-save(1)

NAME
bup-save - create a new bup backup set SYNOPSIS
bup save [-r host:path] <-t|-c|-n name> [-#] [-f indexfile] [-v] [-q] [--smaller=maxsize] DESCRIPTION
bup save saves the contents of the given files or paths into a new backup set and optionally names that backup set. Before trying to save files using bup save, you should first update the index using bup index. The reasons for separating the two steps are described in the man page for bup-index(1). OPTIONS
-r, --remote=host:path save the backup set to the given remote server. If path is omitted, uses the default path on the remote server (you still need to include the ':'). The connection to the remote server is made with SSH. If you'd like to specify which port, user or private key to use for the SSH connection, we recommend you use the ~/.ssh/config file. -t, --tree after creating the backup set, print out the git tree id of the resulting backup. -c, --commit after creating the backup set, print out the git commit id of the resulting backup. -n, --name=name after creating the backup set, create a git branch named name so that the backup can be accessed using that name. If name already exists, the new backup will be considered a descendant of the old name. (Thus, you can continually create new backup sets with the same name, and later view the history of that backup set to see how files have changed over time.) -f, --indexfile=indexfile use a different index filename instead of ~/.bup/bupindex. -v, --verbose increase verbosity (can be used more than once). With one -v, prints every directory name as it gets backed up. With two -v, also prints every filename. -q, --quiet disable progress messages. --smaller=maxsize don't back up files >= maxsize bytes. You can use this to run frequent incremental backups of your small files, which can usually be backed up quickly, and skip over large ones (like virtual machine images) which take longer. Then you can back up the large files less frequently. Use a suffix like k, M, or G to specify multiples of 1024, 10241024, 10241024*1024 respectively. --bwlimit=bytes/sec don't transmit more than bytes/sec bytes per second to the server. This is good for making your backups not suck up all your net- work bandwidth. Use a suffix like k, M, or G to specify multiples of 1024, 10241024, 10241024*1024 respectively. --strip strips the path that is given from all files and directories. A directory /root/chroot/etc saved with "bup save -n chroot --strip /root/chroot" would be saved as /etc. --strip-prefix=path-prefix strips the given path-prefix path-prefix from all files and directories. A directory /root/chroots/webserver saved with "bup save -n webserver --strip-path=/root/chroots" would be saved as /webserver/etc --graft=old_path=new_path a graft point old_path=new_path (can be used more than once). A directory /root/chroot/a/etc saved with "bup save -n chroots --graft /root/chroot/a/etc=/chroots/a" would be saved as /chroots/a/etc -#, --compress=# set the compression level to # (a value from 0-9, where 9 is the highest and 0 is no compression). The default is 1 (fast, loose compression) EXAMPLE
$ bup index -ux /etc Indexing: 1981, done. $ bup save -r myserver: -n my-pc-backup --bwlimit=50k /etc Reading index: 1981, done. Saving: 100.00% (998/998k, 1981/1981 files), done. $ ls /home/joe/chroots/httpd bin var $ bup index -ux /home/joe/chroots/httpd Indexing: 1337, done. $ bup save --strip -n joes-httpd-chroot /home/joe/chroots/httpd Reading index: 1337, done. Saving: 100.00% (998/998k, 1337/1337 files), done. $ bup ls joes-httpd-chroot/latest/ bin/ var/ $ bup save --strip-prefix=/home/joe/chroots -n joes-chroots /home/joe/chroots/httpd Reading index: 1337, done. Saving: 100.00% (998/998k, 1337/1337 files), done. $ bup ls joes-chroots/latest/ httpd/ $ bup save --graft /home/joe/chroots/httpd=/http-chroot -n joe /home/joe/chroots/httpd Reading index: 1337, done. Saving: 100.00% (998/998k, 1337/1337 files), done. $ bup ls joe/latest/ http-chroot/ SEE ALSO
bup-index(1), bup-split(1), bup-on(1), bup-restore(1), ssh_config(5) BUP
Part of the bup(1) suite. AUTHORS
Avery Pennarun <apenwarr@gmail.com>. Bup unknown- bup-save(1)
All times are GMT -4. The time now is 01:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy