Am 01.08.2007 um 10:45 schrieb Jayan Chirayath Kurian: > For dspace database backup (dspace 1.4.1/windows 2003), I use pg_dump > dspace -U postgres > c:\testbk.txt
I would call it testbk.sql, to help point and click operations on this file, but these are details. > Apart from this, is there a need to take the backup of data > directory in > C:\Program Files\PostgreSQL\8.2. I tried with tar (windows based - tar > -cv --file=backup.tar d:/progra~1/postgr~1/8.2/data) and extracted > into > the same postgreSQL directory after versioning the previous data > folder. > But DSpace was giving internal error with the stack tree given below. > How shall I take the backup of postgreSQL data directory for a > successful restoration? This will only work if you stop postgres before backing up the directory. But you dont need that to work. You have already got what you want, all the config data which is inside the directory. I think you have come a long way already. You should read the postgres docs yourself from now on. We cant paraphrase everything from there on the list. You have gathered all the parts, now you need to put them together and find out how it works for you. Bye, Christian ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech