Loading...

Knowledge Center


The GS7MESData folder in the GroupShield 7.0.1 for Microsoft Exchange database location increases in size rapidly
Technical Articles ID:  KB67006
Last Modified:  11/04/2011
Rated:


Environment

McAfee GroupShield 7.0.1 (7.0 Service Pack 1) for Microsoft Exchange
Microsoft Exchange 2007
Microsoft Exchange 2003

 

Problem

The GS7MESData folder in the GroupShield Postgres database location increases in size very quickly. The Purge and Optimization tasks do not reduce the size of the folder significantly.

Cause

Sometimes the database optimization task fails to delete excessive white space from certain database tables previously cleared by the database purge task.

Excessive space usage can also be caused by write-ahead transaction logs. For more information, see KB67465.

Solution 1

This issue is resolved in the following GroupShield packages:
  • GroupShield for Exchange 7.01 Patch 1
  • GroupShield for Exchange 7.01 Patch 1 Rollup 2
NOTE: The issue caused by write-ahead transaction logs (described in KB67465) is also resolved in Patch 1 and/or Patch 1 Rollup 2.
 
Patch 1 release notes are available in PD22882.
Patch 1 Rollup 2 release notes are available in PD23410.

McAfee recommends installing GroupShield 7.0.1 Patch 1, Rollup 2, which does not require any previous GroupShield 7.0.1 Hotfix or Patch to be applied before installation. GroupShield 7.0.1 Patch 1, Rollup 2 can be install over GroupShield 7.0.1 RTW, GroupShield 7.0.1 Patch 1, or GroupShield 7.0.1 Patch 1, Rollup 1.

NOTE: GroupShield 7.0.1 Patch 1, Rollup 2 contains all pre-Patch 1 Hotfixes, all Patch 1 Hotfixes, all Patch 1, Rollup 1 Hotfixes, as well as several new fixes. For additional information on Patch 1, Rollup 2 see: PD23410

McAfee product software, upgrades, maintenance releases, and documentation are available from the McAfee Downloads site at: http://www.mcafee.com/us/downloads/downloads.aspx.

NOTE:
 You will need a valid Grant Number for access. KB56057 provides additional information about the McAfee Downloads site, as well as alternate locations for some products.

Solution 2

If you cannot install Patch 1 or Patch 1 Rollup 2 immediately, you can remove the excessive white space and shrink the Postgres database manually.

IMPORTANT: If you have already installed GroupShield 7.0.1 Patch 1, GroupShield 7.0.1 Patch 1 Rollup 1, or GroupShield 7.0.1 Patch 1 Rollup 2, the following procedure will not work  - after these fixes have been put in place, use the Purge and Optimize Tasks in the GroupShield interface (under Settings & DiagnosticsDetected Items).


CAUTION: This article contains information about opening or modifying the registry.
  • The following information is intended for System Administrators. Registry modifications are irreversible and could cause system failure if done incorrectly.
  • Before proceeding, McAfee strongly recommends backing up your registry and understanding the restore process. For more information, see: http://support.microsoft.com/kb/256986.
  • Do not run a .REG file that is not confirmed to be a genuine registry import file.

Obtain the relevant database information from the registry
NOTE: The name of the Database and the Database User may vary depending on individual customization.

To start the Windows registry editor
  1. Click Start, Run, type regedit and then click OK.
  2. Navigate to the following key:

[HKEY_LOCAL_MACHINE\Software\McAfee\GroupShield for Exchange\Repository\Variables\DbName]

  1. Make a note of the Database name.
  2. Navigate to the following key:

    [HKEY_LOCAL_MACHINE\Software\McAfee\GroupShield for Exchange\Repository\Variables\DbUser]

  3. Make a note of the Database User.
  4. Close the registry editor.


Run the vacuumdb command to reduce the size of the database 
NOTES:

  • This command is case sensitive. Ensure that it is typed exactly as shown below.
  • When running the command, the second argument is optional. The default action is both.
  1. Click Start, Run, type cmd and click OK.
  2. To change directories to the PostgreSQL\bin folder, type the following command and press ENTER:

    cd "\Program Files\McAfee\GroupShield for Exchange\PostgreSQL\bin" 
     
  3. Type the following command and press ENTER:

    vacuumdb -f -U McAfeeGSEQtnDBUser mcafeegseqtndatabase 

    To see additional options for the vacuumdb command, type the following command and press ENTER:

    vacuumdb –help
     
  4. Close the command window.

Rate this document

Did this article resolve your issue?

Please provide any comments below

Glossary of Technical Terms


Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.
United States - English
© 2003-2013 McAfee, Inc.