PostgreSQL features

This section describes the available features for the ObjectRocket hosted PostgresSQL offering.

Single-node PostgreSQL

PostgreSQL is a go-to, open-source relational database. It is a staple of many web applications. ObjectRocket offers a PostgreSQL instance that runs in a dedicated container with administrator access that lets you create and manage databases, users, and anything else you need.

Review the ObjectRocket cloud platform supported versions table for a list of supported versions.

User authentication

User-based authentication manages all access to the PostgreSQL instance. Create an administrator role from the ObjectRocket API or Mission Control interface. With the administrator role, you can then create more roles, users, databases, and other things.

Access control list and IP whitelisting

ObjectRocket blocks all external access to the cluster by default. To connect to the PostgreSQL instance, specify IPs and IP ranges that you want to get to access the cluster. You can grant access during instance creation, or via the IP whitelists in the Mission Control interface.

High availability

Add replicas to your PostgreSQL instance to reduce downtime, protect from data loss, and increase database performance. These replicas automatically replace the main database in the event of a failure. Select this feature during setup by using Mission Control or the API.

PostgreSQL extensions

Expand the capability of your PostgreSQL instance with extensions. ObjectRocket provides a list of supported plug-ins that enables you to change core features of the database. You can use SQL queries to activate extensions directly from the PostgreSQL datastore.