| Description |
1 online resource (101 pages) |
|
text file rda |
| Contents |
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. |
| Summary |
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. |
| Language |
English. |
| Subject |
PostgreSQL.
|
|
PostgreSQL. |
|
PostgreSQL |
|
Database management.
|
|
SQL (Computer program language)
|
|
Open source software.
|
|
Internet programming.
|
|
Bases de données -- Gestion. |
|
SQL (Langage de programmation) |
|
Logiciels libres. |
|
Programmation Internet. |
|
Database management |
|
Internet programming |
|
Open source software |
|
SQL (Computer program language) |
| Other Form: |
Print version: Thomas, Shaun. Instant PostgreSQL Backup and Restore How-to. Birmingham : Packt Publishing, ©2013 9781782169109 |
| ISBN |
9781782169116 |
|
1782169113 |
|
1782169105 |
|
9781782169109 |
|
1299441874 |
|
9781299441873 |
|
More Resources