Instant PostgreSQL Backup and Restore How-to

by Shaun M. Thomas

Covering advanced topics such as Warm and Hot standby restore and Streaming replication, Instant PostgreSQL Backup and Restore How-to gives you the power to make complete backups to guarantee you will always be able to restore your database to full working order!

http://www.packtpub.com/how-to-postgr...

54 pages, ebook

First published January 1, 2013

About the author

Shaun was born in 1977 in Olympia, WA with a major congenital heart defect. Until his corrective surgery in 1984, he could partake in very little physical activity due to lack of oxygen. This set the stage for him to become an avid reader.

After a short obsession with Forgotten Realms, Stephen King, and Melanie Rawn, he started writing a trilogy in 1994 that was unfortunately shelved due to the academic demands of the I.B. Program, later continuing with those of a double major in Mathematics and Computer Science at Cornell College. It's possible he'll revise the old notes and storyline and complete the series, but his new Phase Cycle currently demands most of his attention. The first book in this series, Rabbit Rue, first appeared on Shaun's publishing site, and was later published by Smashwords for offline reading as an eBook.

Shaun currently lives in the Chicago area with his wife Jennifer, who plans to start Ph.D. work in elementary music education in 2011.

Reviews

[R Palmtag · Rating 5 out of 5]

"Instant PostgreSQL Backup and Restore How-to" is a concise cookbook containing eleven recipes. The first three cover logical methods using the client applications bundled with PostgreSQL, e.g. pg_dumpall, pg_dump and pg_restore. The rest of the recipes cover physical methods of backing up and restoring the PostgreSQL binary files with data and transaction logs, from the pg_basebackup application to using tar, rsync or Linux Logical Volume Manager (LVM). My special interest focuses on the more advanced recipes for Point-in-time-recovery (PITR), warm and hot standby and streaming replication.
The steps are easy to follow, conveniently complemented by explanations on how it all works and more ideas to explore. This cookbook is a great addition to my PostgreSQL library and I look forward to use it for setting up replication in a Linux environment. Note that this book is targeted mostly at the Unix/Linux users.

[John Mccrea · Rating 5 out of 5]

I just finished reading "Instant PostgreSQL Backup and Restore How-to". This great little book is packed full of quick and easy to understand tips and tricks. As a SQL Server and Oracle DBA who is dabbling in MySQL and PostgreSQL this book is a perfect addition to my library toolset. The book is a quick read, easy to understand and details everything a DBA needs to know if they are new to PostgreSQL or if they are a seasoned PostgreSQL DBA. I was familiar with many of the commands described in this book, but I also learned some great tips about how compressed backups, point in time recoveries, snapshots, replication and other more intermediate and advanced database topics are implemented in PostgreSQL. Overall, I would gladly recommend this book to any DBA looking to expand their knowledge in PostgreSQL Backups and Restores.

[Marcos · Rating 5 out of 5]

I think this is a really interesting book. You can learn about backup and restore a PostgreSQL database and cluster in a simple and friendly way.

[Frank Mcgeough · Rating 3 out of 5]

Not bad. A general introduction to the various techniques used to backup and restore a Postgres database.

[Stompro · Rating 5 out of 5]

I found this to be a great reference for PostgreSQL backup methods.