Instant PostgreSQL Backup and Restore How-to电子书

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 objects

Compressed 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 standalone

Database 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 logs

Restoring 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