Hi,
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jordi Mulet Sent: Tuesday, August 28, 2007 3:32 PM To: [email protected] Subject: [ADMIN] No restore of BLOB data (permissions?) Hi, 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). Message. pg_restore -c -h localhost -p 5432 -U postgres -d database1 -v database1.backup 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" 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 1691; 0 0 BLOB COMMENTS - BLOB COMMENTS ________________________________ Looking for a deal? Find great prices on flights and hotels <http://us.rd.yahoo.com/evt=47094/*http:/farechase.yahoo.com/;_ylc=X3oDM TFicDJoNDllBF9TAzk3NDA3NTg5BHBvcwMxMwRzZWMDZ3JvdXBzBHNsawNlbWFpbC1uY20-> with Yahoo! FareChase. DISCLAIMER: 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.
