PostgreSQL on FreeBSD

<< Click to Display Table of Contents >>

Navigation:  Supported database systems > PostgreSQL > PostgreSQL server configuration >

PostgreSQL on FreeBSD

Install PostgreSQL for FreeBSD by following these instructions:

 

How To Install PostgreSQL on FreeBSD

 

The article describes how to install version 11. We have installed version 14 by simply replacing references to 11 with 14.

 

So the command in the article:

 

sudo pkg install postgresql11-server postgresql11-client

 

becomes:

 

sudo pkg install postgresql14-server postgresql14-client

 

You will also need an additional package so that uuid-ossp extension can be installed:

 

sudo pkg install postgresql14-server postgresql14-contrib

Extensions

Dispatch requires the uuid-ossp extension.

 

Each time Dispatch connects to a PostgreSQL database, it will automatically try to create the extension by executing the following statement:

 

CREATE EXTENSION IF NOT EXISTS "uuid-ossp"