TIR DBaaS

TIR DBaaS gives you a managed PostgreSQL database. You pick a PostgreSQL version, a compute plan, and a disk size, and set the first login; TIR sets up and manages the database. The pgvector extension is chosen for you when you create a database, so the same database can hold embeddings for vector search alongside ordinary relational data. DBaaS is available in Chennai.

Where to find it

In TIR, open a project in Chennai. In the side menu, under Databases, select DBaaS. Your databases are listed in Manage Databases, and Create Database starts a new one. Parameter Groups, the other entry under Databases, holds the engine settings you can attach to databases.

What you can do

Create and connect

• Create a database with a PostgreSQL version, a plan, a disk, the IP ranges that can connect, and the extensions it needs.
• Connect to a database with a connection string, psql, JDBC, or a ready-made snippet for your framework.
• Reset a user’s password when a password is lost or needs changing.
• Control network access with the IP allowlist and a VPC.

Protect your data

• Take a snapshot of a database while it stays online.
• Schedule snapshots every 6 hours, daily, weekly, or on your own cron schedule.
• Restore a database from a snapshot into a new database.

Change and tune

• Edit a database to add storage or change its network and advanced settings.
• Use parameter groups to set PostgreSQL parameters once and attach them to databases.
• Add extensions such as pgvector, pg_trgm, and pgcrypto.

Operate

• Monitor a database with charts of CPU, memory, storage, disk, and network, and its activity timeline.
• Stop, start, and restart a database.
• Delete a database once you are done with it.

Learn how it works

Read How TIR DBaaS works for what a database is made of, how it is reached, and what each status means. Billing for TIR DBaaS explains how a database is charged.

Where to start

Start with Get started with TIR DBaaS, which creates a PostgreSQL database and connects to it with psql. The TIR DBaaS FAQ has short answers, and Troubleshooting TIR DBaaS helps with each message. To create and manage databases from code, see the API reference.