General :: PostgreSql Error "database Disk Image Is Malformed" After Db Dump
Dec 9, 2010
i created a db_dump from PostgreSql-8.2 and trying to dump it into PostgreSql-8.4 new install. 2 of the 3 databases are fine, except for minor issues, but the 3rd database is giving me the following error message when i start a service calling on it, assist: "database disk image is malformed"
View 1 Replies
ADVERTISEMENT
Nov 15, 2009
I get this:
database disk image is malformed
View 2 Replies
View Related
Apr 2, 2010
I was installing a new system today and received this error message in terminal.
Error: database disk image is malformed
Since I got this error I can not install anything on the system nor do updates or upgrades.
I tried "yum clean all" and get no errors from that but still can't install via yum
View 1 Replies
View Related
Jun 29, 2010
I have such trouble with YUM:
$ sudo yum update
Total 807 kB/s | 192 MB 04:03
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Traceback (most recent call last): .....
File "/usr/lib/python2.6/site-packages/yum/sqlutils.py", line 166, in executeSQLQmark
return cursor.execute(query)
sqlite3.DatabaseError: database disk image is malformed
I already try clean yum cache and remove checksum data, rebuild rpm db, check / partition,
but no luck, problem still occurs.
View 8 Replies
View Related
Aug 25, 2010
Any time I've tried to run 'yum search' or 'yum info' I end up getting a error "database disk image is malformed"
Code:
$ yum info postgresql
Loaded plugins: presto, refresh-packagekit
Error: database disk image is malformed
I am, however, able to update and install software without this error occuring.
I've tried the 'yum clean all", "yum clean metadata", "yum clean datacache", and rebuilding with "yum makecache", but still this problem crops up. As I understand it, the error message comes from something possibly not having been updated properly in one of the sqlite databases that yum stores information in. I probably could fix it if I knew which sqlite db that 'yum search' and 'yum info' hit.
View 3 Replies
View Related
Feb 5, 2010
This error pops up randomly since last night, what is it about? I thought its maybe related to [URL] but I did not install/update/change anything with yum or packagekit for a few days. Could it be a problem with the daily update-check?
View 2 Replies
View Related
Oct 1, 2010
Am using mandriva 2008 i developed one simple application using cross platform = Qt3 Database = PostgreSQL
I want to share my database over peer to peer network.
server ip = 192.168.1.5
client ip = 192.168.1.6
Now how to share data over those ip?
View 1 Replies
View Related
Jun 4, 2010
I need a shell script to back up and restore a postgresql database.
View 1 Replies
View Related
Feb 24, 2011
While watching the text scroll by as I shut down I noticed that there is a PostgreSQL Daemon running somewhere. The question I have is, how do I add myself and my own database to this daemon or do I need to run one on my own user?
View 2 Replies
View Related
Jan 5, 2010
I run Slackware 13.0 and I have an apache server 2.2.13 with a postgresql 8.4.1 database attached to it via php 5.3.0. Both the apache server and the postgresql database are on the same machine.
I have the apache server port 80 exposed to the WAN. It is not a fqdm, it's just a simple IP address. On my index page, a user can login with a user/password that encrypts to md5 via postgresql and takes them into the database.
Here is the vulnerability. Can't a hacker just scan port 80 and find my ip address running apache. Go to my index page, see that I accept user/password for authentication into my postgresql database. Then they could setup a script to simply inject html GET requests of random users and passwords and use those values on the php page(the one where the action link is pointing to in the form tag) that contains user login/password in php to login to my postgresql database. There's nothing stopping that. It would be a simple dictionary attack.
I checked out postgresql documentation and it suggested using ldap, kerberos, or md5 and not trust. I'm using md5 already. I currently use fail2ban for proftpd and sshd and it works great. After 6 failed user/pass attempts on either of these services, the IP gets banned via iptables for 24 hours. I love it. I was wondering if I could use that. Of course postgresql port is not exposed to the WAN which is a good thing. I know that when I put in a wrong user/pass from my index page, I get sent to a default postgresql pg_connect warning page. Perhaps I can increase the verbosity of postgresql's logger, find the phrase that it spits out when there's been a bad login and create a filter using that.
I understand that the way it is currently setup, my server is pretty secure, but where there's a will there's a way. I just feel that my postgresql database is unprotected even tho the postgresql port is not exposed to the WAN. They could just bruteforce from the apache server.
View 12 Replies
View Related
Dec 26, 2010
i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password
createdb company
Password:
createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
View 1 Replies
View Related
Nov 3, 2010
we have Centos linux and database postgresql and taking dump in .data files. need to find all speical character in my database dump .data files it is open in txt paid and store in one txt file. e.g of special character are as below.
[Code]....
View 1 Replies
View Related
Sep 6, 2010
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]...
View 2 Replies
View Related
Jan 16, 2010
I just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...
View 1 Replies
View Related
Sep 2, 2010
my database (PostgreSQL) has ever funtioned OK, but today don't let me insert a new row in a table and the record itsn't duplicated. I did a vacuum full and reindex the database and the problem continue. I don't know what the fuck is happening
View 2 Replies
View Related
Jul 22, 2010
i want to right the on linux box which have postgresql and i what some data from the different table and put it in .csv file.
View 2 Replies
View Related
Aug 26, 2010
Trying to get OpenbavoPOS to connect to my remote Postgresql database, but so far i've only been able to connect to the local postgres installation. I _am_ able to access the remote databases with psql. I've read literally dozens of pages, and am pulling my hair out. I'm trying jdbc:derby.//192.168.15.10:5432/bravo I get back java.sql.SQLException no suitable driver found for jdbc:derby.//192.168.15.10:5432/bravo If I use jdbc:derby./root/bravo - all is OK, using a local database created in /root I have jdk installed on the client; does it need to be on the server also?
Server = CentOS 5.4 PostgreSQL version 8.1.21
Client = CentOS 4.8 PostgreSQL version 8.1.4
[code]....
View 1 Replies
View Related
Oct 12, 2010
Greetings from Greece. I tried to install opensuse 11.3 in an empty disk . Unfortunately the installation progress stops in 88% and the message error says "error copy live image to the disk". I have burn two different cd but the result is always the same.Is it a hardware problem or the cd is not correct?I had the 11.2 version in the same pc without any problem for a long time.
View 9 Replies
View Related
Jun 10, 2011
Relational databases usually have their data over in /var/lib/something. Users are in /home (with data in /var/www). How can I apply a single total disk space quota across all of these independent software systems (file systems, RDBMS, etc.)?
P.S. There's a bet going on around me as to just how awesome SU is. Let's see what you've got.
View 1 Replies
View Related
May 11, 2011
recently my HP Pavilion's Western Digital (WD2500JS) HDD has begun failing (bluescreens, slow, etc...). I was able to attach it to another computer using a IDE to USB adapter and save my personal files (pics, music, etc...), so the drive has not yet completely died. So I bought a SATA Seagate Barracuda 500GB HDD and wanted to use my restore discs that HP made me purchase off of them to reinstall my Windows Vista Home Premium Edition, which OF COURSE didn't work. So after researching a bit I found the best idea would be to make and Image copy of the original HDD and put it on the new one. So I tried using Clonezilla which ran in an endless loop giving error after error for hours while trying to image the disk. Fortunately my work has a ImageMASSter 4004i which is a piece of hardware that does a direct, drive to drive image from the Master drive to the destination drive.
But unfortunately this didn't work either. It was telling me that their was an error within the destination drive, something like "0x84 URMWT Sequencer failed to complete". Does the drive need to be completely empty?Should I reformat it before I try this (if so which FS?)? I plugged it into my laptop with USB to SATA adapter and was unable to mount it (this was after I had it in the Imaging Hardware Device, not sure if that could have screwed something up). The strange thing is that the last couple of days the new drive did work, I was using it for temporary storage of some files.
[code]...
View 11 Replies
View Related
Aug 25, 2010
I'm a Linux newbie and are trying to install F13 from bootable USB onto the HD of a DELL mini netbook. I've followed the install wizard's defaults including the "Use All Space option." The install errors out at about 20% of progress during the "Copying live image to hard drive" process. The error dialog is as followed:"There was an error installing the live image to your hard drive. This could be due to bad media. Please verify your installation media..." and it comes with options to Exit installer or Retry. I have since retried and restarted several times and still came to the same error. FYI, I've initially attempted to install F13 to the HD over an existing Windows XP.
View 2 Replies
View Related
Aug 8, 2010
I've got a Centos 5 machine running with a raid 1 SSD hard drive combo, as I don't know how or even if it's possible yet to wipe the free disk space clean I need to be careful to not fill all the free disk space. As I don't want to fill the free disk space too quickly and was wandering if it is possible to pipe the result of a mysqldump to a FTP client only writing it to the ram and not writing it to this disk.
I've done a bit of research on the subject and have found the two following commands:
Code: mysqldump < mysqldump options> | gzip > outputfile.sql.gz
Code: tar cf - / | ncftpput -c sonic.sega.co.jp /usr/local/backup.tar
I would like to combine the two to make something like this:
Code: mysqldump mysqldump_options > | ncftpput ncftpput_options -c SERVER_IP backup.sql
I haven't actually tried my code as it seems too easy and I'm sure I've got something wrong! If this command is even correct will it prevent the sql file from being written to the hard drive to my local machine?
View 4 Replies
View Related
Apr 14, 2010
I'm quite new to linux, but I've managed to grasp some basics. Now my intention here to create a virtual directory, which I resorted to creating an Image File so that I can mount it and have my folder have a dedicated storage. I will mount this image as a loop device. Well it's not much of a problem, but I would like to know whether this is suitable. Say I want to create a 25GB Image.
Code:
dd if=/dev/zero of=/home/disk-img/25GB.ext3 bs=1G count=25
Is this recommended? I'm using block size as 1G which is really huge, so I was wondering, if this is actually recommended. From what I read, some said that it's only advisable to use 4096k or lower, but what I found was that these suggestions are very dated (year 2003), and it is now 2010, so I would like to know if it makes any big differences.
View 13 Replies
View Related
Jan 7, 2011
IP address malformed error message Should be in form x.x.x.x. Where each x is no longer then 255.
View 2 Replies
View Related
May 13, 2011
I keep getting this error on my debian server (Buffalo Linkstation so there is no GUI):
Debian Linux Version 2.6.12.6-arm1
W: Failed to fetch http://ftp.us.debian.org/debian/dists/squeeze/Release Unable to find expected entry main/binary-arm/Packages in Meta-index file (malformed Release file?)
W: Failed to fetch http://security.debian.org/dists/squeeze/updates/Release Unable to find expected entry main/binary-arm/Packages in Meta-index file (malformed Release file?)
E: Some index files failed to download, they have been ignored, or old ones used instead.Ive tried and tried changing the source.list to different repos but keep getting the same error over and over. Im really not sure what to do and I have no idea how to fix it. Its been working fine for the longest time.
source.list
#### Debian Main Repos
#deb http://http.us.debian.org/debian/ stable main contrib non-free
#deb-src http://http.us.debian.org/debian stable main contrib non-free
#deb http://security.debian.org stable/updates main contrib non-free
#deb-src http://security.debian.org stable/updates main contrib non-free
[Code]...
View 5 Replies
View Related
Jan 25, 2011
When opening "Update-manager" I get this error:
E:Malformed line 47 in source list /etc/apt/sources.list (dist parse)
What I was trying to do was update my Opera web browser, when I tried, Ubuntu told me that I was attempting to download from an unauthenticated source, I checked the software sources list and Opera was in there, so I deleted it and re-added it, I must have done it wrong because after closing out and refreshing "Update-manager" it gave me the error above and closed. So now I can't update anything.
View 9 Replies
View Related
Feb 2, 2010
Sorry I am not a linux user at all. I have a linux image that needs to be installed. I have the image on a USB drive. Not really sure what I should be doing, but local disk seemed to make sense, however, when I select the usb drive I get an error, that the image can not be found
View 2 Replies
View Related
Dec 27, 2010
I have a large qcow2 formatted disk image, which I use as storage. Often I need to move data to and from this disk image. I mount the disk using the qemu-nbd tool as follows:
modprobe nbd max_part=63
qemu-nbd -c /dev/nbd0 /host/disk100G.img
mount /dev/nbd0p1 /home/rup/disk
But disk access fails every now and then in the midst of some I/O operation with an "Input/output error". At that point I have to manually unmount the disk and re-mount it so that I can run the program again:qemu-nbd -d /dev/nbd0umount joborkhaki/What could be the reason for this? Is there a better tool that I can use to maintain a qcow2 disk image?
View 1 Replies
View Related
Jul 28, 2010
I am new to the Linux world and I am not sure if what I am trying to do is achievable or not. I am trying to make an image of my existing drives running Linux on a USB and I want to use the same image off the USB to clone more bootable hard drives. Something like what Ghost does in windows. The problem is using 'dd' the image is too big ( I have 1tb drives ) and then I am not sure how to convert these images back on to new drives so that they boot in the OS as well. i am not sure if there is a utility that would let you do that?
View 2 Replies
View Related
Apr 5, 2010
I want diskboot.img for fedora 12. How to get it.
View 1 Replies
View Related