PostgreSQL Quickstart

PostgreSQL is an open source, object-relational database built with a focus on extensibility, data integrity, and speed. Its concurrency support makes it fully ACID compliant, and it supports dynamic loading and catalog-driven operations to let users customize its data types, functions, and more.

Create PostgreSQL Database Clusters

  1. From the Create menu in the top right of the control panel, click Databases.
  2. Select PostgreSQL as the database engine.
  3. Choose the cluster configuration and datacenter, and give the cluster a unique name.
    Tip
    For the best performance, create your database cluster in the same region as your Droplets.
  4. Click Create a Database Cluster.

Change Size or Number of Cluster Nodes

  1. Select your database cluster from the Databases page.
  2. Click the Settings tab.
  3. Click Edit in the Cluster configuration section.
  4. Select the node size and number of optional standby nodes.
  5. Click Save.

Relocate or Migrate Database Clusters

  1. Select your database cluster from the Databases page.
  2. Click the Settings tab.
  3. Click Edit in the Cluster datacenter section.
  4. Select the region and datacenter to which you want to relocate/migrate your cluster.
  5. Click Save.

Add Additional Users or Databases

  1. Select your database cluster from the Databases page.
  2. Click the Users & Databases tab.
  3. Enter users or database names in the corresponding field.
  4. Click Save.

Use a client application or command-line tool to manage specific user permissions.

Create Connection Pools

  1. Select your database cluster from the Databases page.
  2. Click the Connection Pools tab.
  3. Click Create a Connection Pool.
  4. Enter your pool name, the logical database to which the pool will connect, the user it will connect with, the pooling mode, and the pool size.
  5. Click Create Pool.

Delete Database Clusters

  1. Select your database cluster from the Databases page.
  2. Click the Settings tab.
  3. Click Destroy in the Destroy this database cluster section.
  4. Enter the name of the database cluster.
  5. Click Destroy.