March 2018
Beginner to intermediate
584 pages
14h 31m
English
book
PostGIS Cookbook - Second Edition
by Stephen Vincent Mather, Pedro Wightman, Bborie Park, Thomas Kraft, Mayra Zurbarán, Paolo Corti
Content preview from PostGIS Cookbook - Second Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Migrating a PostGIS database to a different server
At some point, user databases need to be migrated to a different server. This need for server migration could be due to new hardware or a database-server software upgrade.
The following are the three methods available for migrating a database:
- Dumping and restoring the database with pg_dump and pg_restore
- Performing an in-place upgrade of the database with pg_upgrade
- Performing streaming replication from one server to another