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

Fedora :: Error - Database Disk Image Is Malformed

Nov 15, 2009

I get this:

database disk image is malformed

View 2 Replies View Related

Fedora :: Error: Database Disk Image Is Malformed

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

Fedora :: YUM SQLite3 Database Error - Disk Image Malformed

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

Fedora :: Yum Search / Info - Database Disk Image Malformed

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

Fedora :: Error Pop Up - Software Source Database Malformed?

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

General :: Sharing Postgresql Database

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

General :: Shell Script To Back Up A Postgresql Database?

Jun 4, 2010

I need a shell script to back up and restore a postgresql database.

View 1 Replies View Related

Ubuntu :: Add Database To PostgreSQL Daemon

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

Security :: Securing My Postgresql Database ?

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

Server :: Cannot Create Database In PostgreSQL

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

Software :: In Database Dump Txt It Is Showing Some Special Character

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

Programming :: Incremental Backup Using DUMP Command - Error "DUMP: Only Level 0 Dumps Are Allowed On A Subdirectory"

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

Ubuntu Servers :: How To Clear Postgresql Database Cache

Jan 16, 2010

I just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...

View 1 Replies View Related

Server :: Can't Insert A Record In A Table On Postgresql Database?

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

Programming :: Right The Shell Script Which Talk To Postgresql Database?

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

Server :: Unable To Connect To Remote PostgreSQL Database With Java.derby

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

OpenSUSE Install :: Installation Progress Stops In 88% / Message Error / Error Copy Live Image To Disk

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

General :: Single Disk Space Quota Across Home Directories And Relational Databases (MySQL, PostgreSQL)?

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

Hardware :: Endless Loop Giving Error While Trying To Image Disk

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

Fedora Installation :: Error W/ F13 Install To HD During Copying Of Live Image To Disk

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

Red Hat / Fedora :: Pipe MySQL Dump To FTP Without Writing To Disk

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

Server :: Disk Dump - Creating Virtual Directory

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

Debian Installation :: IP Address Malformed Error Message

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

Debian Configuration :: Sudo Apt-get Update Error / Malformed Release File?

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

Ubuntu Installation :: Update Manager Error - Malformed Line 47 In Source List

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

General :: Can I Use G4L To Image A Disk With Another From A USB Dirve

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

General :: Mount - How To Use Qcow2 Disk Image

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

General :: Creating Image Of Hard Disk

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

General :: How To Get Disk Boot Image For Fedora 12

Apr 5, 2010

I want diskboot.img for fedora 12. How to get it.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved