Sponsored Content
Full Discussion: Postgresql Database Corrupt
Special Forums UNIX and Linux Applications High Performance Computing Postgresql Database Corrupt Post 302769573 by DGPickett on Tuesday 12th of February 2013 04:15:11 PM
Old 02-12-2013
If the primary files and any mirrors are gone, restore from the transaction logs is usually the only path.
 

9 More Discussions You Might Find Interesting

1. Cybersecurity

Security Databases are corrupt. HELP!!

Help! SCO Unix 5.05. A relatievely new system went down on me today. I got the dreaded error: Out of Space on Device (1/42). I was able to clear up some space in the /tmp directory, however, when I try to boot, the system prompts me to go into single user mode and I get the... (2 Replies)
Discussion started by: gseyforth
2 Replies

2. UNIX for Dummies Questions & Answers

I got a corrupt /etc/inittab file....what next?

Hi guys, For some reason a client has given us a Sun Netra T1 with Solaris 8 to administer for them. That's always good business. However, the other day we rebooted the machine and to our amazement, after doing the preliminary hardware tests, we got an error messgae saying that /etc/inittab was... (3 Replies)
Discussion started by: Ivo
3 Replies

3. UNIX for Dummies Questions & Answers

Causing a disk to be corrupt

Hmm, how to ask this without sounding too malicious... How might one go about causing a disk corruption in OS X specifically or via the command line in UNIX in general? Doesnt matter the severity of the problem, I just want to scare the person a little, then fix the problem for them. Any... (1 Reply)
Discussion started by: Yummator
1 Replies

4. HP-UX

Corrupt Member File

I have been fine adding/removing printers up until this week. Now when I go to add a new remote printer I get "corrupted member file". I go to /etc/lp/member and the byte count on the new printer name is 0. I VI the file and put /dev/null in to make it the correct size and it all looks fine and... (2 Replies)
Discussion started by: astout
2 Replies

5. Shell Programming and Scripting

Script to connect to PostgreSQL database

Hi All, Has anyone of you connected to a remote PostgreSQL database through a shell/perl script. Can you please let me know the steps involed? Thanks. Rahul. (0 Replies)
Discussion started by: rahulrathod
0 Replies

6. Solaris

How to corrupt a superblock?

I need to corrupt a superblock of a mounted device in a soalris m/c and check recovery from an alternate superblock. How can this be done? (2 Replies)
Discussion started by: sujathan
2 Replies

7. HP-UX

corrupt disk

Hallo Friends, I have application X running on hpux 11.11 and oracle 9i release 2. I recently had a hardware failure on disk /dev/dsk/c2t0d0 Below is the systemlog file : root@a7dmc:/var/adm/syslog > /opt/resmon/bin/resdata -R 155713541 -r /storage/events/enclosures/gazemon/0_1_1_0.0.0... (11 Replies)
Discussion started by: kekanap
11 Replies

8. Shell Programming and Scripting

Script causing database corrupt

Hi, Closing the thread (3 Replies)
Discussion started by: dbashyam
3 Replies

9. Shell Programming and Scripting

Setting up postgreSql database

Hi I have a small bash script which I want to run on an Amazon EC2 Ubuntu instance for setting up a postgreSQL database: #!/bin/bash USERNAME='postgres' start=$SECONDS TMP_DIR=/local/test/4g4d PORT=23456 rm -rf $TMP_DIR/db mkdir -p $TMP_DIR/ echo "creating database..."... (3 Replies)
Discussion started by: Helveticus
3 Replies
bup-restore(1)						      General Commands Manual						    bup-restore(1)

NAME
bup-restore - extract files from a backup set SYNOPSIS
bup restore [--outdir=outdir] [-v] [-q] DESCRIPTION
bup restore extracts files from a backup set (created with bup-save(1)) to the local filesystem. The specified paths are of the form /branch/revision/path/to/file. The components of the path are as follows: branch the name of the backup set to restore from; this corresponds to the --name (-n) option to bup save. revision the revision of the backup set to restore. The revision latest is always the most recent backup on the given branch. You can dis- cover other revisions using bup ls /branch. /path/to/file the original absolute filesystem path to the file you want to restore. For example, /etc/passwd. Note: if the /path/to/file is a directory, bup restore will restore that directory as well as recursively restoring all its contents. If /path/to/file is a directory ending in a slash (ie. /path/to/dir/), bup restore will restore the children of that directory directly to the current directory (or the --outdir). If the directory does not end in a slash, the children will be restored to a subdirectory of the current directory. See the EXAMPLES section to see how this works. OPTIONS
-C, --outdir=outdir create and change to directory outdir before extracting the files. -v, --verbose increase log output. Given once, prints every directory as it is restored; given twice, prints every file and directory. -q, --quiet don't show the progress meter. Normally, is stderr is a tty, a progress display is printed that shows the total number of files restored. EXAMPLE
Create a simple test backup set: $ bup index -u /etc $ bup save -n mybackup /etc/passwd /etc/profile Restore just one file: $ bup restore /mybackup/latest/etc/passwd Restoring: 1, done. $ ls -l passwd -rw-r--r-- 1 apenwarr apenwarr 1478 2010-09-08 03:06 passwd Restore the whole directory (no trailing slash): $ bup restore -C test1 /mybackup/latest/etc Restoring: 3, done. $ find test1 test1 test1/etc test1/etc/passwd test1/etc/profile Restore the whole directory (trailing slash): $ bup restore -C test2 /mybackup/latest/etc/ Restoring: 2, done. $ find test2 test2 test2/passwd test2/profile SEE ALSO
bup-save(1), bup-ftp(1), bup-fuse(1), bup-web(1) BUP
Part of the bup(1) suite. AUTHORS
Avery Pennarun <apenwarr@gmail.com>. Bup unknown- bup-restore(1)
All times are GMT -4. The time now is 12:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy