Ivan Tomica

Installing PostgreSQL in FreeBSD jail

To install and run PostgreSQL in FreeBSD jail you’ll need to enable allow.sysvipc system tuneable on that specific jail:

  1. List jails:
    jls
  2. Note jail ID and use following command to enable it for that running jail:
    jail -m jid=JAILID allow.sysvipc=1

This can also be accomplished by changing ezjail jail configuration file /usr/local/etc/ezjail/JAILNAME, ensure it contains:

export jail_JAILNAME_parameters="allow.sysvipc=1"

Install appropriate version of PostgreSQL. There are many different versions but I’ll use 9.6. To install it use:

pkg install postgresql96-server

After install is finished enable it to start “at boot”:

sysrc postgresql_enable=YES
postgresql_enable: -> YES

Then initialize database:

service postgresql initdb

And finally, start the service:

service postgresql start

You sould now have running PostgreSQL within FreeBSD jail:

service postgresql status
pg_ctl: server is running (PID: 35208)
/usr/local/bin/postgres "-D" "/var/db/postgres/data96"
Tagged in:, ,
About 
Sysadmin on the everlasting journey of learning. Always in search for an opportunity to prove myself and to learn something new. My addiction is learning and my main goal is to excel in every aspect of Linux/Unix system administration.

0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *