Cargando…
Instant PostgreSQL Backup and Restore How-to.
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 e...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2013.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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 export.
- Exporting 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 backups.
- Making 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 sync.
- Exclude 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.