General database connection parameters

Irrespective of the database platform you use to serve your vector data, there is a set of parameters that is common to all. In this section, we will take a look at:

  • How primary keys can be managed
  • Database startup session scripts
  • Database shutdown session scripts

The primary key metadata table

While not necessary, it is usually best practice to have your database tables configured with a primary key. A primary key should be a unique value for each record in the table, and most often, it's not a simple integer incremented by some value, often 1, for each newly inserted record. GeoServer usually derives its feature ID values from the table's primary key column, and it will make assumptions about how to generate ...

Get Mastering GeoServer now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.