Postgres is the worlds leading opensource relational database system. Its also the engine that backs many other database variants. It's support for geospatial data functionality through the postgis extention is dominating.