This section describes the available features for the ObjectRocket hosted PostgresSQL offering.
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.
ObjectRocket currently supports PostgreSQL versions 11 and 12.
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.
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.
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.