Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

After successful installation of PostgreSQL and optional the PostgreSQL geospatial extension you can start using the database.
On windows PostgreSQL comes with the PGadmin III database manager.

Image Modified

You always need to log-in for accessing your database. Store your log-in credentials well.

Image Modified
Image Modified

By default the database instances inside the PostgreSQL server are not listed as active. Only when you click on them, the contents of the database can be folded like in a file explorer. The postgres database is present by default, the template_postgis_20 database was added when installing PostGIS,
and the sandbox database was added optionally by when installing PostGIS.

Image Modified
Image Modified
Image Modified

We are now opening the postgres database. When unfolding it, Catalogs, Extensions and Schemas appear.

Image Modified