pgsql_contrib_freebsd_pg_trm_and_btree_gin.txt

pgsql_contrib_freebsd_pg_trm_and_btree_gin

Check  https://www.reddit.com/r/freenas/comments/7s1cgb/pkg_repository_freebsd_contains_packages_for/

freebsd-version -ku
11.0-RELEASE-p9
11.0-RELEASE-p11

pg_config --version

looking for 9.6.3

sudo pkg -f install libxslt

sudo mkdir -p /usr/local/etc/pkg/repos
sudo vi /usr/local/etc/pkg/repos/FreeBSD.conf

FreeBSD: {
  url: "pkg+http://pkg.FreeBSD.org/freebsd:11:x86:64/release_1",
  mirror_type: "srv",
  enabled: yes
}
sudo pkg install postgresql96-contrib-9.6.3


# Database updates
cat $POSTGRESQL_DATABASE
echo $POSTGRESQL_USERNAME

sudo su postgres
psql -d postgres

\l
\du
ALTER USER candidatedb  WITH SUPERUSER;
\du
\q