PostgreSQL with PostGIS Data Source Properties

PostgreSQL is an object-relational database management system (ORDBMS). It is released under an MIT-style license and is thus free and open source software. PostgreSQL supports a large part of the SQL standard and offers many features:

§ Complex queries

§ Foreign keys

§ Triggers

§ Views

§ Transactional integrity

§ Multi-version concurrency control

PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.

Note: SGS support for PostgreSQL with PostGIS only includes feature layers.

Note: SGS supports transactions from PostgreSQL data sources.

The following parameters are relevant for PostgreSQL with PostGIS data source:

Field	Description
Name	Name of the data source.
Description	Free text description of the data source.
Data Source Type	Data source type.
View Access	The default view permission level for all layers from this data source, i.e., the users that have been granted view access (None, Only Me, My Group, My Site, Everyone, or Selected List). A different permission level can be set for any individual layer from the Layers page. See “Editing Layer Properties” in the “Working with Layers” chapter for information. Users with valid view access for a layer can list, view and load the layer (opened from TerraExplorer Desktop, TerraExplorer for Web, WFS/WMS clients, etc.). If you want to grant access to selected groups, users, or sites see “Granting Edit or View Access” in this chapter for information.
Edit Access	The default edit permission level for all layers from this data source, i.e., the users that have been granted edit access (None, Only Me, My Group, My Site, Everyone, or Selected List). A different permission level can be set for any individual layer from the Layers page. See “Editing Layer Properties” in the “Working with Layers” chapter for information. In addition to loading the layer, users with valid edit permission for a layer can perform layer transactions from TerraExplorer Pro and any WFS-T client. If you want to grant access to selected groups, users, or sites see “Granting Edit or View Access” in this chapter for information. Note: Only the owner and the administrator can modify layer properties.
Owner	Select the name of the user who will be owner of all layers from this data source. Only an owner or administrator can modify layer properties.
Server	Server name (mandatory).
Port	Port number.
Database	Database name (optional).
User	User name required to connect to the data source.
Password	Password required to connect to the data source.
Auto Scan	If you want SGS to scan the data source periodically for changes, select the check box, and enter the required time interval between scans. When a data source is auto-scanned, the following updates are made to SGS: § All new layers are automatically added. § All layers deleted from data source are automatically removed. § All previously published layers that were modified are updated in SGS.