PostGIS, the spatial extension that turns PostgreSQL into a full geographic database, ready to answer spatial queries the moment it boots.
PostGIS is the open source spatial extension for PostgreSQL, and the storage engine behind essentially every open source geographic stack. It adds geometry and geography column types to an ordinary relational database, spatial indexing so those columns stay fast at scale, and several hundred spatial SQL functions covering distance, containment, intersection, buffering and coordinate system transformation. Because it is an extension rather than a separate engine, spatial data lives alongside your ordinary tables and you query it with the same SQL, the same transactions, the same backups and the same tooling you already use.
It suits any workload where location is part of the data: serving map layers to a rendering or map server, storing and analysing survey, asset or sensor data that carries coordinates, powering proximity and catchment questions such as what is near this point or which region contains it, and acting as the spatial back end for desktop and browser based geographic tools.
cloudimg delivers PostGIS fully installed and spatially enabled, so a working spatial database answers the moment the instance boots, with a ready made database whose spatial extensions are already created. The image is secure by default and carries no usable login: it ships with no database at all, and on the first boot of every instance a one shot service builds a pristine database and generates a superuser password and a separate application password unique to that instance, writing them to a file only the root user can read. The database listens only on the loopback address by default, a deliberate choice for a data store, and the paired guide shows exactly how to open it to your own private network when you need to. Database files live on a dedicated volume, every component is installed from official package archives so security updates keep flowing automatically for the life of the release, the base is fully patched, and every deployment is paired with a step by step deploy guide and backed by 24/7 cloudimg support.