Skip to content

kongyew/greenplum-backup

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Readme

This repository provides examples on how to use gpcopy for Greenplum.

Build Status

Introduction

This example demonstrates the use case of transfering objects from databases in a source Greenplum Database system to databases in a destination Greenplum Database system.

<<<<<<< HEAD

Types of backup:

The following backup types are available for Greenplum database.

  • Full
  • Incremental

Use Case:

  1. Learn how to perform full backup and restore to file system
  2. Learn how to perform full backup and restore to S3
  3. Learn how to perform incremental backup
  4. Learn how to use GPDB plugin storage
  5. How to copy your database to another cluster

How to use:

  1. [Learn how to use gpbackup and gprestore]
  2. [Learn how to use gpcrondump]

Use gpbackup and gprestore

Now, you can run parallel backup solution for Greenplum. gpbackup and gprestore are designed to improve the performance, functionality, and reliability of backups as compared to gpcrondump and gpdbrestore.

gpbackup

gpbackup utilizes ACCESS SHARE locks at the individual table level, instead of EXCLUSIVE locks on the pg_class catalog table.

This enables you to execute DML statements during the backup, such as CREATE, ALTER, DROP, and TRUNCATE operations, as long as those operations do not target the current backup set.

Therefore, you can quickly run parallel backup to ensure your data is safely protected.

366de63d020d934525fef928b5cca4f5873c2763

gpcopy

The gpcopy utility copies objects from databases in a source Greenplum Database system to databases in a destination Greenplum Database system. For more details,please see this readme

<<<<<<< HEAD ** GPBackup ** alt text

** GPbackup and GPrestore ** alt text

=======

366de63d020d934525fef928b5cca4f5873c2763

Reference:

Greenplum

The Greenplum Database (GPDB) is an advanced, fully featured, open source data warehouse. It provides powerful and rapid analytics on petabyte scale data volumes. Uniquely geared toward big data analytics, Greenplum Database is powered by the world’s most advanced cost-based query optimizer delivering high analytical query performance on large data volumes. Greenplum Pivotal Greenplum Blog about Greenplum - gpbackup and gprestore

Releases

No releases published

Packages

No packages published

Languages