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 restore them if needed.
This EnterpriseDB Quick Tutorial helps you get started with thePostgres Plus Standard Server or Postgres Plus Advanced Server database products in a Linux, Windows or Mac environment. It is assumed that you have already downloaded and installed Postgres Plus Standard Server or Postgres Plus Advanced Server on your desktop or laptop computer.
This Quick Tutorial is designed to help you expedite your Technical Evaluation of Postgres Plus Standard Server or Postgres Plus Advanced Server. For more informational assets on conducting your evaluation of Postgres Plus, visit the self-service web site, Postgres Plus Open Source Adoption.
In this Quick Tutorial you will learn how to do the following using the pgAdmin GUI console:
- Distinguish between backup formats
- Choose among various backup and restore options
- Create a plain text backup and restore it
- Create a custom archive backup and restore it
There are various methods and options available to back up and restore a Postgres Plus database. This Quick Tutorial will show you how to use the Postgres Plus utility programs pg_dump and pg_restore. These programs are executed on the command line and can therefore be incorporated into scripts if desired.
The graphical user interface for database administration in Postgres Plus Standard Server is named pgAdmin (Postgres Studio if you are using Advanced Server). The capabilities and appearance of pgAdmin and Postgres Studio are the same, and both give you a quick and easy way to back up and restore Postgres Plus database objects.
For the remainder of this Quick Tutorial, the discussion will refer to pgAdmin, though the capabilities described apply equally to Postgres Studio.
The actual backup and restore operations are carried out by the Postgres Plus command line utility programs pg_dump and pg_restore. When you use pgAdmin to back up or restore database objects, pgAdmin builds and executes a command that calls the pg_dump program or the pg_restore program with the appropriate parameters. You can view the pg_dump or pg_restore command built and executed by pgAdmin to help you better understand the backup or restore operation performed, and also to serve as a training aid for running pg_dump and pg_restore on the command line without using pgAdmin.
While using pgAdmin provides a simple and quick method of performing most common backup and restore operations, using pg_dump and pg_restore on the command line provides additional advanced options.
For complete information on how to create a backup file using pg_dump, see pg_dump in Chapter "PostgreSQL Client Applications" under VI. "Reference" of the PostgreSQL Core Documentation found on the Postgres Plus documentation web page.
For complete information on how to restore a backup file using pg_restore, see pg_restore in Chapter "PostgreSQL Client Applications" under VI. "Reference" of the PostgreSQL Core Documentation found on the Postgres Plus documentation web page.
This Quick Tutorial addresses one of several backup and restore strategies available in Postgres Plus. For a complete discussion of all the different backup and restore strategies available in Postgres Plus, see Chapter 24, "Backup and Restore" of the PostgreSQL Core Documentation found on the Postgres Plus documentation web page.
For a detailed description of the steps that show how to use pg_dump and pg_restore with Postgre Plus, please download the PDF: