Running the Workgroup Engine as a Service

By default, the Workgroup Engine is installed to run as a service for a fresh install. Running the Engine as a service allows the Engine to start automatically when the operating system starts. A user is not required to log in to start the engine. No tray icon appears when you run the Workgroup Engine as a service.

During installation, you can select to run the Workgroup Engine as a console application. Or, if you upgraded your Workgroup installation and you had the previous version installed to run as an application, the upgrade installation is also set to run as an application. In either case, if you decide that you would rather run the Workgroup Engine as a service, you change how it is run.

Configuration

To configure your Workgroup Engine to run as a Service as opposed to an application, you must reinstall the PSQL v12 Workgroup Engine. Choose Run As Service on the Engine Settings dialog box during install. See Installing PSQL Workgroup for Windows.

Note: Running the engine as a service requires the Log On as Service privilege. If you select to run the engine as a service under a user account other than the default Local System account, you will need to modify the Log On Properties for the Service using the Windows Control Panel.

Note that on Windows platforms, a valid user name and password are required to access PSQL databases on another machine. "System Account" has no rights on other machines to PSQL databases.

If you want the PSQL Workgroup service to access databases on another machine, then you must specify a valid user name and password for the other machine, unless there is a running PSQL Workgroup available locally on the other machine that can be used to access the databases instead. Access the properties for the PSQL Workgroup service. (Double-click the service on the Services dialog.) In the Log On As section, check This Account and specify a valid user name and password.

Stopping the Service

If you want to stop and then restart the service (but do not permanently remove the service), then simply restart the machine.

You stop the service on Windows platforms just as you would any other service.

►

Stopping the Engine as a Service on Windows

In the Windows Control Panel, click Administrative Tools, then double-click Services.

Right-click the service name assigned to the Workgroup engine and click Stop.