Overview

PostgreSQL database service with TimescaleDB and PostGIS installed. Deployed with Railway's SSL-enabled image.

Note that postgis is installed but not enabled. To enable it, simply connect to the DB and execute CREATE EXTENSION postgis;

Versions

• PostgreSQL 16
• TimescaleDB 2.13
• PostGIS 3.4.1

Extensions

1. TimescaleDB A time-series database built on top of PostgreSQL.

Engineered to efficiently handle resource-intensive workloads, like time series, event, and analytics data. Built on PostgreSQL, with expert support at no extra charge.

• Timescale Documentation

2. PostGIS Extends PostgreSQL by adding support for storing, indexing, and querying geographic data.

PostGIS is an open source software program that adds support for geographic objects to the PostgreSQL object-relational database. PostGIS follows the Simple Features for SQL specification from the Open Geospatial Consortium

• PostGIS Documentation