Getting started with PostgreSQL

This getting started guide provides information about using the hosted PostgreSQL offering from ObjectRocket.

Creating a PostgreSQL instance

You can create a PostgreSQL instance in the following ways:

• From the ObjectRocket API

• From the Mission Control interface

Creating a PostgreSQL instance by using the API

View the ObjectRocket API documentation for instructions about using the API to create a PostgreSQL instance.

Creating a PostgreSQL instance by using Mission Control

1. Log in to Mission Control.

2. Select Create Instance.

3. Enter a name for your new PostgreSQL instance.

4. Select PostgreSQL from Select Your Service.

5. Select a cloud provider to host your instance.

6. Select a version and region from the drop-down menus.

7. Select Go to Step 2.

8. Select the appropriate storage and memory capacity.

   You can customize your instance by adding Replicas for HA.

   If you choose to add replicas for high availability, you should also select the three dots in the upper-right area of Customize Your Instance to choose how many replicas you want to create. The current options are one or two.

9. Select Go To Step 3.

10. Enter the IP address that you want to grant access to your instance.

    You can also choose to grant access to any IP address or use your current IP address.

    Only the IP address is mandatory, but descriptions can help when maintaining larger lists.

    Note

    ObjectRocket denies access by default, so you need to make the appropriate selections to let servers to connect.

11. Select Create Instance to spin up your PostgreSQL instance.

12. To add user for the instance, select Add Users in the upper-right corner.

13. Enter an administrator username and password.

14. Select admin and then select the checkmark to finish.