postgresql 13 数据库启动时的一些进程

悠悠 2022-12-14 13:49 87阅读 0赞

os: centos 7.8.2003  
db: postgresql 13.0

# 版本 #

# cat /etc/centos-release
    CentOS Linux release 7.8.2003 (Core)
    # su - postgres
    Last login: Tue Oct 13 15:32:19 CST 2020 on pts/0
    $ 
    $ 
    $ psql -c "select version();"
                                                     version                                                 
    ---------------------------------------------------------------------------------------------------------
     PostgreSQL 13.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
    (1 row)

# ps #

# systemctl restart postgresql-13.service
    
    # ps -ef|grep -i postgre |grep -v grep
    postgres 20343     1  0 09:17 ?        00:00:00 /usr/pgsql-13/bin/postmaster -D /var/lib/pgsql/13/data/
    postgres 20345 20343  0 09:17 ?        00:00:00 postgres: logger 
    postgres 20353 20343  0 09:17 ?        00:00:00 postgres: checkpointer 
    postgres 20354 20343  0 09:17 ?        00:00:00 postgres: background writer 
    postgres 20355 20343  0 09:17 ?        00:00:00 postgres: walwriter 
    postgres 20356 20343  0 09:17 ?        00:00:00 postgres: autovacuum launcher 
    postgres 20357 20343  0 09:17 ?        00:00:00 postgres: stats collector 
    postgres 20358 20343  0 09:17 ?        00:00:00 postgres: logical replication launcher

# lsof #

# lsof |grep -i /var/lib/pgsql/13/data |sort -n -k 2
    postmaste 20343            postgres  cwd       DIR              253,0      4096   35122767 /var/lib/pgsql/13/data
    postmaste 20345            postgres    7w      REG              253,0       168  101807531 /var/lib/pgsql/13/data/log/postgresql-Wed.log
    postmaste 20345            postgres    8w      REG              253,0      3866  101807534 /var/lib/pgsql/13/data/log/postgresql-Wed.csv
    postmaste 20345            postgres  cwd       DIR              253,0      4096   35122767 /var/lib/pgsql/13/data
    postmaste 20353            postgres  cwd       DIR              253,0      4096   35122767 /var/lib/pgsql/13/data
    postmaste 20354            postgres  cwd       DIR              253,0      4096   35122767 /var/lib/pgsql/13/data
    postmaste 20355            postgres    4u      REG              253,0  16777216   69862075 /var/lib/pgsql/13/data/pg_wal/000000010000000000000076
    postmaste 20355            postgres  cwd       DIR              253,0      4096   35122767 /var/lib/pgsql/13/data
    postmaste 20356            postgres    4u      REG              253,0      8192  101806840 /var/lib/pgsql/13/data/global/1262
    postmaste 20356            postgres  cwd       DIR              253,0      4096   35122767 /var/lib/pgsql/13/data
    postmaste 20357            postgres  cwd       DIR              253,0      4096   35122767 /var/lib/pgsql/13/data
    postmaste 20358            postgres    4u      REG              253,0         0  101806864 /var/lib/pgsql/13/data/global/6100
    postmaste 20358            postgres  cwd       DIR              253,0      4096   35122767 /var/lib/pgsql/13/data

如果匹配 postgres 关键字会比较多

# lsof |grep -i postgres |sort -n -k 2 | wc -l
    520