Thanks Christian, Mark, and Rob for your input. The backup procedure works fine with DSpace 1.4.1/ Windows 2003 as outlined below.
Automatic scheduled backup for DSpace using open source backup software (1) Create a folder named PostgresqlBkp (2) Copy postgresql - pg_dump.exe and all the library files in the postgresql - bin directory to the PostgresqlBkp folder. (3) Save the backuppgsql.java program to the PostgresqlBkp directory. This program will take the dump backup of postgresql and save it indicating the backup date as the filename. (4) Create a batch file (DataBKP.bat) in the PostgresqlBkp folder for scheduling the backuppgsql.java program. The class name is backupPGSQL executed using javaw. The backup is stored in the PostgresqlBkp folder. cd C:\DOCUME~1\jayan\Desktop\PostgresqlBKP javaw backupPGSQL (5) The DataBKP.bat is scheduled using the Windows scheduler (accessories - system tools - scheduled tasks) (6) Download and install DeltaCopy software (7) Create a folder named DSpaceBKP in a Server for storing the backup. (8) Create profiles in DeltaCopy software pointing to the following folders for backup into the DSpaceBKP folder. Create a single profile for "a" and "b" and a separate profile for "c" for facilitating easy restoration of "a" and "b" using the DeltaCopy software. a. DSpace source folder b. Dspace installation folder c. PostgresqlBkp directory (9) Create scheduled tasks for the DeltaCopy profiles (a, b, and c) for backup into the DSpaceBKP folder. The DSpaceBKP folder holds the entire DSpace backup data for restoration. The DeltaCopy backup software is available at http://www.aboutmyip.com/AboutMyXApp/DeltaCopy.jsp and the java program can be send if any one wants to try this scheduled backup procedure. The restoration works well with DSpace 1.4.1 on Windows 2003. I have tried this after deleting the dspace default database (as well as installing from scratch) and restoring using the pgAdmin utility. This procedure will avoid middling with the command line interface and will make a live DSpace backup process automatic. Please let me know if any one wants to try this at their end. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark H. Wood Sent: Wednesday, August 01, 2007 11:16 PM To: [email protected] Subject: Re: [Dspace-tech] FW: Automatic scheduled backup for DSpaceusingopen source backup software (testing) The first thing I would check is that the postmaster (the service that mediates access to the database cluster) is running. "Connection refused" sounds like nothing is listening on port 5432 (or whatever port you use for PostgreSQL). -- Mark H. Wood, Lead System Programmer [EMAIL PROTECTED] Typically when a software vendor says that a product is "intuitive" he means the exact opposite. ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
