To connect QGIS to a PostGIS database, use the Browser panel to create a new PostgreSQL connection. You’ll need to provide the host, port, database name, and a QGIS authentication configuration—not basic auth. Authentication settings are stored securely within your QGIS profile and include a username, password, and a shared Authentication ID to prevent “Unavailable…

In this tutorial, you will create the basic structure of an enterprise spatial database. It will have schemas for each major category of data, such as transportation and hydrology. You will also learn how to create, rename, edit, and move tables in the database using the QGIS Browser Panel and DB Manager. What You’ll Learn…

QGIS layer symbology can be saved into a PostgreSQL database from which the associated layer resides. Whereas projects are stored in individual project tables in each schema, symbologies are stored centrally in a single table that resides in the public schema. The table is called layer_styles and it stores all symbologies associated with any table…

This tutorial reviews the process of using native QGIS tools with PostGIS layers and shows how this functionality can be used in an enterprise environment. What You’ll Learn in this Tutorial Prerequisites Introduction Layers loaded from PostgreSQL work exactly the same as layers that are loaded from Shapefiles, Geopackages, or any other vector format. The…

QGIS uses the default profile when first installed. QGIS Profiles store a user’s bookmarks, any custom settings, models, scripts, and perhaps most importantly, the user’s connections and authentication database. The authentication database is protected using the QGIS Master Password. In an enterprise environment, QGIS Profiles are very helpful when testing user database access. One can…