Hi! Mika, I was able to try backup and reinstate dspace. Thanks.
I deleted few items from DSpace. I believe their handle details still exist in postgres. I executed VACUUMDB and then the display in the DOS command line was "VACCUM". I hope the command was executed successfully. IS there any way to flush out the items that are permanently deleted from DSPace. Does vacuumdb remove deleted collections/items which are permanently deleted and not shown on the DSpace GUI collection/item interface. Please suggest. Thanks, jayan -----Original Message----- From: Mika Stenberg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 5:40 PM To: Jayan Chirayath Kurian Subject: Re: [Dspace-tech] Postgres optimizations Hi, Im using pg_dump to backup db: pg_dump dspace > /dspace/dbbackup/dspace.db And rsync to backup dspace-directory and assetsore rsync -av --delete /usr/local/dspace-1.4/ /usr/local/dspace_backup/weekly/dspace-1.4/ Then my local backups are transferred to another server via WinScp script, which if very useful. You can actually skip rsync if you use Winscp with /synchronize option. You could also Zip the contents to save some space. Did this help? -Mika > Hi! Mika, > > Could you please suggest regarding how to take backups for DSpace > instances. I am using Dspace 1.4.1 on windows 2003. > > Thanks, > Jayan > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mika > Stenberg > Sent: Tuesday, May 29, 2007 4:13 PM > To: '[email protected]' > Subject: [Dspace-tech] Postgres optimizations > > Im hoping to get some hints for postgres performance optimization. Our > DSpace (1.4.1) has started to run really slow after the number of items > exceeded 40 000 (mainly metadata, few full texts only). > > I tried increasing work_memory and max_fsm_pages in postgres.conf but > with little help. Im also running regular vacuum and reindex for the db. > > Any help would be appreaciated, > -Mika > > ------------------------------------------------------------------------ > - > 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 -- Mika Stenberg IT-asiantuntija Terveystieteiden Keskuskirjasto Lääketieteellinen tdk PL 61 (Haartmaninkatu 4) Helsingin Yliopisto 00290 Helsinki puh. +358-9-191 26807 ------------------------------------------------------------------------- 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
