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

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

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

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

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

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

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

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

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

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,...Read more

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

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

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

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

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

This EnterpriseDB tutorial helps you install and learn basic operations for the Postgres Plus Advanced Server database solution in an HP-UX environment.Read more

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

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

EDB Postgres Enterprise Manager (PEM) is the only tool that monitors, alerts, manages and tunes local and remote large scale Postgres deployments from a single graphical console. In this tutorial, you will learn how to use the Postgres Enterprise Manager client.Read more

The Apache/PHP Stack is a pre-configured environment for deploying PHP based web application within the Postgres Plus environment. Learn how to quickly install the Postgres Plus Apache/PHP stack in a Mac OS X environment.

Installing Apache and PHP is a very simple process thanks to Apple...Read more

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

PostGIS is a powerful spatial database extension you can use with Postgres Plus Standard Server. This tutorial shows how quickly you can setup and begin using a spatially enabled database that can be applied to a variety of applications.Read more

Slony is a master to multiple slaves replication system with cascading and failover capabilities. When used with Postgres Plus, it becomes a powerful tool used for safeguarding data, failover/standby capabilities, optimizing online transaction processing, offloading reporting/BI queries, backup...Read more

PgBouncer is a lightweight connection pooler for Postgres Plus that dramatically reduces the processing time and resources for maintaining a large number of client connections to one or more databases. PgBouncer is typically used to increase the number of user connections that can be handled in...Read more

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

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

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