1.

What Are The Tools Available In Greenplum To Take Backup And Restores?

Answer»

For non-parallel BACKUPS:

  • Use postgres utililities (pg_dump, pg_dumpall for backup, and pg_restore for RESTORE).
  • Another USEFUL command for getting DATA out of database is the COPY <TABLE> to <File>.

For parallel backups:

  • gp_dump and gpcrondump for backups and gp_restore for restore process.

For non-parallel backups:

For parallel backups:


Discussion

No Comment Found

Related InterviewSolutions