Configure the Kong Gateway datastore on Linux

Uses: Kong Gateway

Deployment Platform:

Prerequisites

Install Kong Gateway

Install PostgreSQL

Install PostgreSQL on Ubuntu using the following steps:

Update the package list:
```
sudo apt update
```
Copied to clipboard!

Install PostgreSQL:

sudo apt install -y postgresql postgresql-contrib

Copied to clipboard!

Enable PostgreSQL to start on boot:
```
sudo systemctl enable postgresql
```
Copied to clipboard!

Configure environment variables

Set the following variables so that kong.conf can interact with the datastore:

  export KONG_DATABASE=postgres
  export KONG_PG_HOST=127.0.0.1
  export KONG_PG_PORT=5432
  export KONG_PG_USER=kong
  export KONG_PG_PASSWORD=super_secret
  export KONG_PG_DATABASE=kong

Copied to clipboard!

Configure PostgreSQL

Switch to the default PostgreSQL user:
```
 sudo -i -u postgres
```
Copied to clipboard!
Start the PostgreSQL shell:
```
 psql 
```
Copied to clipboard!

Create a kong user and password:

 CREATE USER kong WITH PASSWORD 'super_secret';

Copied to clipboard!

Create a database titled kong and assign the user as an owner:
```
 CREATE DATABASE kong OWNER kong;
```
Copied to clipboard!
Exit PostgreSQL, and exit the PostgreSQL shell:
```
 exit
```
Copied to clipboard!

Run a Kong Gateway database migration

kong migrations is used to configure the database for the first time. Running bootstrap forces Kong Gateway to bootstrap the database set up in the previous step and run all of the migrations:

kong migrations bootstrap

Copied to clipboard!

This command must be run as the root user.

Validate

You can validate that the datastore was configured correctly by starting Kong Gateway.

Start Kong Gateway:
```
 kong start
```
Copied to clipboard!
Verify the installation:
```
 curl -i http://localhost:8001
```
Copied to clipboard!
If you receive a 200 status code, Kong Gateway was configured correctly.