Installing postgREST

postgREST is supported on the same platforms as the Postgres distribution you're using. Support for postgREST starts with Postgres 12. For details, see:

• PostgreSQL Product Compatibility

Installation

Before you begin the installation process:

• Install Postgres. See:

  • Installing PostgreSQL

• Set up the repository.

  Setting up the repository is a one-time task. If you've already set up your repository, you don't need to perform this step.

  To set up the repository, go to EDB repositories and follow the instructions provided there.

Install the package

The syntax for the package install command is:

# For SLES, CentOS, RHEL and its derivatives
sudo <package-manager> -y install edb-<postgres><postgres_version>-postgrest2

# For Debian and Ubuntu
sudo <package-manager> -y install edb-<postgres><postgres_version>-postgrest2

Where:

• <package-manager>is the package manager used with your operating system:

  Package manager	Operating system
  dnf	RHEL 8/9 and derivatives
  zypper	SLES
  apt-get	Debian and derivatives

• <postgres> is the distribution of Postgres you're using:

  Postgres distribution	Value
  PostgreSQL	pg

• <postgres_version> is the version of Postgres you're using.

For example, to install postgREST for EDB Postgres 15 on a RHEL 8 platform:

sudo dnf -y install edb-pg15-postgrest2