Environment
GWAVA (Secure Messaging Gateway) on SLES
Situation
How can the main SMG database get backed up and if needed sent to support easily?
Resolution
Here are some steps to back up the main SMG database, and how to send it to support's FTP server if needed:
1) From the server containing the db, go to a prompt and change directories to desired location, for example type: cd /vastorage/smg2) From this directory type the following to create the backup copy of the db:pg_dump --username=postgres --host=127.0.0.1 --dbname=SecureGateway --format=c --file=SecureGateway.backupA prompt for the password will appear, the default is postgres.There should now be a file in the desired location named SecureGateway.backup3) This should be small enough to email to support, but if it's not it can be uploaded to the ftp server.When uploading a file to support's FTP server, the file name must include the SR number. For this command the example SR number is 123456789. Upload it to MF's ftp server by typing:curl -T /vastorage/smg/SecureGateway.backup ftp://ftp.novell.com/incoming/123456789smgdb.gz(The above is an example, make sure to put in the correct path and filename)Let support know when it has been uploaded.