OpenGeo Suite User Manual
4.8
  • What’s new in 4.8
  • Introduction
    • What is OpenGeo Suite?
    • Installation
    • Dashboard
    • Composer
    • OpenGeo Suite extensions
    • Sample Data
    • More Information
  • Building web maps
    • Making maps with Composer
    • Creating a basic web map with GeoExplorer
  • Web cartography
    • Web map styling with YSLD
    • Rendering Transformations
  • Building complete web applications
    • Installing Boundless SDK
    • Creating and deploying apps with Boundless SDK
    • Application development with Boundless SDK GXP template
    • Application development with OpenLayers
  • Spatial processing and analysis
    • Introduction to Spatial Processing
    • Executing processes using WPS Builder
    • Creating WPS processes with Java
    • Using WPS with OpenLayers and the Boundless SDK
    • Scripting
    • Creating a contour map with a WPS process
    • Managing and preventing system overload from WPS processes
    • Process reference
  • Working with your data
    • Getting started with PostGIS
    • Data storage and management in PostGIS
    • Analyzing data with PostGIS
    • Database administration in PostGIS
    • Using Point Cloud
    • Working with Oracle data
    • Working with MongoDB
    • Working with GeoMesa data
    • Enabling GDAL image formats support
    • Enabling MrSID image support
    • Loading and publishing GeoPackage data
    • Using the vector tiles output
    • GeoServer Layer Importer
  • System administration
    • How to add startup parameters for GeoServer
    • Running OpenGeo Suite in Production
    • JVM settings
    • Using Tomcat Manager
    • Working with JNDI
    • How to enable Cross-Origin Resource Sharing (CORS)
    • Security
    • Allowing read-write access to vector data through transactions
    • Backing up
    • Using virtual services
    • Tile caching
    • Clustering
    • Monitoring GeoServer with CloudWatch
    • Working with libjpeg-turbo
    • Enabling the Marlin renderer
  • Using QGIS with OpenGeo Suite
    • Installing QGIS for OpenGeo Suite
    • OpenGeo Explorer plugin for QGIS
    • Web App Builder plugin for QGIS
  • Glossary
 
OpenGeo Suite User Manual
  • OpenGeo Suite »
  • Working with your data »
  • Getting started with PostGIS
Next Previous

Getting started with PostGIS¶

This section describes how to get started with the PostGIS database included in OpenGeo Suite—connecting to the database, loading data, and some basic SQL commands.

  • Connecting to PostgreSQL on Linux for the first time
    • Setting a password for the postgres user
    • Allowing local connections
    • Allowing remote connections
  • Connecting to the PostgreSQL database with pgAdmin
    • Launching pgAdmin
    • Working with pgAdmin
  • Creating a spatial database
    • Creating a spatial database from the command line
  • Loading data into PostGIS from the Command Line
    • How It Works
    • Preparation
    • Loading data
    • Batch loading
  • Loading data into PostGIS with pgShapeloader
    • How it works
    • Preparation
    • Launching pgShapeloader
    • Loading data
  • Loading raster data into PostGIS from the Command Line
    • How It Works
    • Preparation
    • Loading data
    • Batch Loading
    • Creating Raster Tables in the Database
  • Publishing a PostGIS table in GeoServer
  • Basic SQL
    • SELECT queries

For detailed reference information, please refer to the PostGIS Documentation.

Next Previous
© 2016 Boundless.
Report an Issue
  Component Manuals
  • GeoServer Spatial Server
  • GeoWebCache Map Tile Cache
  • PostGIS Spatial Database
  • QGIS Desktop GIS
  • Boundless SDK Web Client API
  • OpenLayers Web Mapping Library
  • GeoExplorer Web Map Viewer
Back to Suite User Manual
Based on RTD theme.