PostgreSQL in a FreeBSD jail

• Ensure IPC is enabled in the jail:

postgres {
        $id = "11";
        path = "/usr/local/jails/containers/${name}";
        allow.sysvipc=1;
}

Then in the jail…

• Install and init the thing:

# jexec postgres
# pkg install postgresql18-server
# service postgresql enable
# service postgresql initdb

• Ensure we can talk to it. Make sure the data path matches the version.

printf '%s\n' "host  all  all  10.0.0.0/24  trust" >> /var/db/postgres/data18/pg_hba.conf

• Update the line infg