How to Install PostgreSQL on FreeBSD 12.2

Updated on July 29, 2021
How to Install PostgreSQL on FreeBSD 12.2 header image

Introduction

PostgreSQL is a free, powerful, and high-performance ORDBMS (Object-Relational Database Management System). It has extensive documentation and supports powerful features making it well suited for large databases systems. In this article, you'll learn how to install PostgreSQL server on FreeBSD 12.2.

Prerequisites

Install PostgreSQL Server 12

  1. Update the package list.

     $ sudo pkg update
  2. Download and install PostgreSQL 12 server and client packages.

     $ sudo pkg install postgresql12-server postgresql12-client
  3. Enable PostgreSQL service to start on system boot.

     $ sudo sysrc postgresql_enable=yes
  4. Initialize the database.

     $ sudo service postgresql initdb
  5. Start the PostgreSQL service.

     $ sudo service postgresql start
  6. Change to the PostgreSQL account.

     $ sudo su - postgres
  7. Change the postgres user password.

     psql -c "alter user postgres with password 'yourPassword'"
  8. Create a new user named admin.

     createuser admin
  9. Create a testdb database owned by user admin.

     createdb testdb -O admin
  10. Access the PostgreSQL interactive shell.

     psql
  11. List all databases.

     \l
  12. Exit the interactive shell.

     \q
  13. Exit the PostgreSQL instance

     exit

More Information

To learn more about PostgreSQL, please see the official documentation.