Packt+ | Advance your knowledge in tech

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

PostGIS Cookbook. - Second Edition

You're reading from PostGIS Cookbook. - Second Edition

Product type Book

Published in Mar 2018

Publisher

ISBN-13 9781788299329

Pages 584 pages

Edition 2nd Edition

Languages

Concepts

Geospatial Analysis

Authors (6):

Paolo Corti

Pedro Wightman

Bborie Park

Stephen Vincent Mather

Thomas Kraft

Mayra Zurbarán

View More author details

Table of Contents (18) Chapters

Title Page

Packt Upsell

Contributors

Preface

1. Moving Data In and Out of PostGIS

2. Structures That Work

3. Working with Vector Data – The Basics

4. Working with Vector Data – Advanced Recipes

5. Working with Raster Data

6. Working with pgRouting

7. Into the Nth Dimension

8. PostGIS Programming

9. PostGIS and the Web

10. Maintenance, Optimization, and Performance Tuning

11. Using Desktop Clients

12. Introduction to Location Privacy Protection Mechanisms

1. Other Books You May Enjoy

Leave a review - let other readers know what you think

Index

Replicating a PostGIS database with streaming replication

The reality of the world is that, given enough time, everything will break. This includes the hardware and software of computers running PostgreSQL. To protect data in PostgreSQL from corruption or loss, backups are taken using tools such as pg_dump. However, restoring a database backup can take a very long time, during which users cannot use the database.

When downtime must be kept to a minimum or is not acceptable, one or more standby servers are used to compensate for the failed primary PostgreSQL server. The data on the standby server is kept in sync with the primary PostgreSQL server by streaming data as frequently as possible.

In addition, you are strongly discouraged from trying to mix different PostgreSQL versions. Primary and standby servers must run the same PostgreSQL version.

Getting ready

In this recipe, we will use the streaming replication capability introduced in PostgreSQL 9.X. This recipe will use one server with two...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $15.99/month. Cancel anytime}

Authors (6)

Paolo Corti

Paolo Corti is an environmental engineer with 20 years of experience in the GIS field, currently working as a Geospatial Engineer Fellow at the Center for Geographic Analysis at Harvard University. He is an advocate of open source geospatial technologies and Python, an OSGeo Charter member, and a member of the pycsw and GeoNode Project Steering Committees. He is a coauthor of the first edition of this book and the reviewer for the first and second editions of the Mastering QGIS book by Packt.

See other products by Paolo Corti

Pedro Wightman

Pedro M. Wightman is an associate professor at the Systems Engineering Department of Universidad del Norte, Barranquilla, Colombia. With a PhD in computer science from the University of South Florida, he's a researcher in location-based information systems, wireless sensor networks, and virtual and augmented reality, among other fields. Father of two beautiful and smart girls, he's also a rookie writer of short stories, science fiction fan, time travel enthusiast, and is worried about how to survive apocalyptic solar flares.

See other products by Pedro Wightman

Bborie Park

Bborie Park has been breaking (and subsequently fixing) computers for most of his life. His primary interests involve developing end-to-end pipelines for spatial datasets. He is an active contributor to the PostGIS project and is a member of the PostGIS Steering Committee. He happily resides with his wife Nicole in the San Francisco Bay Area.

See other products by Bborie Park

Stephen Vincent Mather

Stephen Vincent Mather has worked in the geospatial industry for 15 years, having always had a flair for geospatial analyses in general, especially those at the intersection of Geography and Ecology. His work in open-source geospatial databases started 5 years ago with PostGIS and he immediately began using PostGIS as an analytic tool, attempting a range of innovative and sometimes bleeding-edge techniques (although he admittedly prefers the cutting edge).

See other products by Stephen Vincent Mather

Thomas Kraft

Thomas J Kraft is currently a Planning Technician at Cleveland Metroparks after beginning as a GIS intern in 2011. He graduated with Honors from Cleveland State University in 2012, majoring in Environmental Science with an emphasis on GIS. When not in front of a computer, he spends his weekends landscaping and in the outdoors in general.

See other products by Thomas Kraft

Mayra Zurbarán

Mayra Zurbaran is a Colombian geogeek currently pursuing her PhD in geoprivacy. She has a BS in computer science from Universidad del Norte and is interested in the intersection of ethical location data management, free and open source software, and GIS. She is a Pythonista with a marked preference for the PostgreSQL database. Mayra is a member of the Geomatics and Earth Observation laboratory (GEOlab) at Politecnico di Milano and is also a contributor to the FOSS community.

See other products by Mayra Zurbarán

Other recommended products

Related to this chapter

Mastering PostGIS

Mastering PostGIS

PostGIS is an open source spatial database system that offers a wider array of spatial analysis function and representation of geometric data types to databases. This book offers a tailored approach to practice common and most complex geo-processing tasks experts do with ease to design efficient GIS systems. Through the course of the book, not only will you learn what are the different data types, spatial querying, indexing and other complex operations on data, but also learn to create an end to end GIS solution. This book aims to teach you how to get maximum out of PostGIS and integrate it with other platforms like Geoserver, Opelayers, Javascript libraries to create a fully analytical GIS application.

May 2017 10 hours 56 minutes

GeoServer Beginner's Guide

GeoServer Beginner's Guide

GeoServer is an open-source server written in Java that allows users to share, process, and edit geospatial data. This book will guide you through the new features and improvements of GeoServer and will help you get started with it. GeoServer Beginner's Guide gives you a kick-start to build custom maps using your data without the need for costly commercial software licenses and restrictions. Even if you do not have prior GIS knowledge, you will be able to make interactive maps after reading this book.

Oct 2017 12 hours 48 minutes

Mastering Geospatial Analysis with Python

Mastering Geospatial Analysis with Python

Python comes with many libraries and tools that help you work on geoprocessing tasks without investing in expensive tools. This book introduces you to new libraries that perform geospatial and statistical analysis and data management. It uses examples that explain how Python v3 differs from v2, and solve age-old problems in geospatial analysis.

Apr 2018 14 hours 40 minutes

Hands-On Geospatial Analysis with R and QGIS

Hands-On Geospatial Analysis with R and QGIS

Managing spatial data has always been challenging and it’s getting more complex as the size of data increases. This book is your companion to understand, manage, and analyze spatial data effectively using R and QGIS. You’ll learn to use different statistical analyses with spatial data and automate spatial tasks. You’ll also learn to classify remote sensing data and use a machine learning approach to map landslide susceptibility.

Nov 2018 11 hours 48 minutes

QGIS 3.4 is a user-friendly open source geographic information system (GIS) that runs on Linux, Unix, Mac OS X, and Windows. The book will take you on a journey from firing up QGIS for the first time to developing your own processing pathway. We’ll look at the fundamentals of GIS: data creation, data display, creating maps and spatial analysis.

Nov 2018 9 hours 4 minutes

Learning Geospatial Analysis with Python

Learning Geospatial Analysis with Python

Geospatial Analysis is used in almost every field you can think of from medicine to defense, to farming. Learning Geospatial Analysis with Python, Third Edition would be a helpful guide to Geographic Information Systems and Remote Sensing Analysis using Python 3.7 without overwhelming the reader.

Sep 2019 15 hours 12 minutes

The most commonly used GIS tools automate tasks that were historically done manually—compiling new maps by overlaying one on top of the other or physically cutting maps into pieces representing specific study areas, changing their projection, and getting meaningful results from the various layers by applying mathematical functions and operations. This book is an easy-to-follow guide to use the most matured open source GIS tools for these tasks.

Jun 2017 14 hours 16 minutes

Expert Geoserver

Expert Geoserver

In this book, you'll learn how to publish geospatial processing algorithms through WPS, and put your GeoServer-based web application into fast, user-friendly, and secure production. By the end of this book, you will be able to deploy a professional-quality secure, and user-specific GeoServer-backed web mapping and processing application through a modern, cloud-hosting infrastructure.

Jul 2018 4 hours 28 minutes

QGIS Python Programming Cookbook

QGIS Python Programming Cookbook

QGIS is a desktop geographic information system that facilitates data viewing, editing, and analysis. Based on version QGIS 2.18, this book will teach you how to write Python code that works with spatial data to automate geoprocessing tasks in QGIS.

Mar 2017 15 hours 28 minutes

Mastering Geospatial Development with QGIS 3.x

Mastering Geospatial Development with QGIS 3.x

This book is a guide for professionals looking to master the open source QGIS software. This book will take you all the way through to learning advanced techniques like illuminated contours and dynamic masking. You will learn about the advanced topics like the creation of GeoPackages, the Processing Toolbox, and the creation of plugins using PyQGIS.

Mar 2019 15 hours 32 minutes

Personalised recommendations for you

Based on your interests and search pattern

C++ Programming for Linux Systems

C++ Programming for Linux Systems

This book covers the essential system programming tools and helps you explore the features of C++20. It emphasizes important details to maintain code quality and tackle everyday challenges of developing software for high performance, optimization, and more.

Sep 2023 9 hours 36 minutes

Discover advanced programming techniques, the latest features of C++17 and C++20, and best practices for memory management, debugging, testing, and large-scale application design with Expert C++. Ideal for experienced developers advancing to proficient programmers and building professional-grade C++ applications.

Aug 2023 20 hours 8 minutes

iOS 17 Programming for Beginners

iOS 17 Programming for Beginners

iOS 17 Programming for Beginners, Eighth Edition is your comprehensive guide to learning the art of iOS app development. Whether you dream of creating the next chart-topping app or simply want to enhance your programming skills, this book is your trusted companion on this exciting journey.

Oct 2023 20 hours 8 minutes

Developer Career Masterplan

Developer Career Masterplan

Written by industry experts that have spent the last 20+ years helping developers grow their career path towards senior developer positions and beyond. This book provides a comprehensive guide, sharing examples and stories from their global careers. By the end, you’ll have the knowledge to create a clear career progression plan as a technical professional.

Sep 2023 10 hours 20 minutes

Refactoring with C#

Refactoring with C#

In Refactoring with C#, you’ll explore the process of safely refactoring modern .NET code using Visual Studio features, advanced unit tests, AI assistance, and custom Roslyn analyzers.

Nov 2023 14 hours 28 minutes

Python Real-World Projects

Python Real-World Projects

Amplify your developer journey by curating a dynamic project portfolio that outshines traditional resumes. Delve into the Python realm through immersive projects, mastering core concepts while constructing comprehensive modules and applications. From data acquisition prowess to impactful data visualization, Python Real-World Projects arms you with essential skills to beat the competition.

Sep 2023 15 hours 56 minutes

The MVVM Pattern in .NET MAUI

The MVVM Pattern in .NET MAUI

The MVVM Pattern in .NET MAUI enables developers to master MVVM principles and effectively apply them to .NET MAUI. This book uses real-life examples and covers complex problems to help you successfully apply MVVM with .NET MAUI to confidently develop robust and high-performing cross-platform apps.

Nov 2023 12 hours 52 minutes

Extending Microsoft Business Central with Power Platform

Extending Microsoft Business Central with Power Platform

Extending Business Central with the Power Platform is a step-by-step guide for Business Central professionals to create solutions that automate business processes, explain complex workflow approvals, and integrate with hundreds of other systems, without traditional development. It’ll guide you in customizing Business Central with Power Platform.

Aug 2023 15 hours 16 minutes

Extending Microsoft Business Central with Power Platform

Extending Microsoft Business Central with Power Platform

Extending Business Central with the Power Platform is a step-by-step guide for Business Central professionals to create solutions that automate business processes, explain complex workflow approvals, and integrate with hundreds of other systems, without traditional development. It’ll guide you in customizing Business Central with Power Platform.

Aug 2023 15 hours 16 minutes

Quantum Computing Algorithms

Quantum Computing Algorithms

The book emphasizes intuitive ideas behind quantum algorithms in ways that other books don’t cover, striking a careful balance between no math and too much math. To get the most from this book, you should be comfortable with basic algebra and writing simple computer code. No prior understanding of quantum physics is needed to get started.

Sep 2023 11 hours 24 minutes

Python – Complete Python, Django, Data Science and ML Guide

Python – Complete Python, Django, Data Science and ML Guide

Unlock Python's full potential with this 50+ hour course! From programming to web and game development, data manipulation, and machine learning, gain the skills required to succeed in various Python-related careers. With practical tasks, hands-on experience, and a strong foundation in Python, you'll be ready to tackle real-world challenges and take advantage of the many opportunities this versatile language offers.

Nov 2023 50 hours 30 minutes

Python – Complete Python, Django, Data Science and ML Guide

Python – Complete Python, Django, Data Science and ML Guide

Unlock Python's full potential with this 50+ hour course! From programming to web and game development, data manipulation, and machine learning, gain the skills required to succeed in various Python-related careers. With practical tasks, hands-on experience, and a strong foundation in Python, you'll be ready to tackle real-world challenges and take advantage of the many opportunities this versatile language offers.

Nov 2023 50 hours 30 minutes