Hi!,
● I was trying the normal pg_dump and works fine. while trying with $
pg_dump -Ft -b mydb > db.tar and using pg_restore, it was giving an error
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 366; 2612 16386 PROCEDURAL LA
UAGE plpgsql postgres
pg_restore: [archiver (db)] could not execute query: ERROR: language "plpgsql
already exists
Command was: CREATE PROCEDURAL LANGUAGE plpgsql;
WARNING: errors ignored on restore: 1
(1) Dspace normally wont have any large objects since bitstream storage is
in Assetstore
(2) For backup, using pg_dump is fine?
(3) I was thinking to use $ pg_dump -Ft -b mydb > db.tar due to several GB
of items in the repository.
Thanks for your suggestion
Rgds,
Jayan
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
