Tutorials

PEM 7.1 — Host Address

This video describes a feature that we have re-introduced in EDB Postgres™️ Enterprise Manager (PEM) 7.1 which was not in PEM 7.0. The Host Address field has been added in the Advanced tab of the Server Properties Dialog. It's used to supply the IP address of the host, preventing the need for a...

PEM 7.1 Feature — Database Restriction

This video describes a feature that we have re-introduced in EDB Postgres™️ Enterprise Manager (PEM) 7.1, which was not PEM in 7.0. Using the database restriction feature, users can set the database names that they want to see in the browser tree. The names should be comma separated, in the case...

PEM 7.1 Feature — Re-organize Charts in Custom Dashboard

This video describes another new feature in EDB Postgres™️ Enterprise Manager (PEM) 7.1 — "Re-organize Charts in a Custom Dashboard". Sometimes, there is a need to re-organize charts in a dashboard. We have added this feature so users can drag and drop charts accordingly....

PEM 7.1 Feature — Linked Line Charts for Zooming

This video describes another new feature in EDB Postgres™️ Enterprise Manager (PEM) 7.1 - "Linked Line Charts for Zooming". There is a dashboard configuration setting called "Link Timeline of all the Line Charts". If it's value is "Enable", and the user zooms on any one of the line charts for a...

Getting Started with Postgres Plus® Tutorial for Windows®

Master the basic operations of Postgres Plus and get into the interesting parts of your evaluation faster. This tutorial covers the basics of starting and stopping the database server, checking the server's status, using the pgAdmin GUI administrator's / developer's tool, and accessing the SQL...

How to Enable Audit Logging in EDB Postgres™ Advanced Server

EDB Postgres Advanced Server provides enterprise audit logging capabilities for tracking and analyzing database activities. You can audit user connection activity, user SQL activity including Errors, rollbacks, all DDL, all DML, all SQL statements, and even capture middle tier data tracking specific application users and IP addresses.  This tutorial makes setup quick and easy.

Getting Started with EDB Postgres™ Advanced Server on Linux®

Master the basic operations of EDB Postgres on Linux and get into the interesting parts of your evaluation faster. This tutorial covers the basics of starting and stopping the database server, checking the server's status, using the Postgres Enterprise Manager client, and accessing the SQL command line console.

How to Setup pgAgent for Postgres Plus

pgAgent is a pre-bundled enterprise module installed by default with Postgres Plus Standard Server and Postgres Plus Advanced Server. The pgAgent job scheduler allows authorized users to schedule jobs consisting of one or more SQL or shell/batch steps. Common uses include scheduled tasks such as...

Enabling Row movement and Updateable Partition Keys

Table partitions use simple rules driven by data values in table rows to spread the rows among the partitions. This provides multiple run time and maintenance efficiencies. However, once you have partitioned a table it is sometimes necessary to automatically move rows between the partitions following updates to data values that change which partition the row should reside in. This Quick Tutorial shows how to automatically move data across partitions and maintain partition keys at the same time.

How to Setup and Use PostGIS with Postgres Plus Advanced Server

PostGIS is a powerful spatial database extension bundled with Postgres Plus Advanced Server that adds spatial data types, functions and operators. This tutorial shows how to install, setup, and begin using a spatially enabled database that can be applied to a variety of applications.