Tutorials

Tutorials

This feature will provide role based access to each individual component of PEM. Until PEM 7.1, if any user is member of 'pem_user' then they can view the dashboard and access some read only features of PEM, but can't access features like Alerts, Probe, Capacity Manager, Tuning Wizard, etc. With...

This feature will be used to create alerts automatically, using those alert templates for which the "Auto create" flag is set to true. The alerts will be created when a new object (agent/server) is added, and removed when an existing object (agent/server) will be deleted or dropped. The alerts...

This feature will be used to display the detailed information about the alert raised on Dashboard and email notification. Till PEM 7.1, once the alert is raised, the user had to fire a query on their own to figure out the detailed information. For example "Connection in idle state" is an alert...

The EDB Postgres Enterprise Manager (PEM) Renew Certificate is a new feature that has been introduced in PEM 7.2. With the help of this feature, server/agent certificates will be renewed 20 days before their shown expiry date. This demo will show you how this new feature works....

This video demonstrates how to install and set up EDB Postgres Failover Manager 3.0. It includes a walk through of all of the EDB Postgres Failover Manager properties that can be set, including how to upgrade from a previous installation....

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...

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...

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....

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...

This video describes the new feature in EDB Postgres™️ Enterprise Manager (PEM) 7.1 that enables users to Show/Hide acknowledged alerts on the Alert Dashboard. There is a chart setting called "Show Acknowledged Alerts". If it's value is "Yes", then all the acknowledged alerts will be visible,...

 Learn how to use the pgAdmin GUI in Standard Server (Postgres Studio in Advanced Server) to safeguard Postgres Plus databases. You will then be able to build a database and an application for a Technical Evaluation, knowing you can easily create intermittent database backups of your work and...

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...

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...

Postgres Streaming Replication provides fast binary movement of transaction data in asynchronous or synchronous modes for use in a variety of use cases ranging from up-to-the-minute reporting servers to 9s based high availability clusters.  See how easy setup is in EDB Postgres Advanced Server...

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...

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.

Learn how to use pg_dump and pg_restore to safeguard Postgres Plus databases. You will then be able to build a database and an application for a Technical Evaluation, knowing you can easily create intermittent database backups of your work and restore them if needed.

This EnterpriseDB Quick Tutorial helps you get started with the EDB Postgres Enterprise or EDB Postgres Standard database products in a Microsoft Windows environment. Master the basic operations of EDB Postgres and get into the interesting parts of your evaluation faster.