Installing EDB Wait States
Suggest editsOn all Linux systems except Debian and Ubuntu
To install EDB Wait States on any Linux operating system except Debian or Ubuntu:
Enter the following command:
Where:
<package-manager>
is the package manager used with your operating system.Package manager Operating system dnf RHEL 8/9 and derivatives yum RHEL 7 and derivatives, CentOS 7 zypper SLES <install-package-name>
is the name of the Postgres distribution you're using. In the package names,<version>
is the version of the Postgres distribution.Type of Postgres distribution Install command PostgreSQL postgresql <version>
-edb_wait_statesEDB Postgres Advanced Server edb-as <version>
-server-edb_wait_statesEDB Postgres Extended Server edb-postgresextended <version>
-wait-states
For example, to install EDB Wait States for EDB Postgres Advanced Server 16 on a RHEL 9 platform:
To launch the worker, register it in the
postgresql.conf
file using theshared_preload_libraries
parameter. For example:Restart the database server. After a successful restart, the background worker begins collecting data.
To review the data, create the following extension:
On Debian and Ubuntu
To install EDB Wait States on Debian or Ubuntu:
Enter the following command:
Where:
<install-package-name>
is the name of the Postgres distribution you're using. In the package names,<version>
is the version of the Postgres distribution.Type of Postgres distribution Install command PostgreSQL postgresql <version>
-edb-wait-statesEDB Postgres Advanced Server edb-as <version>
-server-edb-wait-statesEDB Postgres Extended Server edb-postgresextended-wait-states- <version>
For example, to install EDB Wait States for EDB Postgres Advanced Server 16 on a Debian 11 platform:
To launch the worker, register it in the
postgresql.conf
file using theshared_preload_libraries
parameter. For example:Restart the database server. After a successful restart, the background worker begins collecting data.
To review the data, create the following extension:
On Windows
An EDB Postgres Advanced Server installation includes support for EDB Wait States. After installing EDB Postgres Advanced Server, you need to perform some additional steps to activate EDB Wait States.
To register the worker, modify the
postgresql.conf
file to include the EDB Wait States library in theshared_preload_libraries
configuration parameter. The parameter value must include:The EDB Wait States installation places the
edb_wait_states.dll
library file in the following path:Where
<xx>
is the EDB Postgres Advanced Server version, such asas16
.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:
The installer places the edb_wait_states.control
file in the following path:
Uninstalling
To uninstall EDB Wait States:
- Use the
DROP EXTENSION
command to drop theedb_wait_states
extension. - Modify the
postgresql.conf
file. Remove$libdir/edb_wait_states
(for Linux) or$libdir/edb_wait_states.dll
(for Windows) from theshared_preload_libraries
parameter. - To apply your changes, restart the database server.
Could this page be better? Report a problem or suggest an addition!