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/4/2011


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



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.


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 Product Downloads site at: http://www.mcafee.com/us/downloads/downloads.aspx.

 You will need a valid Grant Number for access. KB56057 provides additional information about the Product 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, Intel Security 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 

  • 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

Beta Translate with

Select a desired language below to translate this page.

Glossary of Technical Terms

Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.