The Pervasive Workgroup Engine is used by Sage 50 and Peachtree to perform the database functions. It is a piece of software that runs either as a task or service.
There may be time when you need to shut it down manually. If you are experiencing errors or unable to restore a backup shutting it down may solve your problem.
Before you manually shut down the Workgroup Engine, make sure all users have exited Sage 50 or Peachtree Accounting.
You should also have all workstations exit all programs they may have open. Pervasive Workgroup Engine is a common database software that is used by other software products just not Sage 50 or Peachtree. Many companies use this engine to perform their database tasks.
After all users and workstations have closed all their programs, you can manually shut down Pervasive.
The Pervasive Workgroup Engine runs on all workstations including the server if you are using one. So these steps must be performed on each Workstation and Server.
Another way of restarting the Engine is to just reboot all workstations and servers. This may not be an option for you at this time so we are providing instructions here if that is the case.
Solution I:Stop and Restart Pervasive from the Services menu
Note: The following steps can be followed for Windows 7, 8 or 10.
- Press Windows+R keys
- Type SERVICES.MSC, and then click OK
- Right-click Sage 50 SmartPosting [version], and then select Stop (Quantum users only)
- Right-click Pervasive PSQL Workgroup Engine, and then select Stop
- Right-click Sage 50 SmartPosting [version], and then select Start (Quantum users only)
- Right-click Pervasive PSQL Workgroup Engine, and then select Start
Note: A simplified version of the Services menu is available on the Services tab in the Windows Task Manager. The Pervasive database service (psqlWGE) and SmartPosting (Sage 50 SmartPosting [version]) can be stopped and/or started from the right-click menu.
Solution II:Stop and Restart Pervasive using a command prompt
- Press Windows+R keys
- Type cmd, and then click OK
Note: If User Account Control is enabled, it is necessary to elevate rights by right-clicking Command Prompt in the Start Menu and selecting Run as administrator.
- Type sc stop psqlwge and press Enter
- Type sc start psqlwge and press Enter
- Close the command prompt
Note: Alternatively, to forcibly stop all instances of Pervasive, the taskkill command could be used (Example: taskkill /F /im w3dbsmgr.exe).