Creating a New Database

To create a new database, select the Databases node in the navigation tree control; then, select the + New Database icon located in the upper-right corner of the page. When the Create New Database dialog opens, use the fields on the dialog to define your database.

• Provide a name for the database in the Database Name field.

• Optionally, provide a Display Name to identify the database in the navigation tree control. If you have more than one database with the same name, a Display Name can help you easily identify each database in the navigation tree control.

Select the cluster you would like to host your new database from the options shown under Select a Cluster. Use the Show Map toggle to display a map of the node locations for the selected cluster.

• If you are a pgEdge Enterprise Edition user, the dialog displays your clusters and their deployment regions. Check the box in a cluster pane to deploy on that cluster.

• If you are a pgEdge Developer Edition user, you can choose from three cluster configurations for testing and experimentation:

  • US - Europe offers an East Coast/West Coast US configuration with one server in Frankfurt.
  • US offers an East Coast/Midwest/West Coast configuration.
  • Global offers servers on the West Coast, in Frankfurt, and Singapore.

Specify the version of Postgres that you would like to install in the PostgreSQL Version field:

Implementing a Backup Strategy

The Backup Configuration dialog allows you to select the backup provider and configuration you wish to use for your Enterprise Edition databases.

Use fields in this section to select the backup strategy for your Enterprise Edition database:

• Select pg_dump to use pg_dump for backups. Note that if you select pg_dump, you cannot customize the backup schedule and storage details, but backups can be downloaded for use on other systems.
• Check the box next to pgBackRest to use pgBackRest for backups. Note that if you do choose to use pgBackRest for backups, you can customize the backup schedule and storage, but backups cannot be downloaded.

By default, pgBackRest is the selected backup utility; the first Backup Store (opens in a new tab) you attach to the cluster will be pre-configured with a default configuration that applies to all database nodes. The configuration defines a schedule that includes a daily full backup, with hourly incremental backups, but you can modify the schedule. There must be at least one configuration if your selected backup provider is pgBackRest, so configurations can only be removed from the form if there is more than one.

Additional Database Installation Options

The Options section displays optional features you can enable when your database is provisioned:

• Use the toggle switch next to Enable automatic DDL replication to turn on automatic DDL updates (opens in a new tab).
• Use the toggle switch next to Enable REST API to enable the pREST API; you can use the API to enable HTTPS connections (opens in a new tab) to your database. For more information about using pRESTd, visit the project site (opens in a new tab).
• Use the toggle switch next to Install Northwind Database to install the Northwind sample database and schema objects.
• Use the toggle switch next to Enable AWS CloudWatch Metrics to share metrics with AWS CloudWatch (opens in a new tab).
• Use the toggle switch next to Enable pgcat to enable the pgcat connection pooler on your database.

When you've made your selections, click Create Database to initialize a PostgreSQL database and start replicating data between the nodes in the cluster. Your new database is added to the list of databases in the left pane of the console; a green dot to the left of the name indicates that the database is available for connections.