/pg_manage

Scripts for automating automating backup and recovery tasks for PostgreSQL Database Server. Implements sending archive logs to backup server, retrieval of archive logs from backup server, initialization of database, generation of hot backups with archive logging, recovery from hot backup, dump (export) and restore (import) of databases, initial synchronization of database servers for setting up replication.

Primary LanguagePerlGNU General Public License v3.0GPL-3.0

pg_manage - Backup / Recovery Scripts for PostgreSQL Database

About

Scripts for automating automating backup and recovery tasks for PostgreSQL Database Server. The following operations have been implemented:

  • Sending archive logs to backup server.
  • Retrieval of archive logs from backup server.
  • Initialization of the database.
  • Generation of hot backups with archive logging.
  • Recovery from hot backup.
  • Dump (export) and restore (import) of databases.
  • Initial synchronization of database servers for setting up replication.
  • checking the replication between the primary and secondary PostgreSQL Servers in a Streaming Replication setup.

Sample configuration files have been provided for configuring the PostgreSQL Database Server for archive logging, recovery using archive logs and Streaming Replication.

For information on other projects you can check my GitHub Personal Page and GitHub Profile.

Documentation

The documentation for the project and sample graphs for plugins will be published in the pg_manage Project Web Page

Licensing

pg_manage is copyrighted free software made available under the terms of the GPL License Version 3 or later.

See the COPYING file that acompanies the code for full licensing information.

Credits

pg_manage has been developed by aouyar (Ali Onur Uyar).