Step 3 - Configuring PGD repositories
=====================================

Configuring PGD repositories
----------------------------

To install and run PGD requires that you configure repositories so that
the system can download and install the appropriate packages.

Perform the following operations on each host. For the purposes of this
exercise, each host is a standard data node, but the procedure would be
the same for other :ref:`Node types <Node types>`  , such as witness or subscriber-only
nodes.

-  Use your EDB account. - Obtain your EDB repository token from the
   `EDB Repos 2.0 <https://www.enterprisedb.com/repos-downloads>`_  page.

-  Set environment variables. - Set the ``EDB_SUBSCRIPTION_TOKEN``
   environment variable to the repository token:

::

       export EDB_SUBSCRIPTION_TOKEN=<your-repo-token>

-  Configure the repository. - Run the automated installer to install
   the repositories:

..  Note Red Hat::
   edb_notranlate_1

..  Note Ubuntu/Debian::
  

::

       curl -1sLf "https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/postgres_distributed/setup.deb.sh" | sudo -E bash

Worked example
--------------

Use your EDB account
^^^^^^^^^^^^^^^^^^^^

You need an EDB account to install Postgres Distributed.

Use your EDB account to sign in to the `EDB Repos 2.0 <https://www.enterprisedb.com/repos-downloads>`_  page, where you can
obtain your repo token.

On your first visit to this page, select **Request Access** to generate
your repo token.

.. figure:: /images/edbrepos2.0.png
   :width: 70% 
   :alt: EDB Repos 2.0

   EDB Repos 2.0

Select **Copy Token** to copy the token to your clipboard, and store the
token safely.

Set environment variables
^^^^^^^^^^^^^^^^^^^^^^^^^

Set the ``EDB_SUBSCRIPTION_TOKEN`` environment variable to the value of
your EDB repo token, obtained in the :ref:`EDB account <EDB account>`  step.

::

   export EDB_SUBSCRIPTION_TOKEN=<your-repo-token>

You can add this to your ``.bashrc`` script or similar shell profile to
ensure it’s always set.

..  Note ::
   Your preferred platform may support storing this variable as a secret, which can appear as an environment variable. If this is the case, add it to your platform's secret manager, and don't add the setting to `.bashrc` .

Configure the repository
^^^^^^^^^^^^^^^^^^^^^^^^

All the software you need is available from the EDB Postgres Distributed
package repository. You have the option to download and run a script to
configure the EDB Postgres Distributed repository. You can also
download, inspect, and then run that same script.

The following instructions also include the essential steps that the
scripts take for any user wanting to manually run the installation
process or to automate it.

RHEL/Other RHEL-based
^^^^^^^^^^^^^^^^^^^^^

You can autoinstall with automated OS detection:

::

   curl -1sLf "https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/postgres_distributed/setup.rpm.sh" | sudo -E bash

If you want to inspect the script that’s generated for you, run:

::

   curl -1sLfO "https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/postgres_distributed/setup.rpm.sh"

Then inspect the resulting ``setup.rpm.sh`` file. When you’re ready to
proceed, run:

::

   sudo -E bash setup.rpm.sh

If you want to perform all steps manually or use your own preferred
deployment mechanism, you can use the following example as a guide.

You will need to pass details of your Linux distribution and version.
You may need to change the codename to match the version of RHEL you’re
using. This example sets it for RHEL-compatible Linux version 9:

::

   export DISTRO="el"
   export CODENAME="9"

Now install the yum-utils package:

::

   sudo dnf install -y yum-utils 

The next step imports a GPG key for the repositories:

::

   sudo rpm --import "https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/postgres_distributed/gpg.B09F406230DA0084.key"

Now you can import the repository details, add them to the local
configuration, and enable the repository.

::

   curl -1sLf "https://downloads.enterprisedb.com/$EDB_SUBSCRIPTION_TOKEN/postgres_distributed/config.rpm.txt?distro=$DISTRO&codename=$CODENAME" > /tmp/enterprise.repo
   sudo dnf config-manager --add-repo /tmp/enterprise.repo
   sudo dnf -q makecache -y --disablerepo=* --enablerepo=enterprisedb-postgres_distributed