Tim, I redo from the scratch, install Ubuntu to Dspace and all that and now it is working fine. This is a nice helping tech group and appreciate everybody's help on resolving this issue, thanks again,
Faizur Rahman, Ph.D. UTD Library Systems 972-883-4100 [email protected] -----Original Message----- From: Tim Donohue [mailto:[email protected]] Sent: Tuesday, September 07, 2010 11:12 AM To: Rahman, Sm F Cc: [email protected] Subject: Re: [Dspace-tech] Dspace import/Replace error Faizur, There are several ways to backup Postgres -- so, you may want to ask the institution what sort of file they gave you. There are even several outputs possible with 'pg_dump' (see the -F <format> option description). http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html By default, "pg_dump" gives a textual format (i.e. you should be able to read it in a text editor). But, it's also possible to select a custom format which can only be restored using the 'pg_restore' script. Since you don't know how this backup was created, you're likely going to have to ask the person who created it. It's also possible that they only backed up the data, and not the full table definitions themselves (by default everything is backed up, but again, it depends on what flags they passed to the 'pg_dump' script). Generally speaking, you need to figure out which scenarios you have: (1) Which file format do you have? (1a) If you have textual backup file, you want to restore it using 'pgsql' command (like I sent you before) (1b) If you have an archive file (non-textual), that can only be restored using the 'pg_restore' command (with the proper flags): http://www.postgresql.org/docs/8.2/interactive/app-pgrestore.html (2) What info is in that file? (2a) If you only have data (no table definitions) -- you'll have to first create the tables before you can restore data. So, this would mean you'd *have* to first install DSpace from scratch (including running 'ant fresh_install' to create all the tables) (2b) If you have table definitions + data (default for Postgres) then you do NOT want to run that 'ant fresh_install' command. Essentially, your best choice now is to talk to the people who gave you the PostgreSQL backup file to find out how they created it. If you cannot talk to them, then you'll probably need to do a 'trial and error' process of attempting different types of PostgreSQL restores until you can find the one that works properly. Good luck, - Tim ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
