Error restoring bytea from dump

Hello every one,

I have a problem to restore my postgresql dumpfile. I have a postgresql database 7.3.2 in a linux environment and i want to restore the dumpfile that i make from linux environment to the postgresql 8.1.11 in a window environment. I make my backup in a postgresql 7.3.2 in linux environment with the following command :
pg_dump -b -v -Fc -Z9 -U _postgresql -f istpdb-2007-08-09.psqldump istpdb
and i try to restore it in postgresql 8.1.11 in window environment with the following command : pg_restore -U _postgresql -v -d istpdb istpdb-2007-08-08.psqldump.

when i restore it there is some error appear on window console, but the restoration is still running until finish. The problem is when i try to make a query to my table with bytea data type it crash and hang, the computer is not responding.

I hope some one can help me to solve this problem, if it is possible please reply this question as soon as possible. Thank you very much in advance.

Best regards,
Bogie

Apr 8 '08 #1

Subscribe Post Reply

2932

by: Adam Smith | last post by:

Hope this is the right news group!! I did a server upgrade and at the same time did a mysql update from 4.0.12 to Ver 12.22 Distrib 4.0.16 ...

MySQL Database

Restoring select databases/tables from an --all-databases backup

by: Raffi | last post by:

I use the --all-databases switch to backup my entire database. Sometimes there's a need to restore individual databases or tables form the backup...

MySQL Database

Picture with Postgres and Delphi

by: Edwin Quijada | last post by:

Hi !! Everybody I am developing app using Delphi and I have a question: I have to save pictures into my database. Each picture has 20 o 30k aprox....

PostgreSQL Database

DB with bytea types reload problem

by: Rory Campbell-Lange | last post by:

I am using 7.3.2 I've made a mistake and saved a database like this pg_dump -a -d <db> > out.sql ....instead of using a binary output...

PostgreSQL Database

Restoring a table with a different name

by: Mike Nolan | last post by:

I have a 600K row table on my production system (running 7.3.3) that I dump and load on my development system (7.4.1) every night using cron jobs....

PostgreSQL Database

Option required to dump bytea fields?

by: Carlos | last post by:

Do I need to use the -b option in pg_dump to dump bytea fields? For a while now I have been routinely using the -b option in pg_dump to back up,...

PostgreSQL Database

pg_dump, bytea, dump order questions

by: Együd Csaba | last post by:

Hi All, I'd like to dump out my database using plain text format. Everything is ok, but the bytea filds. Restoring the dump file (using <<psql...

PostgreSQL Database

Error restoring bytea from dump

by: Együd Csaba | last post by:

Hi, the restoration of a dump stops at the line above. The dump was created with pgsql 7.3.2 and I need to pump it into a 7.4.3 one. Should anybody...

PostgreSQL Database

Restoring dump files completely

by: chenert | last post by:

Hi all, im beginner to restoring dump files and postgresql as well so hope u could bear with me.! :D i have these dump files and i've been...

PostgreSQL Database

Restoring selected tables / table data

by: Troels Arvin | last post by:

Hello, Every so often, I'm asked to help people recover data from tables that were either dropped or where to much data was DELETEed. The...

DB2 Database

List of Topmost 8 Electronics Engineering Forum Websites

by: teenabhardwaj | last post by:

How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...

General

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...

General

https redirect with reverse proxy

by: jalbright99669 | last post by:

Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...

IIS / Internet Information Server

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...

General

How to use http requests (Get function) to get variable value?

by: Matthew3360 | last post by:

Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

Python

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

by: AndyPSV | last post by:

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

General

How do I view Redshift db tables in Alteryx

by: Arjunsri | last post by:

I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...

General

PHP Curl Not wanting to connect to localhost.

by: Matthew3360 | last post by:

Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

PHP

FPGA Question

by: Oralloy | last post by:

Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...

General

Similar topics