# 1. 配置内核参数
# vi /etc/sysctl.conf
kern.maxfiles=6815744
kern.maxfilesperproc=3276800
kern.ipc.shmmax=34359738368
kern.ipc.shmall=8388608
kern.ipc.semmni=1024
kern.ipc.semmns=65536
vfs.zfs.arc_max=17179869184

# 使配置生效
# sysctl -f /etc/sysctl.conf

# 2. 配置ZFS数据集
# zfs create -o mountpoint=/data/postgresql -o recordsize=16K -o compression=lz4 -o atime=off zroot/postgresql
# zfs create -o mountpoint=/data/postgresql/data -o recordsize=8K zroot/postgresql/data
# zfs create -o mountpoint=/data/postgresql/wal -o recordsize=8K zroot/postgresql/wal

# 3. 安装PostgreSQL
# pkg install -y postgresql15-server postgresql15-contrib

# 输出示例：
The following 2 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
postgresql15-server: 15.6
postgresql15-contrib: 15.6

Number of packages to be installed: 2

The process will require 150 MiB more space.

Proceed with this action? [y/N]: y
[1/2] Installing postgresql15-server-15.6…
===> Creating groups.
===> Creating users
===> Pre-installation configuration for postgresql15-server-15.6
[2/2] Installing postgresql15-contrib-15.6…
Extracting postgresql15-contrib-15.6: 100%
=====
Message from postgresql15-server-15.6:

The PostgreSQL port has a collection of “side orders”:

postgresql-docs: all documentation
postgresql-contrib: many additional features
…

# 4. 初始化数据库
# service postgresql initdb

# 输出示例：
The files belonging to this database system will be owned by user “postgres”.
This user must also own the server process.

The database cluster will be initialized with locale “C.UTF-8”.
The default text search configuration will be set to “english”.

Data page checksums are disabled.

creating directory /var/db/postgres/data15 … done
creating subdirectories … ok
selecting dynamic shared memory implementation … posix
selecting default max_connections … 100
selecting default shared_buffers … 128MB
selecting default time zone … Asia/Shanghai
creating configuration files … ok
running bootstrap script … ok
performing post-bootstrap initialization … ok
syncing data to disk … ok

Success. You can now start the database server using:

pg_ctl -D /var/db/postgres/data15 -l logfile start

# 5. 启动PostgreSQL服务
# sysrc postgresql_enable=”YES”
# service postgresql start

# 输出示例：
2026-04-04 10:00:00.000 CST [12345] LOG: starting PostgreSQL 15.6 on amd64-portbld-freebsd14.0, compiled by clang-17.0.6, 64-bit
2026-04-04 10:00:00.000 CST [12345] LOG: listening on IPv4 address “127.0.0.1”, port 5432
2026-04-04 10:00:00.000 CST [12345] LOG: listening on Unix socket “/tmp/.s.PGSQL.5432”
2026-04-04 10:00:00.000 CST [12345] LOG: database system is ready to accept connections

# 1. 安装Nginx
# pkg install -y nginx

# 输出示例：
The following 1 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
nginx: 1.24.0_13,3

Number of packages to be installed: 1

The process will require 5 MiB more space.

Proceed with this action? [y/N]: y
[1/1] Installing nginx-1.24.0_13,3…
Extracting nginx-1.24.0_13,3: 100%
=====
Message from nginx-1.24.0_13,3:

Recent version of the NGINX introduces dynamic modules support.
…

# 2. 配置Nginx
# vi /usr/local/etc/nginx/nginx.conf

# 添加以下配置
worker_processes auto;
worker_rlimit_nofile 65535;

events {
worker_connections 65535;
use kqueue;
}

http {
include mime.types;
default_type application/octet-stream;
sendfile on;
keepalive_timeout 65;

server {
listen 80;
server_name localhost;

location / {
root /usr/local/www/nginx;
index index.html index.htm;
}
}
}

# 3. 启动Nginx服务
# sysrc nginx_enable=”YES”
# service nginx start

# 输出示例：
Performing sanity check on nginx configuration:
nginx: the configuration file /usr/local/etc/nginx/nginx.conf syntax is ok
nginx: configuration file /usr/local/etc/nginx/nginx.conf test is successful
Starting nginx.

# 4. 配置PF防火墙
# vi /etc/pf.conf
ext_if=”em0″
tcp_services=”{ 22, 80, 443 }”

block in all
pass out all keep state
pass in on $ext_if proto tcp from any to any port $tcp_services

# 启动PF
# service pf start

# 配置Zabbix Agent
# vi /usr/local/etc/zabbix5/zabbix_agentd.conf
Server=192.168.1.100
ServerActive=192.168.1.100
Hostname=fgedudb01.fgedu.net.cn

# 启动Zabbix Agent
# sysrc zabbix_agentd_enable=”YES”
# service zabbix_agentd start

# 输出示例：
Starting zabbix_agentd.

# 配置Node Exporter
# sysrc node_exporter_enable=”YES”
# service node_exporter start

# 输出示例：
Starting node_exporter.

# 查看系统性能
# top -n | head -15
last pid: 12345; load avg: 0.10, 0.05, 0.01; up 0+01:23:45 10:00:00
62 processes: 2 running, 60 sleeping
CPU: 2.5% user, 0.0% nice, 1.2% system, 0.1% interrupt, 96.2% idle
Mem: 124M Active, 2048M Inact, 58G Free, 1024M Cache, 2048M Buf, 32G Wired
Arc: 15G Total, 12G MFU, 3G MRU, 256K Anon, 128K Header, 2G Other
8G Compressed, 32G Uncompressed, 4.00:1 Ratio

PID USERNAME THR PRI NICE SIZE RES STATE TIME WCPU COMMAND
1234 root 1 20 0 256M 128M select 0:05 0.50% nginx
1235 postgres 1 20 0 512M 256M select 0:10 0.30% postgres
1236 root 1 20 0 128M 64M select 0:02 0.10% sshd