Dear All,
We are using the postgreSQL version 8.0.7 and we are facing a problem
regarding the large object and pg_dump.
We are storing image data as OID type. We have developed a PHP
application on it and we can see those images properly.
The problem is when we dump the DB using the following command:
pg_dump -U user -h host -i -o -b -v -F c db_name -f file_name
We are then getting an error when we try to load it on the same host
using pg_restore as follow:
pg_restore -i -h host -p 5432 -U user -d db_name -v file_name
Here is the error we got:
pg_restore: [archiver] could not create large object 488676329
pg_restore: *** aborted because of error
So, we try to get rid of this particular image by first deleting the
picture row with this corresponding oid and then making a vaccumdb +
reindex to delete the reference in the pg_largeoject but still the
largeobject is there.
Do you have any advices how can I delete this record (can I do a simple
delete from pg_catalog.pg_largeobject or this will trigger other
problems?) or if there are some workarounds?
I thank you for your attention and I look forward to hearing from you.
Best regards,
Gregory
--
--
------------------------------------------------------------------
Gregory Gimenez.
Bioinformatics Software Engineer
Marcelle group
Institut de Biologie du Developpement de Marseille
Campus de Luminy Case 907
13288 Marseille Cedex 9
FRANCE
Tel. +33 (0)491 829 240
Fax +33 (0)491 820 682
Web: http://www.ibdm.univ-mrs.fr
------------------------------------------------------------------