# 正常启动数据库
gs_ctl start -D /opengauss/fgdata

# 以单用户模式启动
gs_ctl start -D /opengauss/fgdata -m single

# 查看启动状态
gs_ctl status -D /opengauss/fgdata

# 查看启动日志
tail -n 100 /opengauss/fgdata/pg_log/postgresql-$(date ‘+%Y-%m-%d’).log

# 检查端口占用
netstat -tlnp | grep 5432

# 检查磁盘空间
df -h

# 检查内存使用
free -m

# 尝试启动数据库
gs_ctl start -D /opengauss/fgdata
# 输出示例：
# waiting for server to start….2024-01-01 10:00:00.000 CST [12345] FATAL: could not create shared memory segment: No space left on device
# 2024-01-01 10:00:00.000 CST [12345] DETAIL: Failed system call was shmget(key=5432001, size=1073741824, 03600).
# 2024-01-01 10:00:00.000 CST [12345] HINT: This error usually means that PostgreSQL’s request for a shared memory segment exceeded available memory or swap space, or exceeded your kernel’s SHMALL parameter. You can either reduce the request size or reconfigure the kernel with larger SHMALL. To reduce the request size (currently 1073741824 bytes), reduce PostgreSQL’s shared_buffers parameter (currently 128MB).
# 2024-01-01 10:00:00.000 CST [12345] LOG: database system is shut down
# stopped waiting
# gs_ctl: could not start server
# Examine the log output.

# 检查内存使用情况
free -m
# 输出示例：
# total used free shared buff/cache available
# Mem: 1024 800 50 100 74 50
# Swap: 0 0 0

# 解决方案：增加内存或减少shared_buffers参数
gsql -h 192.168.1.10 -d fgedudb -U fgedu -c “ALTER SYSTEM SET shared_buffers = ’64MB’;
“

# 问题1：端口被占用
# 启动错误：FATAL: could not bind to port 5432: Address already in use
# 解决方案：检查并终止占用端口的进程
netstat -tlnp | grep 5432
# 输出示例：
# tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 12345/postgres

# 终止进程
kill -9 12345

# 问题2：配置文件错误
# 启动错误：FATAL: syntax error in file “/opengauss/fgdata/postgresql.conf” line 123: invalid value for parameter “shared_buffers”: “abc”
# 解决方案：修正配置文件中的错误
vi /opengauss/fgdata/postgresql.conf
# 将shared_buffers = ‘abc’修改为shared_buffers = ‘128MB’