http://200yi.com/ff_internal/ 2026-04-28T01:46:38+0800 http://200yi.com/ff_internal/ http://200yi.com/ff_internal/lib/tpl/mnml-blog/images/favicon.ico text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:PostgreSQL:Project:PostgreSQL%E6%9F%A5%E8%AF%A2%E5%90%AF%E5%8A%A8%E8%BF%87%E7%A8%8B&rev=1687008318&do=diff 本文PG代码版本为：REL_14_STABLE（PG 14稳定分支）。 psql连接创建服务进程 客户端psql连接PG server成功后，PostMaster（守护进程）会fork出来一个服务进程（Backend），如下所示： [yz@localhost ~]$ ps -ef | grep postgres yz 14560 1 0 11:25 ? 00:00:00 /home/yz/postgresql/pg_bin/bin/postgres -D /home/yz/postgresql/pg_data yz 14627 14560 0 11:25 ? 00:00:00 postgres: checkpointer yz 14628 14560 0 11:25 ? 00:00:00 postgres: background writer yz 14629 14560 0 11:25 ? 00:00:00 postgres: walwriter yz … text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:PostgreSQL:Project:PostgreSQL%E8%BF%9B%E7%A8%8B%E7%BB%93%E6%9E%84&rev=1687008318&do=diff 转自：https://www.cnblogs.com/xibuhaohao/p/11062723.html 本文主要讲述了PG的几个主要进程，以及PG的核心架构。进程和体系结构详见下图： [img] 从上面的体系结构图可以看出来，PG使用经典的C/S架构，进程架构。在服务器端有主进程、服务进程、子进程、共享内存以及文件存储几大部分，下面着重讲述服务器端的进程部分：__________*___________________________________________________________________________________… text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:PostgreSQL:Project:PostgreSQL%E6%95%B0%E6%8D%AE%E7%9B%AE%E5%BD%95%E7%BB%93%E6%9E%84&rev=1687008318&do=diff 转自：https://www.jianshu.com/p/cd8c5b988e52 根目录介绍 data ├── base # use to store database file(SELECT oid, datname FROM pg_database;) ├── global # under global, all the filenode is hard-code(select oid,relname,relfilenode from pg_class where relfilenode=0 order by oid;) ├── pg_clog # dir of transaction commit log │ └── 0000 ├── pg_commit_ts ├── pg_dynshmem ├── pg_hba.conf # client authentication config file ├── pg_ident.conf # use… text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:PostgreSQL:Project:PostgreSQL%E6%BA%90%E7%A0%81%E5%B7%A5%E7%A8%8B&rev=1687008318&do=diff 官方git仓库 * postgresql.git GitHub上的镜像 * postgres project GitHub主站境内访问不稳定，可以尝试从 镜像站 进入。 text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:PostgreSQL:Project:PostgreSQL%E6%BA%90%E7%A0%81%E4%B8%AD%E7%9A%84%E6%9C%AF%E8%AF%AD&rev=1687008318&do=diff IPC POSTGRES inter-process communication IPCI IPC interface shm/shmem * shm：shared memory * toc：table of contents * shm_toc：shared memory segment table of contents * shm_mq：shared memory message queue dsm dynamic shared memory dsa text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:PostgreSQL:Project:pgcheck%E5%B7%A5%E5%85%B7&rev=1687008318&do=diff