Installing the database and pgd v6.0.0

Suggest edits

On each host which you want to use as a PGD data node, you need to install the database and the PGD software.

Configure the repository

Set the following environment variables:

EDB_SUBSCRIPTION_TOKEN

This is the token you received when you registered for the EDB subscription. It is used to authenticate your access to the EDB repository.

export EDB_SUBSCRIPTION_TOKEN=<your-token>

EDB_SUBSCRIPTION_PLAN

This is the plan you subscribed to. It is used to determine which packages are available for installation. This is typically either standard or enterprise.

# Set the EDB subscription plan
export EDB_SUBSCRIPTION_PLAN=<your-plan>

EDB_REPO_TYPE

This is the type of package manager you use, which informs the installer which type of package you need. This can be deb for Ubuntu/Debian or rpm for CentOS/RHEL.

export EDB_REPO_TYPE=<your-repo-type>

Install the repository

Run the following command to install the EDB repository. This will add the EDB repository to your system's package manager, allowing you to install EDB packages.

curl -1sSLf "https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/$EDB_SUBSCRIPTION_PLAN/setup.$EDB_REPO_TYPE.sh" | sudo -E bash

Or for dev:

curl -1sSLf "https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/dev/setup.$EDB_REPO_TYPE.sh" | sudo -E bash
curl -1sSLf "https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/dev_postgres_distributed/setup.$EDB_REPO_TYPE.sh" | sudo -E bash

This command will download and run a script that configures your package manager to use the EDB repository. It will also install any necessary dependencies.

Install the database and PGD

After you have installed the EDB repository, you can install the database and PGD software using your package manager.

Set the Postgres version

Set an environment variable to specify the version of Postgres you want to install. This is typically 17 for Postgres 17.

export PG_VERSION=17

Set the PGD edition

Set an environment variable to specify the edition of Postgres you want to install. This can be essential for PGD Essential or expanded for PGD Expanded.

export PGD_EDITION=essential

Set the package names

EDB Postgres Advanced Server

export EDB_PACKAGES="edb-as$PG_VERSION-server edb-pgd6-$PGD_EDITION-epas$PG_VERSION"

EDB Postgres Extended

Community PostgreSQL

Note

Only PGD Expanded is available for Community PostgreSQL.

Install the database and PGD packages

This command will install the specified packages and any dependencies they require. Once the installation is complete, you will have the database and PGD software installed on your system.

Worked example

In this example, we will install EDB Postgres Extended Server 17 with PGD Essential on a CentOS/RHEL system using an enterprise subscription.

Set the environment variables

export EDB_SUBSCRIPTION_TOKEN=XXXXXXXXXXXXXX
export EDB_SUBSCRIPTION_PLAN=enterprise
export EDB_REPO_TYPE=rpm
export PG_VERSION=17
export PGD_EDITION=essential
export EDB_PACKAGES="edb-as$PG_VERSION edb-pgd6-$PGD_EDITION-epas$PG_VERSION"
curl -1sSLf " https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/$EDB_SUBSCRIPTION_PLAN/setup.$EDB_REPO_TYPE.sh" | sudo -E bash
sudo dnf install -y $EDB_PACKAGES
← Prev

Prerequisites for manual deployment

↑ Up

Manual deployment and configuration of PGD

Next →

Configuring the cluster