Book Image

PostGIS Cookbook

Book Image

PostGIS Cookbook

Overview of this book

Table of Contents (18 chapters)
PostGIS Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Backing up the database


Having functional backups of your data and work is probably the least appreciated, yet the most important thing you can do for your productivity (and stress level). You may think that you don't need to have backups of your PostGIS database because you have the original data imported to the database. But, do you remember all the work you did to develop the final product? How about the intermediary products? Even if you remember every step in the process, how much time will it take to create the intermediary and final products?

If any of these questions gives you pause, you need to create a backup for your data. Fortunately, PostgreSQL makes the backup process painless or at least less painful than the alternatives.

Getting ready

In this recipe, we use PostgreSQL's pg_dump utility. The pg_dump utility ensures that the data being backed up is consistent, even if it is currently in use.

How to do it...

Use the following steps to back up a database.

  1. Start by backing up the chapter10...