Freebsd postgresql

Install

• pkg install -y postgresql96-server

Enable

• sysrc postgresql_enable="YES"

Initdb

• service postgresql initdb

Start

• service postgresql start

Create a user and a database

• su postgres
• createuser -P user_test
• createdb db_test -O user_test

Links

• https://cwharton.com/blog/2016/10/postgresql-and-freebsd-quick-start/