<< 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
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"