Starting and Stopping the Database Engine

Starting and Stopping the Database Engine

The following topics outline how to start and stop the PSQL engine. When you change certain engine configuration settings, you need to stop and restart the engine for the new setting to take effect.

To start and stop the database engine, follow the instructions for your engine and platform:

•

Starting and Stopping the Server Engine on a Windows Server

•

Starting and Stopping the Workgroup Engine on Windows

•

Starting and Stopping the Database Engine on Linux and OS X

Starting and Stopping the Server Engine on a Windows Server

On Windows server environments, PSQL Server runs as services. The services are loaded as part of the installation process and are set to be always available if you followed the default installation.

Services Dependencies

Additional PSQL products such as DataExchange also install services. DataExchange depends on both PSQL Transactional Engine and PSQL Relational Engine services.

The following table summarizes the behavior of the dependent services for start, stop, and restart actions of the database engine services.

Note that the behavior of the dependent services is the same regardless with which application you start, stop, or restart the database engine services (PCC, Windows Services, Net Start, PSC).

Table 4

Action of Dependent Services Based on Action of Database Engine Services

Database Engine Service

Service Action for Data Exchange

PSQL Transactional Engine

PSQL Relational Engine

If you start the service for DataExchange, the PSQL Relational Engine starts as a prerequisite service.

Note: The dependent services stop without displaying a message that they will be stopped.

►

To start the database services on a Windows server using PCC

See To start or stop services.

►

To stop the database services on a Windows server using PCC

See To start or stop services.

►

To start the database services on a Windows server using Control Panel

1

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

A dialog box similar to Figure 1 appears.

Figure 1 Services Dialog Box

2

Right-click PSQL Transactional Engine then click Start. Right-click PSQL Relational Engine then click Start.

►

To stop the database services on a Windows server using Control Panel

1

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

A dialog box similar to Figure 1 appears.

Figure 2 Services Dialog Box

2

Right-click PSQL Relational Engine and select Stop. Right-click PSQL Transactional Engine and select Stop.

►

To start the database services on a Windows server by using Net Start or PSC

1

Run one of the following commands at the operating system:

•

net start "Pervasive.SQL (<transactional | relational>)"

•

psc start "Pervasive.SQL (<transactional | relational>)"

►

To stop the database services on a Windows server by using Net Stop or PSC

1

Run one of the following commands at the operating system:

•

net stop "Pervasive.SQL (<transactional | relational>)"

•

psc stop "Pervasive.SQL (<transactional | relational>)"

Starting and Stopping the Workgroup Engine on Windows

►

To start the Workgroup Engine as an application on Windows

These steps assume that the Workgroup Engine was installed as an application. See Installing the PSQL Workgroup for Windows in Getting Started with PSQL.

1

Click Start Workgroup Engine from the operating system Start menu or Apps screen.

►

To stop the Workgroup Engine as an application on Windows

These steps assume that the Workgroup Engine was installed as an application. See Installing the PSQL Workgroup for Windows in Getting Started with PSQL.

1

Click Stop Workgroup Engine from the operating system Start menu or Apps screen.

Note: You will receive a warning message when trying to stop the engine if any of the following is true:

•

There are active clients.

•

No activity took place since the engine loaded.

•

10 seconds has not elapsed since the last operation took place.

►

To start the Workgroup Engine as a service on Windows

These steps assume that the Workgroup Engine was installed as a service, which is the default for a fresh install. See Installing the PSQL Workgroup for Windows in Getting Started with PSQL.

1

Refer to the various methods described in the section Starting and Stopping the Server Engine on a Windows Server.

2

Substitute “PSQL Workgroup Engine” as the service name if you use Windows Services control panel. Substitute “psqlWGE” as the service name if you use net start or psc.

►

To stop the Workgroup Engine as a service on Windows

These steps assume that the Workgroup Engine was installed as a service, which is the default for a fresh install. See Installing the PSQL Workgroup for Windows in Getting Started with PSQL.

1

Refer to the various methods described in the section Starting and Stopping the Server Engine on a Windows Server.

2

Substitute “PSQL Workgroup Engine” as the service name if you use Windows Services control panel. Substitute “psqlWGE” as the service name if you use net start or psc.

Starting and Stopping the Database Engine on Linux and OS X

On Linux and OS X, the database engine runs as a daemon. The daemon is loaded as part of the installation process and is set to be always available if you used the complete installation.

You must be logged in as the root user to start and stop the PSQL v12 daemon process. Use the shell script psql as shown in the following examples.

►

To start the database engine

Enter the following at the command line.

/etc/init.d/psql start

/usr/local/psql/etc/init.d/psql start

For PSQL 64-bit Server, this command starts both the transactional and relational engines.

►

To stop the database engine

Enter the following at the command line.

/etc/init.d/psql stop

/usr/local/psql/etc/init.d/psql stop

For PSQL 64-bit Server, this command stops both the transactional and relational engines.

►

To force stop the database engine

If the database engine does not start or stop correctly using these start and stop commands, you may need to force stop the engine. The force stop removes any shared memory and semaphores created by PSQL and stops the PSQL relational and transactional processes. Enter the following at the command line to force stop the database engine.

/etc/init.d/psql force

/usr/local/psql/etc/init.d/psql force