PostgreSQL features ==================== .. meta:: :description: Overview of the features available for the Objectrocket hosted PostgreSQL offering. 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. ObjectRocket currently supports PostgreSQL versions 11 and 12. 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 :doc:`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.