East Baton Rouge Parish Library

Instant PostgreSQL Backup and Restore How-to

eng

no index present

non fiction

Instant PostgreSQL Backup and Restore How-to

dictionaries

1836400784

Filled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. This hands-on guide provides a quick and easy way to back up and restore your database using PostgreSQL. Written for database administrators who want to create backups of their critical enterprise data and efficiently restore it using PostgreSQL

Instant PostgreSQL Backup and Restore How-to; Instant PostgreSQL Backup and Restore How-to; Credits; About the Author; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Errata; Piracy; Questions; 1. Instant PostgreSQL Backup and Restore How-to; Getting a basic export (Simple); Getting ready; How to do it ... ; How it works ... ; There's more ... ; Restoring the exportExporting global objectsCompressed backups; Naming backups; Partial database exports (Simple); Getting ready; How to do it ... ; How it works ... ; There's more ... ; Compressed exports; Table-only exports; Schema-only exports; Data and schema-only exports; Restoring a database export (Simple); Getting ready; How to do it ... ; How it works ... ; There's more ... ; Parallel database restore; Database targeting; Partial database restores; Obtaining a binary backup (Simple); Getting ready; How to do it ... ; How it works ... ; There's more ... ; Viewing backup progress; Compressed tape archive backupsMaking the backup standaloneDatabase clones; Parallel compression; Stepping into TAR backups (Intermediate); Getting ready; How to do it ... ; How it works ... ; There's more ... ; Parallel compression; Making a tar backup standby-ready; Backing up tablespaces; Backing up archived transaction logs; Taking snapshots (Advanced); Getting ready; How to do it ... ; How it works ... ; There's more ... ; Proper snapshot sizing; Snapshot backup targets; Synchronizing backup servers (Intermediate); Getting ready; How to do it ... ; How it works ... ; There's more ... ; Speeding up rsync; Whole file syncExclude transaction logsRestoring a binary backup (Simple); Getting ready; How to do it ... ; How it works ... ; There's more ... ; No extract for rsync backups; Remote data copies; Point in time recovery (Intermediate); Getting ready; How to do it ... ; How it works ... ; There's more ... ; Named restore points; Timelines; Warm and hot standby restore (Intermediate); Getting ready; How to do it ... ; How it works ... ; There's more ... ; Trigger a backup online; Backup database promotion; Hot standby; Asynchronous archival; Streaming replication (Advanced); Getting ready; How to do it ... ; How it works ..There's more ... Synchronous backup; Synchronous backup caveates; Streaming backups