We are going through the motions of testing the backup and restore configurations of our postgres database. One idea was testing the viability of the dump file. Does anyone know of a way of testing the dump file to determine if there is any corruption in it
View 2 RepliesI want to generate core dump files from my program when it crashes. Its a pretty big process and has about 10-11 threads in it.I have followed the documentation to enable core dump by setting ulimit to unlimited etc. I quickly tried "A demo program creating a core dump" from the following webpage, which succeeds in Segfault and dumping a core file in the directory that I configured.However, I tried running my original program and caused it to crash. I did this by making calls to kill(), raise() or the same null pointer access as shown in the webpage above. In each case, my program crashed but did not generate a core dump file. Am I missing something?My program is in C++ and my environment is Redhat 9.0 (kernel 2.4.20)
Going through the "Why do I NOT get a core dump?" section on the same webpage as above, I can see two potential problems. One - there are issues with the suid/sgid (bullet # 6). I am not able to change any settings with suid because my system does not contain either /proc/sys/fs/suid_dumpable or /proc/sys/kernel/suid_dumpableTwo, my program has threads in it and the bullet # 8 is the problem.
I have used Dump Command to dump the application files. For Full backup the level 0 is working fine. For incremental backup I used the level 1 or 2 it is getting the error as
DUMP: Only level 0 dumps are allowed on a subdirectory
DUMP: The ENTIRE dump is aborted.
The code I used
===============================
#!/bin/bash
#Full Day Backup Script
#application folders backup
#test is the username
now=$(date +"%d-%m-%Y")
[Code]...
I got a backup file which first 1000 bytes are as follows:
Code:
00000000 54 41 50 45 00 00 03 00 8c 00 0e 01 00 00 00 00 |TAPE............|
00000010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
*
00000030 02 00 87 05 51 64 50 48 01 00 00 00 01 00 00 00 |....QdPH........|
[code]....
I tried to restore it:
Code:
$ restore -r -f zzz_labxxxx
Checksum error 32615101403, inode 0 file (null)
restore: Tape is not a dump tape
What application could I use or even try? The man who made the backup can't be reached anymore and we had been left with the backup.
How to create a dump of an existing file and how to restore it with command line?
View 6 Replies View RelatedDoing this: mplayer dvd://1 -v -dumpstream -dumpfile dump.vob Gives me all the audio tracks, but not the subtitles. How can I go about getting the subtitles to be included in the file dump.vob? I've tried something like: mplayer dvd://1 -v -sid 5 -dumpstream -dumpfile dump.vob (where -sid 5 was the correct subtitle) but this does not work. I'm going to use mencoder to make an .avi file (with subtiutles, obviously), so I could, as a last resort, use some other program that extracts the subtitles (suggestions?).
View 3 Replies View RelatedI have a script (below) which works ok, but I have tried to modify it as I want to keep the older files for a restore if needed. I have tried adding a date suffix to the newly created files (second lump of code), but it doesn't seem to work.I get the error:
$SOURCEDIR/p1db_$DATEVAR.sql: ambiguous redirect
The working original script:
Code:
#!/bin/bash[code].....
I'm having trouble trying to get a thread dump for tomcat. I have tried the following and none seems to work:
kill -3 <pid>
kill -QUIT <pid>
killall -3 java
Nothing shows up on screen. I also tried putting the out of the dump to a file with the > command but the file is blank.
Does the dump command back up entire file-systems or is it capable of backing up subsets of a file-system? And is tar capable of taking device names (for file systems) as input to be archived?
View 1 Replies View Relatedi just touch linux, may i know how can i convert the core dump file to a readable textfile, which include all the information, which is in core dump, such as all variables, threads information, call trace for each tasks, and so on. i know use the GDB can view this, but it won't dump all the informations to one text file. but sometimes, people want to view the core dump reason without Linux environment.
View 2 Replies View RelatedI'm trying to install a copy of Postgres using the .bin(I want pg Admin III as well which is why I'm not using apt-get). It's sitting in downloads so I did the following:
$ cd /home/ryan/Downloads
$ sudo chmod +x postgresql-9.0.4-1-linux.bin
$ ./postgresql-9.0.4-1-linux.bin
but I keep getting: -bash: ./postgresql-9.0.4-1-linux.bin: No such file or directory I did -ls and the file is there and I can't figure out how to get this installed.
I have a problem with a script i wrote, the script runs fine if manually executed however it doesn't run *fully* when executed via cron
here's the script :
Code:
#!/bin/bash
FILENAME=mysql_full_dump_`date '+%m.%d.%y'`.sql
`which mysqldump` --all-databases -uroot -p************ -h127.0.0.1 > /root/$FILENAME
RETVAL=$?
[code]....
the script resides in /root/bin and the cron entry is as follows:
Code:
0 0 * * * root "/root/bin/mysql_daily.sh"
the result is the .sql file, but it doesn't archive it.
I've been working on the setup of a FTP server on my Debian system for the whole afternoon. But I can't get it straight! Normally I get it working in just a second, but it's been a while I guess.
I installed only proftpd-basic and it's default dependencies. Should be enough right?
My configuration files are as follows:
I created the user zeitgeist, gave it a password, group and a homedir. Group of the user is nogroup and the homedir is correct with the 755 permission. My port 21 for FTP is open I tested it with nmap -p 21 [ip-address].
My Filezilla client tells me that at first he is connecting, then the connection is established, And then the connection is closed by server.
Using the following software:
Ubuntu Server 8.04
SquirrelMail 1.4.13
Postfix 2.5.1
Courier 0.59.0 (Courier-IMAP 4.3.1)
Apache2 2.2.8
I've installed a mail server per the instructions at [url].
Neither POP nor IMAP test successfully with the user that I just added after following the setup instructions.
This doesn't make any sense. I added the user to the mysql database:
Code:
And after I did that, I ran the postfix reload command. If I try to log in as firstuser@mydomain.com, which is the user I created during the setup and configuration process, it works fine.
I checked the virtual mail account's home folder, and under the mydomain.com folder, I only see a folder for firstuser. I'd create one for testuser manually, but I don't know if that'll work since it seems to contain a particular folder structure of its own.
Is there some other command that I have to run? I don't recall having to do anything additional when setting up firstuser.
Before installing Centos, I downloaded an image file and burned it to CD using InfraRecorder. It starts to run but does not complete. My machine is a new Intel Q6600 Core 2 Quad CPU with 4G of RAM. It is a 64-bit machine, and I used the 64-bit image. After Centos (which I tried first) failed, I then tried (using the same burning software):
o Slackware
o UBuntu
o gNewSense
o Knoppix
o Debian
o Fedora
o Suse
o BSD
o Solaris
0 puppy Linux
Most failed similarly to Centos. Knoppix worked fully several times, but I was not enthusiastic about installing it, and eventually (on the 5th iteration), it started to fail in a way similar to Centos, and continues so. Solaris and PuppyLinux worked. Those that failed, failed while attempting to start the 4 CPUs. Solaris and Knoppix (when it worked) succeeded in starting all 4 cpus and I could see the messages.
How to communicate what's happening during a failed boot? Finally, I hit upon the idea of photographing the screen during the failing part of the boot; the file is attached. The photo shows the screen just before it blanks, and the BIOS resets for another try. Please let me know if I can collect any other information. I would like to use Centos as a dual boot on my shiny new machine.
I'm trying to clean up an iTunes-sorted Music directory. For whatever reason, it contains a large number of folders that have album art, but no music. I'm actually more concerned about a safe way to test my removal batch, but I thought I'd paste everything I did in case it's useful to someone. Based on this thread, I came up with the following script:
Code:
#!/bin/bash
find ./*/* -type f -iregex ".*(mp3|m4a)" | sort | while read line ; do
echo "${line%/*}" >> file1
done
sort -u file1 > fileuniq
[Code]...
But I'm scared to just run this on my music folder. Is there any way to run rm in "test mode", so that I would just see verbose output, but it wouldn't actually delete anything? Failing that, does anyone see anything wrong with my plan?
I'm trying to install Squeeze onto a new DELL Vostro 1520 laptop. The Windows Device Manager says it is Realtek PCIe GBE Family Controller.
During the network card detection phase, it prompts to install missing firmware file rtl8168d-1.fw from removable media. I understand that this is a non-free blob removed from kernel v2.6.32.
I want to pick up Python3 from squeeze, meanwhile I would like to stay with lenny with all other packages. Is this possible by just modifying source.list file?
View 2 Replies View RelatedI had postgresql 8.3 running on opensuse 11.0, recently upgraded to 11.2 (so postgres is now 8.4) and have problems starting it. I make, su, then as root run:
# /etc/init.d/postgresql start
Your databases are still using the format of PostgreSQL 8.3.
Therefore a backup of the old PostgreSQL server program will be used
until you have saved and removed your old database files
See also /usr/share/doc/packages/postgresql/README.SuSE.{de,en} .
Starting PostgreSQLsu: incorrect password
[Code]...
I just installed postgresql 8.4 package on my Ubuntu 10.10 desktop. Seems to have worked fine. But what is the password for logging into the databases created by user 'postgres'?
sudo su postgres
and then
createdb
or
psql mydb
fine and it never asks me for a password. But if I want to use pgadmin3, I want to enter passwd for postgres, etc.
i have installed postgresql to my fedora10-distribution. when i would to access to this database by using the command #su postgres as is mentioned at [URL]..3/install/wiff/createcontext to install freedom , an error message is shown to tell me that user postgres does not exist. what is the likely problem.
View 15 Replies View RelatedWe have a disaster recovery solution for our database where a dump file is generated daily at 1:00 AM. We have tested importing the file, along with running another sql file that generates the appropriate database user accounts, into a database on a third-party server.
One question that came up was the following: Suppose the database crashes in the middle of the day, prior to that there were transactions that were entered into the database between the time the dump file was generated, and the crash occurred. We can restore the dump file to either the main or backup server. How can the transactions that were made between the time of the dump file and the crash be restored as well?
I installed postgres successfully but, when I press tab key, it does not autofill the available options.
View 1 Replies View RelatedI am in the process of looking to migrate my PC from Windows 7 to Ubuntu 10.10 as I like it and i find it a little quicker than Windows. One of the major failings I find at the moment is software app support. I am setting up some PostgreSQL 9.0 servers (to do streaming replication) and using pgadmin to do the management.
Under Windows this app works great, but under Ubuntu it seems the standard package only supports up to 8.4, and looks like support has been dropped for pgadmin on Ubuntu. What I can't understand is the open source movement isn't supporting itself - or is it that because 10.10 is not on LTS, they are waiting for the next version to update the package - anyone know? If its not supported then back to Windows I go, because I know the latest version works fine.
Just bought a new accounting program BasicBooks - on the install instructions (Gibberish to me) I apparently must have Postgres installed, which apparently comes with most distros. I can't find a reference to Postgres - there should be an entry in 'System Settings --> Server Settings --> Services from the main system menu', which I cannot find. Nor can I find it in the Ubuntu software centre. I did find pgAdmin III but have no idea how this works either.
View 2 Replies View RelatedI am very much interested in Postgres db.
I have installed the DBI and DBD drivers.
Created the Tables.
Can any one help me ..how to access POSTGRES through a PERL program.
Ok so I need to Search for a postgres database File on a CentOs System. Is their a command i can run in the terminal to search for postgres files?
View 2 Replies View RelatedWhile backing up/restoring bacula clients. We were getting an error regarding database tables' version. The error message is given below.. "Found 10 needs 12".
After Googling, what we found is, we have to update the postgres database for bacula. So now we are in process to update the database via the update_bacula-tables script. We are not sure, if it will solve the problem or not. We have just upgraded bacula 2.4.4 to 5.0.1. Postgres version is upgraded from 8.3 to 8.4. It is Debian 6.0 squeeze.
how to setup multiple instance of postgre server on the same machine.
View 4 Replies View RelatedWhenever i restart postgres in my server, Selinux is not letting it log anything. In /var/log/messages, it says.
Quote: Jan 28 14:15:43 dataserver kernel: audit(1264709743.263:38): avc: denied { append } for pid=5986 comm="postmaster" name="pgsql.log" dev=sda8 ino=3932166 scontext=root:system_r: postgresql_t tcontext=root: object_r:var_log_t tclass=file
Jan 28 14:15:43 dataserver kernel: audit(1264709743.263:39): avc: denied { append } for pid=5986 comm="postmaster" name="pgsql.log" dev=sda8 ino=3932166 scontext=root:system_r: postgresql_t tcontext=root: object_r:var_log_t tclass=file
I cannot disable SeLinux in this server.