Installing EDB Wait States

On Linux

To install EDB Wait States on a Linux system:

Install EDB Wait States with the edb-asxx-server-edb_wait_states RPM package, where xx is the EDB Postgres Advanced Server version number.
To launch the worker, register it in the postgresql.conf file using the shared_preload_libraries parameter. For example:
```
shared_preload_libraries = '$libdir/edb_wait_states'
```
Restart the database server. After a successful restart, the background worker begins collecting data.
To review the data, create the following extension:
```
CREATE EXTENSION edb_wait_states;
```
To terminate the EDB Wait States worker, remove $libdir/edb_wait_states from the shared_preload_libraries parameter, and restart the database server.

To install EDB Wait States on a Windows system:

To install the EDB Wait States module with the EDB Modules installer, invoke the StackBuilder Plus utility. Follow the onscreen instructions to finish installing the EDB Modules.
To register the worker, modify the postgresql.conf file to include the EDB Wait States library in the shared_preload_libraries configuration parameter. The parameter value must include:
```
shared_preload_libraries = '$libdir/edb_wait_states.dll'
```
The EDB Wait States installation places the edb_wait_states.dll library file in the following path:
```
C:\Program Files\edb\as14\lib\
```
Restart the database server to make the changes take effect. After a successful restart, the background worker starts and begins collecting the data.
To view the data, create the following extension:
```
CREATE EXTENSION edb_wait_states;
```

The installer places the edb_wait_states.control file in the following path:

C:\Program Files\edb\as14\share\extension

To uninstall EDB Wait States:

Use the DROP EXTENSION command to drop the edb_wait_states extension.
Modify the postgresql.conf file, removing $libdir/edb_wait_states.dll from the shared_preload_libraries parameter.
To apply your changes, restart the database server.