Skip site navigation (1) Skip section navigation (2)

Re: No restore of BLOB data (permissions?)

From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju(at)satyam(dot)com>
To: "Jordi Mulet" <jmuletalbiach(at)yahoo(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: No restore of BLOB data (permissions?)
Date: 2007-08-28 10:09:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin


Try this command 


Pg_restore.exe -i -h localhost  -p 5432 -U (username)  -d
(database_name) -V " Path of your Backup files"


Jayakumar M



From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Jordi Mulet
Sent: Tuesday, August 28, 2007 3:32 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] No restore of BLOB data (permissions?)



 I tried to backup and restore a database  (including blob data) and
pg_restore give me an error (pg_dump seems to be working Ok).


pg_restore  -c -h localhost -p 5432 -U postgres -d database1 -v


pg_restore: restoring BLOBS
pg_restore: [archiver] could not create large object 16591
pg_restore: *** aborted because of error


pg_dump.exe -h localhost -p 5432 -U postgres -v -o -F c -b  database1 -f


database1.backup is created (aprox. 25 MB)


error code 0


I tried  pg_restore -l  in order to list contents of backup file and it
seems some problem is detected on database1.backup:


1690; 0 0 BLOBS - BLOBS 



Looking for a deal? Find great prices on flights and hotels
with Yahoo! FareChase.

This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2007-08-28 13:35:57
Subject: Re: No restore of BLOB data (permissions?)
Previous:From: Jordi MuletDate: 2007-08-28 10:01:46
Subject: No restore of BLOB data (permissions?)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group