Hi! For dspace database backup (dspace 1.4.1/windows 2003), I use pg_dump dspace -U postgres > c:\testbk.txt 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?
"org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. Exception: java.net.ConnectException: Connection refused: connect Stack Trace:" Thanks, Jayan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christian Voelker Sent: Tuesday, July 31, 2007 4:30 AM To: Mark H.Wood Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] FW: Automatic scheduled backup for DSpace usingopen source backup software Hello, Am 30.07.2007 um 21:49 schrieb Mark H. Wood: > We need to be careful as to what we mean by "data directory". A > typical PostgreSQL installation has a directory *named* "data" which > *should* be backed up. It contains configuration and access-control > data, perhaps X.509 certificates to enable TLS-encrypted access, some > small files used for restarting, and several directories that hold > transaction logs and the like. Sorry, you are right. I see these files as more less static or tend to put them under version control as soon as I have to fiddle around with them while changing my configs. I keep a system snapshot that I would use as well when starting over and setting up a new machine, so I have an initial version pg_hba.conf and associated files at hand. As for the logfiles, these are the files that I mentioned for the point in time strategy; they are rather bulky. So if you dont have a system snapshot then "go with pg_dumpall and you are fine" is not the whole truth. The pg_dumpall compensates for the fact that the files in the base directory are normally useless because they are usually opened while the snapshot is taken. Thanks for pointing that out. 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 ------------------------------------------------------------------------- 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