How to Backup and Restore a Postgres Database with EDB Postgres™ Enterprise Manager

Introduction

EDB Postgres Enterprise Manager (PEM) is an enterprise management tool designed to assist database administrators, system architects, and performance analysts in administering, monitoring, and tuning PostgreSQL and EDB Postgres Advanced Server database servers.

EDB Postgres Enterprise Manager is the only tool that monitors, alerts, manages and tunes local and remote large scale Postgres deployments from a single graphical console. Out of the box features include: server auto-discovery, point and click management of database objects, 225+ pre-configured database alerts by SMTP/SNMP, global At-a-Glance monitoring dashboards, Performance monitoring dashboards, a Capacity Manager, an Audit Manager, Postgres Expert best practice configuration recommendations, a Log Manager, a Log Analyzer Expert, Team Management, a SQL Profiler, and Index Advisor.

The PEM client is distributed with Advanced Server. In this tutorial, you will learn how to use the PEM client to:

  • select backup and restore options
  • create a plain-text backup
  • create a clone of a database
  • create and restore from a custom archive backup

Download the Tutorial

 

For detailed information about installing Advanced Server, refer to the Postgres Enterprise Manager Installation Guide.